Search results for query: *

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

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

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

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

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

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

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

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

Nothing happens when i add Debug.Print into the code

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

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

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] >= " &...

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; " & _...

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

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

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

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

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

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

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