Thanks much. I suspected that it might be superfluous in some of the things that I copied. I have sometimes rewritten some copied code to change things a little and to gain understanding. Never used "Set". Thanks again
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...
It still doesn't give me a help screen that is VBA oriented. I typed in clicked on DoCmd.Transfer Spreadsheet and pressed F1 and got the same general macro olriented screen that I get just by pressing F1 without clicking on the expression. I typed TransferSpreadSheet in the Bing search box...
I do miss the old menus and particularly the ease of using the old menu, though I am getting used to 2007. I find the help screens almost useless in that they are so general, often referencing Word or Excel or whatever, that I use Google more than I use Access help. In designing reports, I...
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...
First-sorry that I posted this twice, but thought that I was just editing the first one. As you say, it is a design change, so makes sense that I can't add a table. Is there some command that will allow me to upload/append data (any kind, csv, access, excel) into an existing table, in runtime?
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...
Thanks for quick reply. What is bothersome is that I type the exact same code in a new module and some of the code works (sometimes). On one of the simpler sequences I rewrote as a macro, then converted back to code and worked fine. I am really puzzled. A one hour effort has lasted 2 1/2 days...
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%...
A real basic question How do you post a question? I can't find anything on the screen that indicates a way to post a question and this is the only way I can find to ask.
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...
Possible help
Coincidence extordinaire-I was going to post the same question.
For on e solution, look at my post, may 26, on http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.access.formscoding&mid=2e0ff947-cc23-4420-b2b4-54c23b5c5418
My simple code used the Sendkeys...
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...