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 derfloh 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
  • Content: Threads
  • Order by date
  1. 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
  2. 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
  3. 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...
  4. 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 ?
  5. 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.
  6. 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
  7. 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]"...
  8. 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.
  9. 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...
  10. ftook

    XP home domain connection

    Im a bit confused, I have set up windows server 2003 std and have created domain tu.local, i have also set up and linked 4 client pc's with vista business. the main requirement at the moment is to file share from the server. I know that XP and Vista home cant link to a domain. but i tried to...
  11. ftook

    No of Sever CAL's required

    I have a need to install windows 2003 server in an office of 25 users, basically just for file sharing (MS access database), does this mean i need the windows server 2003 - 5 CAL version along with a further 20 CAL license, my question is because im only using file sharing, do i have to have the...
  12. ftook

    First time server 2003 install

    Im new to installaing W.server 2003, so please forgive the basic level of question, but im now installing it on a pc. I need to use it as a file sharing system only. Am i correct in thinking that I : 1. install os 2. install active directory 3. create users 4. share folders i will be linking...
  13. ftook

    First time server 2003 install

    Im new to installaing W.server 2003, so please forgive the basic level of question, but im now installing it on a pc. I need to use it as a file sharing system only. Am i correct in thinking that I : 1. install os 2. install active directory 3. create users 4. share folders i will be linking...
  14. ftook

    Remain on field if null or 0 entered in datasheet view

    I have a subform in datasheet veiw and need to remain on the input field / record if null or zero is entered, the problem ive got is that if i press enter the control moves to next field and if i press up/down arrow the control moved to same field but next/previous record and even if the mouse...
  15. ftook

    Vista share folder simultaneous users ?

    I have been asked to develop a small access database for a company that has 15 vista machines (i think they have been installed with Vista home), i need to reside the master database on a shared folder in a pier to pier setup (lets say on master1 pc - shared folder dbase). There is a limit no...
  16. ftook

    Shared Access Problems

    Have not posted much for a while - been busy but I have a problem where 2 users need to access an mde file, but I have had different results as to who can access it, firstly when user(1) has the file open, when user(2) tries to access the file the file doesn't open, but when user(2) opens the...
  17. ftook

    Extend Debug Knowledge

    I am in the throws of developing a couple of small access solutions for 2 companies and am thoroughly enjoying the programming and learning stages (with the help of this forum aswell), but i beleive that i am not best utilising the debug facilities to assist me. Is there any tutorial / tips on...
  18. ftook

    Public statement problem

    I have 2 forms (forma, formb) and i have declared public variable as integer in forma (dtype), based upon button press in forma set dtype to 1 or 2 and open formb, then when selection made on combo box set controla to 1 or 2 (value of dtype), doesnt seem to set controla and also has affect on...
  19. ftook

    Does'nt like - Not Like

    I need to filter all Flint* type door styles but I can't seem to get the Not Like working as below : If (Me.slw < 740 And Me![Door Style] not Like "Flint*") Or Me.slw > 900 Then gives expected : expression any ideas please ?
  20. ftook

    Control with wierd value

    I have a control on a form and perform calculations based upon input into the control, for some reason the control has a value of 13266, and whatever I enter into the control is ignored and this number is taken as its value, I cant see any difference between this control and another control on...

Part and Inventory Search

Back
Top