Search results

Worked like a charm all I typed was customer extended and it found them all thanks

It was the northwind data base I have been changing it to meet my needs. I no longer have a customer it is now a machine table. The Customer Extended Query is now a machine extended Query. I have been able to change every thing so far to get it to work but this one has be stumped. I dont know...

I have look in the Event procedures on the form sand the fields in the form It a Access data base The start of the error statement is strSQL=

I need to find where this statement is I can not find it anywhere. I though there may be in a special file some where strSQL

Can some one p-lease tell me where I can find this as I need to change Customer Extended to Machine Extended. strSQL='SELECT*FROM [Customer Extended]WHERE [ID]=2'

I have a form called Jobs on that form I have a sub form Parts. As i enter part numbers each one returns a status for that part. ie: in stock, no stock or on order. What I want to do is look at all the parts and return a result if they are all in stock so that I can then use that to change the...

Is it only used in the code because I have a table that I use for the fields in my form to tell me the status.Are the two related or separate. If I change one do I need to change the other

Thanks I found it in the modules. I will have a play with it and see iff I can get my for to do what I want.

Thanks. What does this StatusEnum do? Is it needed.

Im sorry I do not know. I have started with the north wind data base and this is the code that was on the form. Where can i find this information

Could some one please explain to me what this means. Dim Status As CustomerStatusEnum I get a user-defined type not defined when I open my form [Sub SetFormState(Optional fChangeFocus As Boolean = True) If fChangeFocus Then Me.Machine_ID.SetFocus Dim Status As CustomerStatusEnum...

When I set the lay out of a form on my laptop it all looks good when I put it on a larger screen I get gaps between fields. I see that some of the fields have a dotted box around them. This makes them all move to with each other when you move one. I think that this is causing my problem as they...

Just a note to thank you. My problem was the one described in the link. I solved it in another way. I found that the form was getting data directly from the table. I made a separate query and used that fixed the problem. Again thanks

I dont know that much about code but should I be placing my form name in the brackets

I am working with the northwind database and adding to it for my need. I have a parts detail form that when opens all the fields are empty. It is set to open to a new record. There is a combo box in the header that allow you to chose a part number and then all the information is displaced in the...

I am not sure where to ask this question. I have a table called parts a field in that table called part number, this is a text field The part number from my suppliers can be any format ie; 245-678-00, 8W-957, 89 07 68, 568.897.RB When some one enters a new part if they do not get the - . or...

You guys are legends I have be trying to do this for 4 days Thanks so much

Private Sub Product_Code_BeforeUpdate(Cancel As Integer) Cancel = Nz(DCount("1", "Products", "Part Number='" & [Product_Code] & "'"), 0) > 0 If Cancel MsgBox "Part Number already in table." Me.Product_Code.Undo End If End Sub

I get a syntax error with the If Cancel highlighted red

so I tried this and it does not seem to work [code] Private Sub Product_Code_BeforeUpdate(Cancel As Integer) On Error GoTo ErrorHandler Refresh End Sub ErrorHandler: ' Resume statement will be hit when debugging If eh.LogError("Product_Code_AfterUpdate") Then Resume End Sub