Search results

Thanks for your help Pat, it allowed me to solve my problem. However I must correct one little thing in your solution SELECT [Tbl1].[Payment Date Submitted] FROM [Tbl1] WHERE ((([Tbl1].[Payment Date Submitted]) Is Not Null)) UNION SELECT [Tbl2].[Payment Date Submitted] FROM [Tbl2] ORDER BY...

The function is iif (with two "i") not if.

Hello, I have a very simple union query (Query1) that combined dates from 2 tables (Tbl1 and Tbl2). A combobox show the result of this query. However, I can't have the union query to keep: 1) the descending order asked 2) the "Medium Date" format of the original data Here is the result of...

Try the iif function. ex: FieldPercentage: iif([Denominator] = 0, 0, [Numerator]/[Denominator]) This should avoid the division by 0 error.

It has been a while but as far as I can remember, you might have to relink your subreports from the properties table. I think that the way you set your control source has changed.

Sorry, I have looked in the help files and I can't see how to retreive a query name within a macro. Hope someone will help you better than me.

You might want to try something like this Sub AllMacros() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject ' Search for open AccessObject objects in AllMacros collection. For Each obj In dbs.AllMacros If obj.Name = "YourMacroname" Then...

One of the unsolved mysteries. Thanks anyway, I appreciated your quick reply.

Gina, Have you been able to figure out why an "INSERT" clause will not bring up any error message when trying to insert a duplicate value? Right now I can't know if there was any duplicates that have not been added with the "INSERT" clause. I read your whole post but it is not clear to me how...

Try this instead: strSQL = "UPDATE [New_Items] SET [New_Items].segment = """ & criteria2 & """ " & _ "WHERE (((New_Items.[Desc]) Like """ & criteria1 & """) AND ((New_Items.Brand) = """ & bName & """)) " The difference is with the ". You did not have enough. In VBA, you need "" to print "...

Try this one; it is different from what has been post before. It is good to have different options.

You need to rewrite your lines like this: DoCmd.OpenReport stDocName, acPreview DoCmd.OutputTo _ acOutputReport, , acFormatSNP, _ "T:\Calibration Lab\Calibration Certs\2003 Certs\" & stDocName.name & ".snp", True now the file that will be created will be in the directory...

My solution to this problem always been to use many text boxes...

I would suggest the following: To save your report as a snp file use the "OutputTo" action of the DoCmd object: DoCmd.OutputTo See the VBA help for all the arguments available. You can specify the output name. Hope I helped

Indeed. I knew it was easy. Thanks for your time.

Hello, This might be easy but I can't find how to do it. Here is the problem: I have 2 tables: tblCommissions and tblExpenses Both tables have a field named "Payment Date To Be submitted" and both table have to be separated (don't tell me to make only one table). Now I want to take both of...

Thanks to both of you. I'll do that. Mario

Hello, I have 2 tables (tblCustomer and tblMill) and my problem is the following: tblCustomer contains only the name of the customers (named Customer) tblMill contains many info and one field is the customer (named Customer) Here is what I would like to do: I delete one record from the...

Count the number of IF and END IF inside your loop. I think you are missing one END IF...

This should do it. Make sure to add an OLE Object to your report (Insert, Object..., MS Excel Chart) and name it OLEExcelObject. Your report should be named ReportName and your table of data --> Data. Only 2 series are there but the same principle will work for any numbers. Have Fun Private...