I get a lot of my code from web sites wherein others have already done what I want to do. I use the solution, but am uncomfortable when I don't understand the code.
Often, the word "Set" is used, like Set db = CurrentDb or Set rst = something or set xyz=nothing. I read that "Set" has...
I am designing a report. There are 3 columns with across then down structure.. Only one control is displayed. Using A2007 and A2003.
If a condition is met, I would like to start a new line on the report. I have tried this expression in control's query source for the report.
=...
As I read it, I should be able to edit values in a table that is a link to an excel spreadsheet. I make the link, but am unable to modify values. No message, just won't allow it. Any ideas? I am using A2007 with W7any help much appreciated.
I am using Office 2007 with W7 on a 64 bit computer. I used the wizard to create an openForm function, with the specific data option chosen. When I click "next", I get the proper list of fields for the form to be opened, but get only a blank field list for the form that I am in. Is this some...
When I click the VBA help on the menu on the VBA coding screen, all I get is some very vague stuff mostly about macros. Is there so some where to get the great VBA help and examples like in A2000 2003?
I have a new computer (64 bit 5i) with Windows 7. I have tried to run Ac2007for two months now and find it a horrible time consuming frustating downgrade of Access 2000. Ac 2000 runs ok, but when I try to download the latest service paks, I get error messages.
Anyone know what I can do to...
I am using A2007 in W7. With an accdb file I use the vba command DoCmd.RunCommand acCmdImportAttachAccess to import an object from another access2007 file. Afer clicking, I go through the pop-up dialog boxes and finallly get a a list of objects in the other Access file. When I convert the...
I am using A2007 in W7. With an accdb file I use the vba command DoCmd.RunCommand acCmdImportAttachAccess to import an object from another access2007 file. Afer clicking, I go through the pop-up dialog boxes and finallly get a a list of objects in the other Access file. When I convert the...
I have a file in ac2207, converted from A2000. Runs beautifully. I downloaded the AccessRunTime program and tried to make it run as accdR. Life is hell. Code that works great in accdB or ACCDE produces runtime errors under runtime and, of course, shuts down. Not all code does it, maybe 25%...
I would like to change the captions for certain fields in a table based on other criteria. I am using expressin below for a table nmed 99JS with one field named "oldName"
CurrentDb().TableDefs("99JS").Fields("OldName").Properties("Caption").Value
= "NewName"
I get an error message "Runtime...
I have an application, written in Ac2000, that works fine on other computers with Ac200 and Ac2003. One of my new users has Ac2007.
On my opening form, I open another form, maximize, and apply commands to hide toolbars (docommand.showtoolbar etc), including the database toolbar. However...
How do I create an Undo button that will do the same thing that the forms tool bar Undo does? i.e., I want to undo only the last changed field in a record when the button is clicked-NOT changes in other fields. The keyboard Escape key will do this from the keyboard, but when a button sends...
I conditionally formatted the back color of a field based on the value of another field. Works fine when the form is stand alone. When the form becomes a sub form, the conditional format quits working, as if not there. Any fix or is this a fact of life for conditional formatting? (Using...
What is the limit on number of fields for an append query, or is the limit expressed in some other way? I have one that gives me the mysterious "key violation" message, but it works ok if I remove any 4 fields. I experimented making a copy of the table that is receiving data and tried to...