Search results

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...

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.

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, 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...

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...

I am struggling with syntax for the GoToRecord command. I have a form that is linked to a Query. The recordset contains multiple records for every Invoice number (txtID). I want to move through the records one invoice number at a time. I Have tried all of the following: DoCmd.GoToRecord...

I can't seem to figure out the proper syntax for the FindFirst method. I am using several variations of this effort: Dim dbs As dao.Database Dim rst As dao.Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblInvoice", dbOpenDynaset) rst.FindFirst "rst!ID =...

I have a form that I built with the intention of creating new records. I want to convert it to use with existing records too. I can't seem to get it to look at anything but new records. I imagine it is a property setting and something very minor to a seasoned Access programmer, but it has me...

I have an invoice form named frmInvoice. It contains a subform named subInvDetails. I am trying unsuccessfully to transfer a calculated subtotal from a text box in subInvDetails to a total in a text box in frmInvoice. Is there a way to do this? I have tried everything I can think of but I can't...

Suddenly most of my ribbon functions are greyed out. I noticed it when I was trying to change a simple format. I tried closing outlook and reopening it but nothing is changed. I also tried other databases and still no dice. What have I done wrong?

I have a field in a table that keeps rounding the data entry off. It has identical properties to the field next to it but one rounds and the other does not. I tried deleting the field and creating a new one. I tried renaming it. I am sure it is just something I don't know about access but I am...

Hi, My name is Richard Burton but I go by OB. I started an intro a few minutes ago and inadvertently knocked myself off the website. I don't know if my previous post was dropped or not so I'll start over. Forgive me in advance for the dumb questions I'll be asking. I am 63 and have very little...