Search results for query: *

Thanks, Bob. I didn't see a difference either but I don't know SQL well enough to know if a ++ operator did something special. Regards, rixx

I am trying to understand a SQL statement created by someone else. The Sql statement built is the following: INSERT INTO Table2 ( Division, Customer_Number, Customer_Name, Invoice_Number, Invoice_Date, Net_Invoice_Amount, Freight_amount, Invoice_Amount) SELECT Table1.[Division]...

I will try that. Thanks for the help. I'll keep you posted and let the forum know if it works. rixx

I am trying to run a couple of reports in Access from a VB6 app. I am able to run it fine on my machine, however when I install it on another machine, I get a Windows error saying that my executable caused a problem and the app shuts down (much like the IE error asking to send/don't send...

I found an article on MSDN which addresses this issue. If anyone is interested, the link is: http://support.microsoft.com/default.aspx?scid=kb;EN-US;290499. Rick

Hello, I am trying to automatically email reports converted to .pdf files to the entire sales force. I have been able to generate the .pdf files and can email them just fine. However, prior to sending each email, an Outlook message box appears stating something like "an attachment is...

Jon, I get the Type Mismatch error even before it gets to that point. The debuggers points to this statement: Set dbs = CurrentDb For some reason, it won't allow me to set dbs as the currentdb. I added the ampersands: Set rs1 = dbs.OpenRecordset("SELECT * FROM MyTable WHERE...

Jon, I think I now have a proper reference to the DAO objects because I'm no longer getting that error. However, I do get a Type Mismatch and the debugger points to the statement: Set dbs = CurrentDb In the immediate window, I try to print CurrentDb and get the Type Mismatch error. What...

Jon et. al., I tried the following: Dim dbs As DAO.Database Dim rs1 As DAO.Recordset Set dbs = CurrentDb Set rs1 = dbs.OpenRecordSet("SELECT * From MyTable Where [FieldName] = '[Literal Value]'") But when I run this piece of code, I get a message saying "Compile Error...

Thanks, Jon. I'll try it out. Rick

I saw this topic in another thread, but I haven't been able to apply any of those tips. I am trying to create a drill down from a text box and created a double click event to open a form and populate it with data keyed off of the value of the text box. I tried to do the Do.Cmd formname and in...

FancyPrarie, I now see the tables are linked to the server and that's where it's pointing. Now, is there any way to change the links from the .mdb file on the production server and point it to the .mdb file on my dev station? Thanks again

Hello, I've been asked to make some enhancements to an application written by someone else. I've loaded all the files on my workstation but when I fire up the app, I get a message: "\\server1\gls\sys\gls_data.mdb is not a valid path. Make sure the path name is spelled correctly and...

Thanks for the assist. The running total evaluating on the formula worked perfectly. rixx

Hello All, I need to show duplicate records in the details section of a report but I do not want the amounts to double when I do a total on that field. I created a formula which does this: If Previous ({EmployeeDetail.LoanNumber}) = {EmployeeDetail.LoanNumber} then 0 else...