Search results

I want to thank all you for your explanations. I will work through them to learn how to better use transactions. Thanks, Mike

To Mile-O-Phile. Just one. When I responded to this I did not realize I had already responded until I posted the last reply - if that is what you are referring to. Mike

Hi, I'm using Access 2002 and I want to wrap a few things in a transaction. But things are not happening as I am expecting. For instance, within a transaction I append one record to a table. Although the table may have 100,000 records, five of them may be related to the same item and one of...

Create a constant called QUOTES and make equal to """". That is four double-quotes. Then if you want a string to be treated as a string within a string - the value in a text box - as you would in an SQL statement, you can do the following: SQL = "SELECT * FROM TableName WHERE Field = " &...

Create a constant called QUOTES and make equal to """". That is four double-quotes. Then if you want a string to be treated as a string within a string - the value in a text box - as you would in an SQL statement, you can do the following: SQL = "SELECT * FROM TableName WHERE Field = " &...

Create a constant called QUOTES and make equal to """". That is four double-quotes. Then if you want a string to be treated as a string within a string - the value in a text box - as you would in an SQL statement, you can do the following:

Create a constant called QUOTES and make equal to """". That is four double-quotes. Then if you want a string to be treated as a string within a string - the value in a text box - as you would in an SQL statement, you can do the following:

You must add a join.

After fixing the reference error, I was able to identify the other problem. In order to do what I had originally intended, I had to add a field to a table in the backend database. I did it to a copy of the backend database but forgot to do it to the real backend database. I was not thorough...

Solution! Thanks to Travis. At least to the MDB aspect of the problem. Even though none of the references showed as missing, the offending reference was OLE Automation. I suspected this one because it was the "Me" keyword that was highlighted when the error occurred. I guess the bottom line...

Thanks Travis. I will give that a try. Mike

Thanks Wayne. When what looks like a reference error shows, the word "Me" is highlighted. Mike

Thanks Wayne. I did think of that and that was why I tried to run the program as MDB instead of an MDE. But when I did this, I got what looks like a reference error. Mike

Yes I did check the references. That was the first thing I had thought about. There was no broken reference indicated.

OK. There is an assembly feature in the program where, after a product has been assembled, the program will reduce the parts counts appropriately and increase the count of the product that was assembled so that the table storing the inventory quantities would reflect the new reality. However...

Hi, I am customizing an Accounting application using my machine (OS = Windows XP) for use under Terminal Services on the server (OS = Windows 2000). I made a recent change that works on my machine but fails on the server. We are using Access 2002. What is odd about this is that, when the...

Thanks Wayne, With MS, bugs not owned up to are features. Take care. I guess I'll have to live with it. Mike

Thanks Bert. I followed your instructions and I got the same result. None of the contents of the text box was highlighted. Could there be a configuration issue? If it works for you, it should work for me. Thanks again, Mike

Hi, I have tried everything but I have yet to get these two properties to work. All I want is to have the entire contents of the text box highlighted after the text box receives the focus. I am using Access 2002 and I also have the options set to select entire field upon entry. I have tried...

After you update the value in the combo box, run the query separately with the form still open. If the query works but the form does not update, your form may be corrupt. If this is the case try recreating the form.