Recent content by rhodes92

I knew it was going to be something stupid that I did wrong. Thank you guys so much, another set of eyes was needed, not sure how many times I missed that lol

Okay, got the upload to work, I tried the new syntax and I get the same problem, it does find the record but brings up a new record in front of it. Its on the form tickets when I click the open button

Not exactly what I am looking for, but still a good analogy that I will implement as I need to set that up as well. The code that I used for the combo box is this Me.Description = Null Me.Description.Requery Me.Description = Me.Description.ItemData(0) now I know that the Me.Description =...

Hello all, so I have a form that I have based one combo box on another one, basically I have a list of parts with part numbers and descriptions, when I put in the part number it brings in the description, all works well and I have no issues with that. The problem that I am having is that I...

for some reason it doesnt want to let me attach the db

not sure, havent been able to find it. I did make a work around, I added code to navigate to the first record when I hit the button and it seems to be working. It s not pretty but its doing the job.

It is close to working with your fix i used this DoCmd.OpenForm "Ticket Entry", , , "[Ticket Number] = " & Me.[Ticket Number] What it does do is opens the form, but it shows two records, a new record and the record that I want, It opens on the new record then if I navigate back I get the...

No I know this one has been done, and I have a form with a button that this works on. Here is my problem. I have a list of parts in a continuous form, I added a button to open that specific record in a detail view and it works just fine. I used an open form macro and put in the criteria...

Basically what I am trying to do is I have two tables set up one for my Invoices and one for my Accounts receivable and what I want to do is bring the information from the Invoice into the table for AR without having to retype all of the fields that are the same, such as the invoice total, GST...

Hello all, My name is Todd and I live in Canada, joined this forum as I have been teaching myself access for the last few months and have started hitting roadblocks as it is starting to get past my knowledge level, so I figured I would pick the brains of some experts. Thanks