Help
in [Access]
|
Migrating to 64 bit access db solution Hello all. I don't know if anybody encountered upgrading to 64 bit. I have an older database that I need to upgrade and place on office 64bit machine. I am getting a compile error message: The code in this project must be updated for use on 64 bit systems. Please review and update declare statements and then mark t... 24 Jan 2010 20:20
Re-Establishing Connection to Back-End Hi everyone, I have an application that uses a FE/BE configuration. I maintain a connection to a local backend MDB containing temporary data and standard lookup tables. I do this because we have a slow internet connection between our satellite office and the main office where our server resides; so every time... 2 Feb 2010 14:38
Append a current record in a subform to another table I am trying to append the current record in a subform to another table with no luck. On the append query, I am appending part no, part type to another table based on Line ID. On the Line ID criteria I have the following code: [forms]![Mainform]![subform].Line ID. When running this, the query cannot find Line ... 20 Jan 2010 18:33
mail merge in access 2007 I have only done one large mail merge in access 97. Been a while. I used the code that was kindly posted by Albert D. Kallal and it worked great. Now we are just starting in access 2007 and again they want a mail merge done. Should I use the old code that worked in the past (will it work in office 2007) does ... 20 Jan 2010 14:00
Skip printing some pages in report Hello I print letters to parents informing about students absences, one page per student. If student skipped 1 session only, I am not to sent the letter. Instead of discarding pages I'd prefer not to print them. How can I not to print whole page of the report, header, footer and detals, if there is onlt 1 recor... 20 Jan 2010 12:52
fields Hi How do you get the text from one text box to be entered into two fields in separate tables? Thanks ... 18 Jan 2010 06:24
AccessXP email thru Outlook2007 Hi, I'm hoping someone can help me understand what is going on with the following senario I have AccessXP with Outlook2007 and this vba code on a form in Access which sends an email, with Outlook 'closed' this code works as long as I attach a file. If I comment out the .Attachedment Add line with Outlook clos... 15 Jan 2010 11:34
Conditional Format Hi guys, I've ran out of condtions on the conditional format tool access provides, so I'm now using the VB code to create another rule for my form. My form consists of two columns, Product and Date Entered. I need any products to grey out after a specific date. This specific date is 01/05/08. I've tried th... 14 Jan 2010 13:31
yawn - more database bloat Hi, sorry if this has been done to death, but database bloating on a big scale again. I've inherited development of a FrontEnd - Backend database system, former has 30 odd forms, innumerable queries, reports. Linked to Backends, uses a mix of DAO updates, DoCmd.RunSQL and CurrentDb.Execute. Uses Access 2000 file fo... 13 Jan 2010 07:36
Can't get exclusive access I'm doing a small job for a client where I need to modify some vba code. When I try to change the code I get the message "you won't be able to save changes because you don't have exclusive access." It also comes up when I open a form in design mode. I made copies of both the front and back ends on my desktop and ... 13 Jan 2010 01:06 |