Search results

jdraw - Thank you for your help. Is there a manual or other Websites you can recommend that will cover programming commands in more detail? The manuals I have are pretty basic (and useless). Thank you for your time.

I have a 25,000 record Table with a key. I am familiar with the MoveFirst, MoveNext, etc. commands but cannot seem to find any infomation which will tell me how to read a Table by the key - a ‘MoveKey’ command if you will. Rather than reading through all 25,000 records with the MoveNext...

For anyone who is interested I found and corrected the problem… The Macro which ran the Module (called ’SaveRecord’) consisted of seven ‘SetVal’ statements (to load the seven parameters) and a ‘Runcode’ statement which ran the SaveRecord Module. In the last line of the SaveRecord Module...

Mr. B - Thanks for your feedback. I work for a botanical garden where the scientific names of plants are italicized by convention. I am using the Module to perform data validation and was hoping to generate error messages which would then be passed back to a message area on a Form. It would...

I am familiar with the ‘UCase’ keyword to convert a string to uppercase in a Module but I cannot seem to find a keyword to make a string Bold or Italics. Is there a way I can make a string both Bold and Italicized in a Module - Bold/Italicized? Thank you.

I wrote a Macro which passes seven parameters to a Module. The Module simply takes these parameters and writes a record to a table. The problem is the Module is being executed two times, the first time writes a new record to the table and the second pass gives me a ‘duplicate key’ error. There...

I am embarrassed to say that there really was no problem with the OpenRecordSet statement, both (“Labeldata”) and (“Labeldata”, dbDynaset, dbSeeChanges) work fine. The problem was Labeldata has over 83,000 records in it and when I ran the Module when Labeldata was an Access Table it took only...

Gemma-the-husky - I Googled dbseechanges and found a Weblink which says I should do one of the following: Set Labelsold = dbs.OpenRecordset("Labeldata", dbOpenDynaset) or Set Labelsold = dbs.OpenRecordset("Labeldata", dbOpenDynaset, dbSeeChanges) I will try them on Monday and let you...

Hello, I wrote a simple Module to update records in a table (called 'Labeldata') and it worked perfectly. However, we recently converted this Access table to a MySQL table (with identical data structure) and now my Module does not work. We also installed ODBC on my PC. Below is a copy of the...

Bob - It worked like a charm, thank you again for your help, it is much appreciated!

Bob - Awesome, thank you! I didn't think of concatenation, can't wait to give it a try. The more I delve into the workings of MS Access the more impressed I am of what it can actually do. Thanks again.

I am trying to search a field in a record using the ‘Like’ keyword (e.g. Like “*Smith*”). When I use this syntax in a query it works perfectly (finding all records that have 'Smith' somewhere in the field) but when I try to run this same query from an Access Form I get no records found (I...