Search results

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...

I have done it several times and to avoid problems I follow these steps: - 1) Rename the old table with the new name - 2) Create a query using the the old table name with all the fields of the new table - 3) Change old table name with the new table name in all querys (Optional in some cases)...

This example shows how to add an icon to the Notification Area /Systray), with different menu options and how to hadle them. If no icon is supplied then MS Access Icon is used to show the menu options.

Yes, you are right. I found another examples that uses the same approach to call The EXCEL Library, but these examples are useless. What superprised me whas how do they do de call to the libraries using the API : "DispCallFunc" Thanks, very interesting article I totally agree!