Recent content by ftook

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