Search results

Thanks for further input. I tried Val() to no benefit. Regarding "string of varying length", the data set I now deal with are those all preceded by "2004/" hence my condition, and all values following are 5 characters (numbers), e.g., 00001, 10001, 12345

Following some suggestions here, I created a query without the order by, saved it, and then did a second query sorting by the Sec field, and this appears to have worked!

I have no control over the data. This is how it is stored in Quickbooks Online, and I am linked via ODBC to this data via my Access database. I cannot change what has been previously inputted. So I am trying to find a way around this. Interestingly, if I click the sort descending in the...

Thanks for your inputs. The field DocNumber, contains invoice numbers. It is a string field with values such as 2024/1543, 2024/1544, etc. However, occasionally contains a value without the "2024/" part I am trying to extract the 'highest' invoice number used. So I have created a field to show...

Hi, hope someone can assist please! I am struggling to do a Desc sort this query on the first field, Sec SELECT TOP 30 Mid([DocNumber],InStrRev([DocNumber],Chr(47))+1) AS Sec, Left([DocNumber],4) AS Try, QB_Invoice.DocNumber, (Right([DocNumber],5)) AS TheDocNumber, QB_Invoice.TimeModified FROM...

Thanks everyone for the excellent advice! This is what I was hoping to get help resolving my issue, and your advise is far better than my initial solution!

Aah! Managed to solve the puzzle. Had used a loop within a loop. N = 0 Do While Not rs.EOF If N = 0 Then 'Do this Else 'Do this End if N = N + 1 rs.MoveNext Loop

Thanks, this is what I am struggling to fathom out

Hi, hope someone can assist. Going in circles with this one. I would like in an EOF loop, for the first record to trigger one string and the remaining records in the loop to trigger another. Do While Not rs.EOF '1st record - do this '2nd and subsequent records - do that rs.MoveNext Loop...

I solved the problem of Dim IE As SHDocVw.InternetExplorer - my Microsoft Internet Controls was not referenced! So remaining problem is simply this: .Document.getElementByID("LoginButton").Click Any recommendations?

Thank you! Then how do I resolve the error with Dim IE As SHDocVw.InternetExplorer as mentioned earlier?

I did get it to work, thank you, by replacing the following Dim IE As SHDocVw.InternetExplorer Set IE = CreateObject("InternetExplorer.Application") With Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") Thanks so much! Only problem remaining is the login button...

Thanks very much for your input. I am not an advanced programmer so not sure how to resolve some problems. When running your code, I get the following error for Dim ie As SHDocVw.InternetExplorer Compile error: User-defined type not defined. Do I need to include a reference? Regards, Harris

Hi, I am struggling to find an example of code that will open an URL and login to the site automatically. I am trying to login to this site: id.caspio_com One example shows error at oLogin.value = Username with the error "Object variable or With block variable not set" - run-time error '91'...

I included the Is Null in my recordsource, and that resolved the issue. I am grateful to all your input, and particular for the solution (which is so obvious in retrospect!) Thanks all for your time in guiding and helping me. Harris

Thank you, a great lesson! I tend to forget to keep the code 'clean'!

Thanks for all your input, much appreciated! Apologies for not responding to all the questions. Yes, there are other categories, e.g., Quality Manager, Food developer, etc., although most have no entry. I will evaluate considering null in my query for I appreciate that it may be as simple as that!

Thanks for your inputs! These are two records in the table - identical except the one has "Accounts" in the Category column. Contact_ID Company_ID FirstName LastName Telephone email Category 11843 3524 Ilona Doggons 78014 ilona@naturalc.com Accounts 11866 3524 Ilona Doggons 78014...

Thanks for your responses. The dB is fairly large, and connected to a sql server backend

Hi, I hope someone can shed a light on this - seems so simple yet the answer alludes me. This works in a form query: SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)="Accounts")); However, I want to have the record source exclude "Accounts" from the field Category...