Search results

Thanks! That did it. I would certainly never thought of that! Would you mind explaining why? I can see that The table wasn't needed, but I don't understand why having it in the query made it behave the way it did. For that matter, what led you to the problem? Always ready to learn something...

In case you are able to open the db, I just realized that the wizard used the line: "On Error Continue Next" to suppress errors. I commented that line out and am now getting the error message: "An expression you entered is the wrong data type for one of the arguments." That doesn't help me very...

I must admit that I don't know what a PHP file is. When I look the file up with Windows Explorer and click on it my db comes up. Perhaps I did something wrong when I attached the file. I'll try again and see what happens. ;) I'm not hopeful; everything I did appeared to go just like the last...

Thanks for Looking into my little problem! Here is the db: I hope I did this right and that you can make some sense of it.

I am using a main form with a sub form. but it doesn't work the way you describe. Clicking on the navigation buttons in the main form takes you through all of the records in the sub form. I have navigation buttons that I created with the command button wizard but I tried enabling the form's...

I have a form that is linked to a query which returns several rows for each Invoice Number (one for each line of detail ). Right now when I click on the command button for next or previous to move forward or backward through the Invoices I have to click once for each record. In effect you stay...

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

Yeah, I'm a real knucklehead at times, but I am persistent. Thanks again! :) .

I figured it out! I shouldn't feel so happy, since I caused the problem myself. The Record Source query for the invoice form was left as a totals query after some experimenting I did a few days ago. I changed it back to a select query and everything works fine. Thanks for bearing with me as I...

Yes most everything else runs fine. There are a few things in progress but code seems to run okay.

Nothing running that I know of. I just have my form open and nothing else going on in Access. There is one thing that might provide a hint. If I click on my new record button nothing appears to happen, but if I click on my save button I get an error message saying there is no current record. I...

Thanks! That did it, but I wish I had a better handle on the syntax of the commands. Nothing I have ever read or seen in the VBE has ever suggested stringing together a line like that. Any suggested reading or anything? :banghead:

Now I have the opposite problem. I have a command button to open a new record that doesn't work anymore. The lineI used to open a new record is : DoCmd.GoToRecord , "", acNewRec It doesn't give me an error message or anything it just doesn't work.:confused:

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

Thanks! That did the trick. I would have never thought to change that.:D

Thanks for replying! I had thought of that myself and I just double-checked it. Sadly, it is set to yes. But thanks! ;)

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

Thanks for replying! I really appreciate it. I tried to apply DSum and apparently I'm missing something. First I tried using a table as my domain: =DSum([tblInvDetail]![Rate]*[tblInvDetail]![Hours],[tblInvDetail]) but it returned a zero. So, I looked DSum up on a website about Access VBA...

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

Thanks for responding! I don't know what happened. I tried everything I could think of, but nothing helped. I searched and searched on line and found no help. I finally concluded that I would have to reinstall Access. I would have done it too, but my loving wife had put my disks "away" and we...