RunCommand acCmdRecordsGoToLast John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access...
Bernie- That's not a statement at all. I suspect it might have been a comment in Bill's code. Put a single quote in the first character on that line. John...
Bernie- That should not trigger a warning message. Using Execute bypasses those warnings. It has to be somewhere you're doing a RunSQL or OpenQuery. John...
There is no builtin function in Access to calculate a Median. You need a custom function. Paste the code below in a Standard module and then calculate the...
Hello, My problem is I have 2 tables in SQL Server 2000, 1 table in 1 database and a copy of that table in an Access database table. How or what is the best...
Thanks John, you have pointed me to several good ideas and helped my learning curve emensely. I will work on this over weekend. One question though: some of my...
Andre- I'm not sure that you can do it in the Open event. How would the Open event decide whether to go into Data Entry mode? John Viescas, author Microsoft...
Thanks bill that info. give some answers to this problem. Is it possible to suppress or stop that dialog box? I hope someone reply soon... hehehe today is the...
Hi, I have a form with 2 sub-forms. On the main form I have a button called "change" which when pressed would lookup 2 inventory tables, find the amount sold,...
Is there a way to get PasteSpecial to work from Access/VBA? The break occures at line 3 below (see code). The compile error says "Variable not defined and...
I was just wondering if there was a list out there of standard field sizes. Like Last Name how long should that be and a note field in SQL how big should I...
Toukey- Do you have indexes on the colour and size fields in jersey_inventory and pants_style and psize fields in pants_inventory? If not, then adding those ...
Bernie That won't trigger the warning. As I said, .Execute suppresses that. Try pressing Ctrl+Break when you see the warning. That might bring you to the line...
Hi, John, I had another issue with my reference - I needed the subform.form!controlname instead of just subform.controlname .... So instead of trying to set...
When I use the Outlook library, I always write what I need and then go back and make everything late-binding and remove the library as a reference since users...
Cory Although you specified the table cannot be linked directly, I may have a workable solution for you. Create a view in the MSSQL database and set...
Clem As far as I know, that print box cannot be suppressed. I even tried using Echo False DoCmd.OpenReport... Echo True The box still showed. What's the big...
Dunno, Mike. Excel Automation and I rarely get along. Could it be that you are pasting into the same selection as the copy? Regards, Bill Mosca, Microsoft...
Myra I would never attempt to create such a list. It depends on the database. When you gather your requirements from the client, ask him for this info. If you...
Thanks Bill! Does anyone else know the answer? I'm trying to use PasteSpecial to copy/paste formulas back to values within Access/VBA. Thanks again! Mike...
Probably a dumb question, but will Access 2000 run on Vista? I will be upgrading from XP to Vista. I don't want to purchase 2007 until after the new computers...
Thanks for the reply Bill. I think the DoCmd.TransferText could only supports a database/query objects. The one that I am going to export is a report object...
I think I am at the point of giving up. I have compile tested to remove any rogue code. I then put the visit form into data entry mode and "killed" the...
Hi Shelly, in the table design, the AllowZeroLength property is probably False for that field ... but there is no reason to set it to ZLS (zero-length string),...
Yes, A2000 should run OK on Vista. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access...
I just tried the single quote and elimintated the space between Target and DB. works fine now. Still trying to make the warning for using a hyperlink go...
Hi Bill, I tried the control break when I clicked on the hyperlink. The new warning is the Access can't follow the hyperlink because it couldn't create the...
I have a database that has an import specification associated with a flat file. How do I look at it and what columns get mapped to which fields in the table...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
