Search results

Check to see that the combo box is returning the value you think it is. I wonder if it is returning an ID instead of the text value which you think it should. And, if so, you really be storing the statusID in the Assets table instead. You can check to see what value you are getting from the...

And you have Outlook open at the time you are trying to do this? If so, I'm not sure what would be happening.

The answer is yes you can but, as was mentioned already, we need more info as to what it is you are really doing otherwise we don't know down which path to go.

You aren't using something like GMail are you? You are using Outlook, correct?

You can't use colons in file names. Use this: DoCmd.OutputTo acOutputReport, "Breakdown Hourly", acFormatPDF, "Hourly Breakdown - " & Format(Now, "hh_mm") & ".pdf", True, , acExportQualityPrint And don't put "" in parameters that aren't passing any values. Just leave it blank between...

One thing I did notice is you are missing that it is an array: Public arrWebIDs As String Should be Public arrWebIDs() As String

Did you put the declaration of the array into a Standard Module and not a form, report, or class module? If not you need to do so.

What happens if you go to FILE > ACCESS OPTIONS and then to Current Database and then UNCHECK the Use Windows Themed Controls on Forms checkbox?

I just got it (I think): You are using this: Me.Qty = "" But using this: If IsNull(Me.Qty) Then "" is not the same as Null. That is an empty string (zero length string). Try using this: If Len(Me.Qty & vbNullString) = 0 Then

How are you trying to email the report?

How about changing DoCmd.Close to this: DoCmd.Close acReport, "50x50", False

The only way I think you'll make this work is to have a frontend for each version. It just isn't going to be possible to mix the two given the security structure being so radically different in 2007 and above from 2003.

First, the form needs to be open. Second, you can take the criteria out of the query and just use this to open the report: DoCmd.OpenReport "ReportNameHere", acViewPreview, , "[SchoolYearFieldNameHere]=" & Chr(34) & Forms!Main Navigation![Print Form]!SchoolYear & Chr(34) And in your export...

What is the code for GetDBFileNameDlg?

It needs to be in a Trusted Location. See this and see if it helps

How are you using the ABS function? And, as Mihail says, ABS gives the absolute value which is always positive. If you need to see whether it is positive or negative you will need to use the original field before applying the ABS function.

It wouldn't go in the After Insert event. Use the After Update event and use a DCount to check to see if the record already exists.

Go to Tools > OPTIONS and then to the tab (can't remember which one) that has the DEFAULT RECORD LOCKING radio buttons and the Open Databases By Using Record-Level Locking. Make sure that NO LOCKS is selected on the first and the checkbox is checked.

Try going to the form in design view and then selecting the button. Go to the properties dialog and make sure any properties with the word ANCHOR in them do not have the word BOTH there (should likely have Left and Top). Other than that, it may be the same bug that was in Access 2007.

See if keeping the picture's resolution to 1024x768 will help. I've heard that can help with something of this nature.