I am trying to automate a daily process. Basically, accounting does a manual release of a batch of invoices in the order-entry system which ultimately updates the SQL server tables. The manual release is done at different times by accounting. An email is sent out to an analyst by the DBA once...
I am trying to automate a daily process. Basically, accounting does a manual release of a batch of invoices in the order-entry system which ultimately updates the SQL server tables. The manual release is done at different times by accounting. An email is sent out to an analyst by the DBA once...
Hi there,
I've tried using the RunApp method to run a vbscript app and can't get it to work in Access. I might have to use VBA to accomplish this. Do you have any sample code on how I might begin to do this? Thanks in advance.
Hi there,
I am trying to obtain values of from a table in a database and write the values to a text file. I am pretty new to VBSript and do not have the slightest clue to go about this but do know that I have to extablish a connection to the database. If you have a sample code, that would...
I am new to VB scripting but know that this problem of mine can be solved using this languauge but just can't figure it out. I am using VBA to export text files from more than one Access database to a directory. These files are used to load another application since it is a file-based system...
I am needing some help. I am currently thinking of building a database that will be my main switchboard for all other databases. I can probably do this in VB but wanted to have flexibility checking numbers in the Switchboard database. There are macros and some code that updates these...
How do you create a prompt for users to enter specific criteria? I am not sure how to do this but know that parameters can be used. For example, the user will be prompted to enter a cutomer number and so would return information based on the inputed customer number. Please help.
I am having trouble converting a date field. Basically, I am trying to convert a date field called ship date and be able to separate the month and year into two new fields using the month and year functions. The problem is the data format is new to me because the system that generates the date...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.