Search results

UPDATE: I finally figured out how to scan a 8.5 X 11 document. i added the following code to my module Set wiaScanner = ComDialog.ShowSelectDevice(WiaDeviceType.ScannerDeviceType, False, False) wiaScanner.Properties("3088").Value = 1 'Automatic Document Feeder...

I am working on a project which will eliminate several steps of the user to scan a document using a 3rd party software, manually naming the document using a predetermined naming convention, and placing it in a predermined folder. i have successfully used a VBA scanner code from an earlier...

AWESOME!!!!!!:D:D:D thank you. the while wend worked like a charm. many thanks

it is a linked excel table. the code below is what i use to open the webpage, navigate to the page and download the file. after download i have to open the file and get rid of headers in the spreadsheet that i dont need. then save the file. Private Sub Command19_Click() 'routine to open...

it is a linked table to the excel spreadsheet i downloaded to a folder on a virtual server provided by my work.

Thanks for the replies, this is what I am trying to attempt to do. I am writing a VBA code that will run as a daily autoexec, which will perform the following function. 1. Open a website 2. Log me into that website using my log in credentials 3. Navigate through the multiple pages of the...

I have some VBA code in Access 2013 that i just can't figure out what I am doing wrong. I open two separate queries. I match data from one query with the other by using two fields, name field and a date field. when a match is made the place the date from the first query into the second query...

once again thank you all for your replies. the loop suggestion worked and was able to have it work as i intended. thank you for the suggestions on update query. i am going to research that option for any future projects.

thank you all for your quick responses. I am self taught with using VBA and still learning. I looked up update query and what i saw was if you want the same information in the field or update information in a field to change to another description. i have a blank field that should have a...

I have created a database that takes one query that has a blank field in a predetermined field and finds a record in a second query that matches name and date of birth criteria. it pulls the value into the blank field that is supposed to be there. MR missing in query one....find record in query...

thanks. i was able to modify my code using the example of the first article. my code works and ended up looking like this for any other users haveing the same issue. filename = "name of file i created with my report to be emailed." Dim outl As Outlook.Application Set outl = New...

I have a VBA module in my Access 2010 database that will send a report as a PDF via email to a predetermined email address. the only problem using the docmd.sendobject method is i keep getting a pop up that says "A program is trying to send an e-mail on your behalf. If this is unexpected, click...

I need help please? my brain hurts. i am trying to create a button on a split form/datasheet. I have a field named completed that is a yes/no field. if the job is completed then the field is yes, .... i want to use a button on the form that will filter the data on the datasheet view to show...

Hello to all, my name is Michael. i am a new registered member to this site, but have been using the wonderful post here to solve my problems i have encountered. I am new to using VBA in Access 2010. I have created my first complex database from scratch for my medical clinic. i am always...