Search results

I seem to have 11115 records when I go into datasheet view of my form and yet there should only be 9230 according to the main table. Seems some of my records have been duplicated but only in the datasheet view. I don't understand how/why it did that and how to fix.:confused:

I have a query that has three parameters...a start date, an end date, and a person. To avoid errors and to make it simple, i would like to set it up so that there is a list to choose from. A date selector would be great too. Thanks.

sigh...blonde moment. Thanks pbaldy!!!!! Works great!

I'm almost there... Private Sub PrimeVend_DblClick(Cancel As Integer) DoCmd.OpenForm "Suppliers", , , "SupplierName ='" & Me.OnDblClick & "'" End Sub and it opens to a blank "supplier". what am i missing to get it to open to the supplier that is displayed in my product form?

I'm trying to create a dblclick event that will open the "supplier" form but to the one that is currently on screen. My weakness is creating codes. Thanks.

I have a field that I want to automatically generate the number using the last one. My numbering is SPF828 so I want the next one to auto-generate SPF829. this is a text field.:confused:

Got it!!! :) happy dance!!!!

Now i have PART of the information showing. I have the dealer name...I can pull up the address information but I'm having trouble with my Trim formula and I'm creating it exactly like all my others.

I've done that and my query is pulling all the information that I want. I just can't get the report to show the information.

I have a report that I want to pull specific information from a specific record. I have already created two reports that do this but now I want a third that has different information. Forms 1 & 2 pull the Serial Numbers and color Form #3 I want it to pull the Dealer name and then find the...

jdraw: is there a better way for me to explain what I have and what I need to do?

I've done that but if I make the control source of the check box the "Serial Number" field, the serial number field changes to a -1 when click the check box.

I understand that but when I create a check box I don't see where to make it "bound" to a field.

this is what it looks like

so how do i make it "bound"?

what do i do to what i have to fix it. i'm fairly new and need directions.

Here is what things look like and the code. Private Sub LOCK_CHASSIS_VIN_AfterUpdate() Me.Serial_number.Locked = Nz(Me.LOCK_CHASSIS_VIN, 0) End Sub

I have a check box to lock my field but if I click the check box it locks/unlocks the field for ALL the records. Also, if I leave the form and come back it, it is just a shaded box (neither checked or unchecked) and is therefore unlocked so I have to "lock" it again which is pointless because I...

vbaInet: I put it in the after update event I've encountered an issue though. When I check/uncheck the check box, it checks/unchecks ALL the records, not just the one I'm on. Also, when I go back into my database, I have to check the box again each time. Even if I just go from design view...

Perfection! Thank you!!!!