Search results for query: *

Thanks Guys!! Tony, you were right.. My code was old for this version of Access, which I could have fixed, but gkprogrammer had a better way of doing it than I did, anyway, so I adopted his code and it works great. I am only a sometimes Access VB programmer, so I really appreciate help by...

I am trying to see if a field on a form has the same value as a field in a particular table. The field in the table is indexed unique and Access provides messages that the field is a duplicate, but I need to trap the error and inform the user that they entered a duplicate value. I had a...

I am looking for a product which will take Access 97 forms, reports, etc. and allow for replacement from Spanish to English. We have researched Translator version 1.1 from Point Limited but have not been able to get it to work properly and did not get it resolved with the help of their...

OK, thanks. I'll work it from another point of view.

I am using a crosstab where the input table has periods (.) in the text field values which are being used as the column headings of the crosstab. Access is converting the periods to underscore characters, since a period is an invalid character in a column name. Is there a way to retain the...

We are using a C application which receives real time data and then use ODBC to update several large Access tables with inserts (with several hundred thousand rows), and deleting and rebuilding a few other smaller tables (less than 1000 rows). The database is being compacted daily which is...

Rick and Quinn7, Thanks, This will get me over the hump. I think others could use these tips, also. I'll give this a try and let you know if I have any additional problems with it. Thanks again, Larry

Rick, This is helpful. I have quite a few tables, which, I guess, I will need to reference individually, but that's fine. I could not find any example in the NorthWind database I have, which is from Access 97. There are no linked tables in that DB and I did not see anything in the modules...

I would like to be able to define the location of other Access databases having linked tables to the main application using a variable or somehow define it outside of Access in an ascii file which can be read in at runtime. With various users (not networked) they have different amounts of disk...

I am getting Dr. Watson errors at various times within a reasonably simple application, but can not isolate the code. I suspect the error may be occuring before I actually have Access blow up. Is there a readable dump or some way to identify the problem in the system? There is some VB code...

Can a property be referenced by a substituted variable?<br> <br> I want to be able to reference a property such as .width = 24 without including &quot;width&quot; but rather with a string or variant variable which I would assign &quot;width&quot; to.<br> <br> My actual situation is fields in a...

In MS Access I would like to reference a control using a string variable. If my form and control name was something like Forms![Form1]![Control1] and I want Control1 to be substituted in by appending an index to the word &quot;Control&quot; something like 'newname=&quot;Control&quot; & index'...