Search results for query: *

Hi All. Just wondered if anyone knows how to clear the clipboard contents in Access 2000 through VBA. One of my forms is generating an error on close asking the user if they want to save the "large amount of data" on the clipboard. I thought there would be a docmd.runcommand...

Nevermind. I got it now. Here is the correct syntax: "SELECT [" & strField & "] FROM tblATMBillingRates WHERE (Mbps = '" & txtSizeMB & "')" I understand the brackets around the field name since it contains a dash and VB thinks I am trying to subtract, but I...

Ok. Thanks for the advice. This is what the query SQL view generated: SELECT tblATMBillingRates.[UBR-U] FROM tblATMBillingRates WHERE (((tblATMBillingRates.Mbps)='10')); How can I write this SQL in VBA where [UBR-U] is a string field with differing values selected by the user?

Good morning All: I have the following code attached to a button using the on_click event. It is supposed to look up a rate on a table based on the field name I select from a drop down, matching the size of the circuit to the size already recorded in another table. I am getting a "Too...

Thanks Paul, this routine works great! When I use it with a report based on a parameter query, what event should I place it in to keep it from executing each time a page/section is formatted/printed. ie-I currently placed this routine in the Page event of a report based on a parameter query...

All: I am new to the Access programming world, so I apologize if this seems to be rudimentary. I have been trying at this for hours now, and I am running out of hair to pull out. My co-workers would like the following changes implemented to their tracking database: 1) a report that opens to...