I have created a datasheet form from a query everything is there. I am trying to enter data here but it will not except it here. Any help would be greatly appreciated. -- Lenee ... 9 Feb 2010 14:00
Access 2007 Read Only Issue
One of the groups in my company has an MDB file that they are running in Access 2007. Somehow it has not been converted. It will be converted once I can isolate the following problem; When I open the file on my computer, it opens with no problem, When one of the user group opens it, it opens read only. Questio... 7 Feb 2010 16:29
I have the following code in a Text Bax in a Report: =Trim("Born on" & " " & [Date of birth] & " " & ("in" & " " & [Place of Birth] & " " & Trim("and baptised this day" & " " & [Date of Baptism]))) What I would like, is to add the format command to convert the dates to dddd mmm yyyy Could anyone tell me t... 6 Feb 2010 08:35
Button Caption help
Hi to all I require help for what maybe a simple problem. I have a form frmPettyCash and on the form are 3 buttons Cmd1, Cmd2 and Cmd3 which open the spending reports for 3 employees. There is a table tblEmployees with fields EmployeeID and EmployeeName with the 3 employee names. What I would like to do is ... 8 Feb 2010 07:48
Sharing Contact Database
How can I share a Contact Database with a friend who would not have physical access to my computer? Neither of us have Sharepoint but we use Office Live Workspace. Thank you. ... 5 Feb 2010 05:03
hi ... 15 Feb 2010 01:07
How do i show the date a report or query was last run?
I am using Access 2007. I have several reports and queries which are run on a fairly regular basis. What I would like to be able to do is show the date the report was last run. Is there any way I can show this on a form which would show the name of the report or query and the date it was last run. Thank you... 4 Feb 2010 19:08
You have to have their title in the database as a separate field from first and last names. -- Build a little, test a little. "Reen" wrote: When doing a mail merge, how do I make the greeting line say "Dear Mr. Smith" instead of "Dear John Smith"? It just doesn't sound right. Thank you. ... 4 Feb 2010 12:20
Can DLookup be used to compare to a control value.
I've thought myself into a corner and am probably missing something blindingly obvious so I'd appreciate being pointed in the right direction. I have an Access database that has linked tables to 2 SQL servers. The main back end, I have full control of but the second one provides read only access to the full cont... 4 Feb 2010 08:53
Duplicate showing in query when there shouldn't be
Hi, So new to this I could pull my hair out. So go easy on me. Thank you for any help you can offer. I have 1 query that is pulling from 3 tables. In those tables there aren't any duplicate entry's yet in the query i get duplicates for some entries. I can find no correlation as to why it could be choosing thes... 9 Feb 2010 19:43