Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ftook
  • Order by date
  1. ftook

    Extract numbers from text

    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 &...
  2. ftook

    Extract numbers from text

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

    Dcount syntax for Yes/no field

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

    Dcount syntax for Yes/no field

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

    What is a large Database

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

    What is a large Database

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

    dlookup using null criteria

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

    dlookup using null criteria

    Thank you Ed - worked great ***
  9. ftook

    dlookup using null criteria

    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 ?
  10. ftook

    combo box active selection

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

    combo box active selection

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

    Cancel a cancel statement

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

    Cancel a cancel statement

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

    Dmax problem - Expected end of statement

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

    Dmax problem - Expected end of statement

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

    Dmax problem - Expected end of statement

    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]"...
  17. ftook

    Datasheet field info replicate

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

    Record not writing to table

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

    Record not writing to table

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

    XP home domain connection

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

Part and Inventory Search

Back
Top