Search results for query: *

Thanks PHV - works great how can i now integrate that into a dcount function to again strip out each comparison field for [Internal No] field within the table i.e. compare myfield within getNum([Internal No]) If DCount("[Unitno]", "Unit Works Order Header", "[Internal No] = '" & myfield &...

Could anyone advise the best way to extract a number portion of a specific string i.e. 1234/rejnf23 - to be 123423 00277g- 99 - to be 0027799 still need the leading 00's pp3pp3pp3 - to be 333 etc

Figured it out - i post just incase it helps others with the same problem : If DCount("[tuuser]", "tuuser", "[tuuser] = '" & Me.pword & "' And Approver = True") > 0 Then

I wonder if someone could please help with the dcount syntax for a yes/no field (Approver) i have : If DCount("[tuuser]", "tuuser", "[tuuser] = '" & Me.pword & "'" And "[Approver]" = True) > 0 Then comes back with type mismatch

What worried me at first is that the database grew from 50mb to 120mb in a day, i compressed and went down to 20mb, all tables are normalised and i have set all index's (i hope) correctly. I know that the compression routine reduces the size massively and i am setting a compression routine for a...

I have started to develop a control system for a small company and the requirements are growing every day, the database will be used by 20 users eventually (we are now looking at sever 2003 to beat the 10 user limit). I fear that the database could grow quite large, what is large in terms of a...

ive extended the function, and it now gives type mismatch If DCount("[Pono]", "PO Returns", "[credit] Is Null" And "[pono] = " & Me.pno) = 0 pono is integer where am i going wrong

Thank you Ed - worked great ***

Im trying to count how many records have a null entry in field [credit], ive tried : Me.var1 = DCount("[Pono]", "PO Returns", "[credit] = ''")) [credit] is a text field doesnt seem to count correctly - can anyone help please ?

the user has to see 4 different elements of data, to much to show width wise in combo-box, thx for your suggestion.

i have a combo box selecting customer, then have 4 controls showing combobox.column(1) to combobox.column(4), the contents of these control change afterupdate, is there any way i can get them the controls to update if i just FLOAT over each combo data line, ie not press down-arrow.

I have the following code on a form control If IsNull(Me.Code) Or Me.Code = "" Then Cancel = True works great to prevent null input, but i also have an exit command button to close the form, but if cursor on the me.Code control, exit button cannot be pressed. Any ideas please

I have the following code on a form control code If IsNull(Me.Code) Or Me.Code = "" Then Cancel = True /code works great to prevent null input, but i also have an exit command button to close the form, but if cursor on the me.Code control, exit button cannot be pressed. Any ideas please

Thanks - worked great, i also looked up how to insert code in a monospace font. Thanks again for your help

DoCmd.RunSQL "INSERT INTO Guarantee ( CustID, [Unit No], [Warranty No], [Start Date], [End Date], Period, [Value], [Serial No], Company ) SELECT Forms!Guarantee!Customer,DMax("[Warranty No]", "Guarantee", "[Company] = '" & Me.Company & "'") + 1, Forms!Guarantee!start, Forms!Guarantee!end...

I have the following in a normal form, coded to a button and it works fine : me.test = DMax("[Warranty No]", "Guarantee", "[Company] = '" & Me.Company & "'") + 1 i then included the same statement into a sql update command and get "Expected end of statement" error with the "[Warranty No]"...

I have a datasheet within a form where the user can enter multiple records, is the a way i can replicate the input from (record 1 - field A), when (record 2 - field A) has focus Basically the input of this field will be mostly the same once record 1 - field A has been updated.

thank you both for your help - i will try the suggestions

I have a form that has various inputs, combo boxes, radio buttons etc, the form is bound to a table. I am getting a problem that every now and again the user is entering the data but as SAVE button (a macro button) is selected the record does not write to the table and there is no warning that...

thanks again for the info - have played with settings seems really powerfull, i have set the server up at home to practice, the clients (my daughter) cant even change her system time, do i change this ability within the policy GPO or do i set it against her user profile properties. When you set...