Search results

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!

Only for fun and after some tests, I realized that I could create a query with 50 UNION tables, when I tested the process with 51 an "Expression to complex" error raised.

When we want to use an external library in VBA we usualy use Early or Late binding to access their methods or properties, but this example shows we can execute functions in some libraries loading them at runtime without declaring them. I don't know if it it can be useful or not, but I found it...

You are welcome! It has been an interesting challenge to convert it and I'm happy to have solved your problem. I don't think we see it! ;-)

This database shows how concurrency can be used in MS Access using Doevents. It also shows that if a process is not dessigned to be used concurrently and uses Doevents function in it , you have to prevent it from users to execute multiple times. Concurrency is when two or more tasks can start...

My point is, if the procedure fits on one screen on the top, if not, then before the first use.