Search results

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

Try the attached db now. and do chk the code.. some change done and added ref to ms office 14 object lib should work now.

Thanks for your prompt response. "Can you compile it on a different computer and see what happens to your client and then to yours? I know it is not totally helpful, but it might unveil a trend." That is something I haven't done yet. However, the accde from the client system works on my...

Thanks for your reply and suggestion Rx. As I said in my first post, before making the accde on the client system I have checked the references and they are all fine.. exactly same as on my system. The only difference in my system and the client system is that it has 4 GB RAM and my system has 6...

I am developing an app for one of my client and am faced with a strange issue. If I compile and make accde file on my development system it does not fully work on the client system. To be more precise; I have some forms with textbox value set to default (=Date()). The date shows correctly in...

Hi All, I have been using this forum to find answers to many of my access related problems and have almost always found a solution here. Thanks a ton for this wonderful forum. I am Ashok Sharma from New Delhi, India. I have been programing in Access for about 5 years now and have enjoyed...