Recent content by Mario

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.