Search results

Thanks. I need to get it done by Sunday. Will see how it goes.

Hi JBH, Yes, lots of hints. I read through them but still very confused. I literally just started a few days ago with Access & vba. I was hoping someone might of had some logic i could have recycled. I have been at this for the last 8 hrs and getting now where. Any code samples you can...

Am as new as they come. My head is spinning at the moment.

I totally agree. I just don't know how to code this. That is why I posted.

This process needs to be done daily for 44 files. I was hoping not to have to open and edit each one to remove unwanted rows. Was hoping there was a way to load the data between the START-OF-DATA and END-OF-DATA indicators in the file within a vba module.

:confused: New to Access coding. Hoping someone can help with the coding in Access VBA. Just don't know how to start this. Any help is greatly appreciated! Thank you in advance. Here is pseudocode for what i trying to do: 1. prompt user for date of file to open 2. open file in a...

My apologies. I did look it up before I got a chance to delete my post to inform you. Thank you for all your help.

I never have used dlookup() how does that work exactly? Sorry, I am under the gun to get this done by end of day today. Thanks.

How to get the date into the file name is what I don't exactly now how to do. Was hoping for some guidance. The date to append to the file is stored in a table name "sales" and the field is called w_asofdate. This w_asofdate field is date/time in access. Just don't know how to code and append it...

Hoping someone can help. I currently have an access database for which I have created some reports against. I want to output the report also to an excel file. I am able to do this with no problem using Visual Basic ACCESS DoCmd.OutputTo acOutputReport command (see below). This code is stored in...

Thankyou. This worked perfectly.

Question: Is it possible to get cumulative percentage of a running total withn an ACCESS report? I am able to do a running total of a balance column using the Control Source in the text box properties, but can not figure out how to get the cumulative percentage to work. For example, the...