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 Chriss Miller 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: *

  1. cken21

    Userform with MS Access Backend, Search tool

    Hi, Sorry for the late reply here. That has all worked brilliantly you really helped me out here. Cheers
  2. cken21

    Userform with MS Access Backend, Search tool

    Sorry, this is my fault. I havent explained it correctly. The actual code i am using looks like this Set rs = New ADODB.Recordset searchstring = "SELECT ScriptID, CaseID, Progress, Wizard, EForm, DateStart, PEGA, Overall, DateComplete, Defects, Comments FROM PETesting WHERE [CaseID] =...
  3. cken21

    Userform with MS Access Backend, Search tool

    Thanks Andy, this has all been great. I have one last question. When i am searching for the record i need it will not display the null values - is there any way around that? e.g Initially the user will only complete 1 field tb1, the next user needs to search using this value to return the...
  4. cken21

    Userform with MS Access Backend, Search tool

    Thanks both those worked great. I have one question though, how would i display/update values to a combo box?
  5. cken21

    Userform with MS Access Backend, Search tool

    Hi, I have been searching forums and google all week to try and crack this, and i think i am most of the way there. I have an excel userform which currently collects data through Textboxes, Combo boxes, Checkboxes etc. What i need to do is pull this information off the database and display it...
  6. cken21

    Pull records from Database using Excel userform

    Hi, I have a userform which records a range of Data onto an external database table. I was wondering is it possible to retrieve these records one at a time into textboxes on another userform based on a condition. I know this seems vague but i can't find a solution using google or VB forums...
  7. cken21

    Search tool in front end Excel Userform

    So sorry not able to post the code as the file is saved on my work system, good news is I did manage to resolve the issue before I left for the day. The error was on the excel sheet that the SQL statement copies the data. Thanks for the time and effort you put into answering my question...
  8. cken21

    Search tool in front end Excel Userform

    Sorry, by nothing happens i mean the sql statement returns the same value
  9. cken21

    Search tool in front end Excel Userform

    Nothing happens when i add Debug.Print into the code
  10. cken21

    Search tool in front end Excel Userform

    Hi, I have made the above changes and the txt boxes are still returning 0 values any suggestions?
  11. cken21

    Search tool in front end Excel Userform

    JetFmt is a global constant in excel, i have it setting the date to a UK date as excel and access have US date format as their default setting
  12. cken21

    Search tool in front end Excel Userform

    Hi, Thanks for the reply, i tried this and 0 values are still returned, im not sure but i dont think the date format is what is causing the problem, i thought it might be something in this statement Set rs = New ADODB.Recordset searchstring = "SELECT * FROM CompD WHERE [Date] >= " &...
  13. cken21

    Search tool in front end Excel Userform

    The DB and DateFrom/To values are declared here Private Sub ReportMI() Dim cn As ADODB.Connection, rs As ADODB.Recordset, rsoverall As ADODB.Recordset ' connect to the database Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _...
  14. cken21

    Search tool in front end Excel Userform

    Hi, Can anybody help me with the following code, this is an excel userform acting as the front end of a database. What this tool does is searches the database and return the number of entries present where a specified condition is met, in this case it refers to escalated "Yes" or "No". I not...
  15. cken21

    Search tool in userform

    Oh i see, my bad. Good news i have your code working fine. Thanks for all your help today i understand it may have been frustrating
  16. cken21

    Search tool in userform

    No i hadnt previously i changed that as i assumed thats the format you wanted me to have
  17. cken21

    Report tool in userform

    Thanks alot, i have made the changes and it works perfectly, i really appreciate your help with this
  18. cken21

    Search tool in userform

    Personnel Initials Manager 12345 CKKS 2 23456 PBKS 1 34567 DRKS 3
  19. cken21

    Report tool in userform

    Thanks, before i edit the code, should this change alone make the report work with text entries?
  20. cken21

    Search tool in userform

    No, the personnel box gets personnel but the manager/team no box is blank

Part and Inventory Search

Back
Top