Search results

Thanks! to JHB, I would have gladly pressed the thanks button, but there was none! I do appreciate your response! Alas, I thought of the table field length myself, but that was not the problem. As it turns out, the problem was that the wizard was inserting the full name of the state, not the...

Dear CJ_London, Thanks for the ideas, but what I really want is to hide the Access UI. It may not be possible to do what I want, but wanting is free.

Dear CJ_London, Thanks! Those are some real possibilities. I think I could use the second to come the closest to my original intentions.

I had a text box in a contacts DB form for the State field (Named txtState). It worked fine. I decided to replace it with a combo box. Now not only will it not display the existing values, but to rub salt in the wound it won't allow me to select from the drop down list. The error message that...

Thanks to CJ_LONDON! I'M sorry, I guess I didn't explain myself well. What I want is to have a picture or blank screen behind the form. Years ago, I used to work with Access 97 and I seem to remember doing that. I could be wrong, its been a hard decade or so.

Happy Thanksgiving everyone (in the US, that is)! I would like to have either a picture or a blank screen behind my form. Is that doable? I have tried to Google that but can't seem to come up with anything.

Thanks again! To spikepl, I am learning over and over again (it takes a lot of repetition for us knuckleheads) about the power of Google. I'm sure part of the problem is my underlying hatred for the company. Just the company, mind you not the search engine, I won't use any other. :o

Thanks! To boblarson, I appreciate the input!

Thanks! That did it!

Thanks, I mean that the error message implies someone or something else has it open. Why would it throw an error about having the file open?

C:\Users\OBBurton\Documents\ADOExamples.accdb

ADO vs DAO any opinions? I'm struggling with an ADO code example from a book (WROX's "Beginning Access 2007"). Anyway, I keep getting an error which I explained in another post. In my searching on line I found an opinion that DAO is superior to ADO for use in Access. I know that ADO is capable...

Hi, I have a problem with making an ADO connection. Access raises an error saying that my file is already in use. It is not. What could cause that? Here is a screen shot of the error with the code in the background. It is choking on the line: cnADO.Open strConnection The screenshot: Help!?!?

Hi, Posting again because my error message changed. It still hangs on the connection string, though. "cnADO.Open strConnection" to be exact. Hope somebody can help me with this, what I have found on line doesn't help much. :confused:

Hi, I am trying to learn how to use ADO and I am getting an error message about the connection string I am using. I adapted it from an example found in WROX's "Beginning Access 2007 VBA". All of the examples to this point have worked fine but this one hangs up on the connection string. Attached...

Thanks for replying! I tried adding .MoveNext but it now gives me an error message: " No current record". It also stopped saving any value at all to the table. I had used .MoveNext on t6he other end of the with statement, but I didn't think I needed it so I took it out just before I posted. I...

Hi, I am using DSum to total some records located in a subform. I have code to save the value returned by DSum to a table on a lost focus event. It works great except for one thing. The value saved is always one record behind. The save code is: Dim dbs As dao.Database Dim rst As dao.Recordset...

Many Thanks! My appreciation is real but my ignorance is greater still; I don't know where to find the thanks button. :o

Dear Contractor, Thanks again, for all the help. I don't know if you will see this since I marked the thread solved, but I have discovered a new problem. It was apparently caused by the change we made to the db. The issues I was having originally seem to be solved by removing the tblInvDetail...

Thanks again for all the help!