Search results

Perhaps the basMouseHook by Wayne Philips disables the mouse scroll wheel in Access forms, it only works in 32 bit MS Access. AFAIK there is no 64 bit version and no way to disable the mouse scroll wheel in 64 bit MS Access. If I'm not mistaken if you want to disable it, you have to comment...

According the code you posted, SSL is not configured.

No you should ask your SMTP provider what configuration you have to use when using SSL and then configure it in the CDO procedure. Search in google: 'sending messages using SSL authentication in CDO' Lately it's recomended to use SSL when sending messages.

Have yo tested to authenticate using SSL?

The report textboxes must refer to the form textboxes values. Their controlsource property must be: =Forms!FORMNAME!StartDate and =Forms!FORMNAME!EndDate (Change FORMNAME with the name of your form.)

You don't need an invisible button to open the agent profile, you can use the onclick (or better double click) "AGENT NAME" textbox event to open it.

To test if it might be a data problem, you could assign the number "3" instead of copying the value from another combobox to see it it works or not. [edit] Too late! I see the problem is solved!

If I'm not wrong when you use the IIF() function in VBA the interpreter always evaluate both branches of the exrpression, BUT if you use the IIF() statement in a query the SQL interpreter only evaluates the according part of the expression.

The query works fine but depending on the data, if there are 0 or Null values in [VP] then the code will fail. This code avoid the 0 and null values in [VP] and [SP] SELECT qry_receipt_bay_progress_2.[Cases Expected], qry_receipt_bay_progress_2.[Cases Receipted]...

Test with this code Dim DelPic As String Dim Response as long DelPic = Me.picafter1filepath If IsNull(Me.picafter1filepath) Or Me.picafter1filepath = "" Then MsgBox "No Picture to Delete", vbInformation, "There is not much to delete" Else 'Execute Response =MsgBox...

Perhaps these videos by Richard Rost can help you:

Hi Colin, I've converted the databases in several steps with no issues. 1.- Access 2 to Access 2000 using Access 2000 2.- Access 2000 to Access 2003 using Access 2003 3.- Access 2003 to Access 2010 using Access 2010 To convert the HLP file, I searched a andom HLP online converter (I can't...

@isladogs Here it is the Solution database converted to these ms access database formats: 2000,2003,2010 accdb. There are some compiler errors and I suppose it needs the NWIND database to work properly.

I don't use it in my applications but I've used it every now and then for testing purposes or for helping me to fix some bug. Using DAO and printing bookmarks, I noticed that if you open a dbOpenTable recordset, bookmarks are consistent after closing and reopening the recordset, or if you open...

Sometimes it can be interesting to print the recordset bookmark values assigned by Access. This simple function transforms the Variant value in an Hex value that can be printed. Output example: 00-2A-25-03 Public Function BookmarkToHex(bookmarkValue As Variant)...

You can also link the txt file as a linked table and then execute an insert query.

In the original database example you uploaded, with no changes, I've also noticed that if you press the space key after typing the Cod.Cli.: 5 it works properly and the client 5 is selected using MS Access 2010.

It seems that's a problem with some old MS ACCESS versions. I've noticed that the problem is caused by the -1 value there are in the table. If you change it for a positive number, then it works with autoexpand=true.

The example you have attached works ok for me in MS Access 365, but not in MS Access 2010. Using Access 2010 it happens the issue hou have explained. The workaround for old Access versions is to change the autoexpand property in the cmbAnagraficaCodice combobox to False

I use the following workaround: Before setting the focus to the current control, set the focus to another control, it doesn't matter which one. Example: Private Sub AuthDateEntered_LostFocus() 'Private Sub AuthDateEntered_BeforeUpdate(Cancel As Integer) If AuthDateEntered < ReferDate Then...