Recent content by a.sharma

What is the error this time?

Sorry for that. I have removed the password. Use this fresh attachment.

In the VBA window, go to tools > references and see if you have a check mark in front of Microsoft Windows Image Acquisition Library vx.x. If not, scroll down to locate it and put a check mark to add the reference.

Here is a link for a better understanding on how to go about scanning in access. http://www.access-programmers.co.uk/forums/showthread.php?t=218082

Change the statement as below Set Scanner = Dialog1.ShowSelectDevice(WIA.WiaDeviceType.Scanner DeviceType, True, False) Now it should show you a device selection box.

marlind618: I have checked the file again and it is working as intended. I have disabled the error handling so you can go into the code to check which line is giving you the error. let me know about it. Access 2013 should not be any problem.

rgrogan, How are you checking the values of A and B? Are these values in a table, query or a form. Give some more details and I can try to help you.

Declare a global variable in a standard module as- Public gstrUserName As String The variable will be available to all forms. You can assign a value to this variable when a user logs in, which can be done in a login form if you have one or you can assign a value at any stage that suits your...

The standard syntax for DLookup is DLookup(FieldName, SourceName, Criteria) FieldName is the name of the field which hold the value you are looking for. SourceName is the name of the table or query that contains the field Criteria is any condition that you wish to evaluate to get the value...

jsbarroso: please check the attached test db. I think this should help you as it contains all the code that you might need to accomplish your multi-page scanning and much more. Need any further help? Do post back. Good Luck. __________________ Ashok

Check the code below. I am using it in one of my app to scan documents as image and converting them to pdf and saving on a network folder. Give me some time to make a test db for you. Meanwhile have a look at the code to get some inputs on how to go about this task. [CODE] Public Sub...

Matt's way is a good way to take care of this. Also check out the declaration at the start of the sub. I have used the following in one of my sub to disable some controls. Dim control As control Dim Ctrls As Controls Set Ctrls = Me.Controls ________________ Ashok

Michael: Yes I did try all the cleanup and decompile as documented in the links. It did reduce the size from 25 MB to 18 MB but as for the accde working on client system... no that still remains. Both systems have office 32 bit and Win 64 bit. I am now thinking on the lines of making an install...

mdlueck: Thanks for the links you have given. I have gone thru them and also checked that none of the systems involved has either Win 7 SP1 or Office 2010 SP1 so it seems I should not have the issue we are discussing but still it is there. I have compiled the database on a third system (not...

UPDATED Db. tested working fine on A2010