Search results

I am working with a report that pulls data directly off of a table. the report contains 180 or so fields the first 10 fields are headings and located along the top, the next 10 are revenue for the headings and located on the second row the next row is counts of customers... the last row is...

I need to use DoCmd.TransferText to output the results of a query. The query has 2 parameters that need to be set in order to run. I set them using the following Set qdf = CurrentDb.QueryDefs("OptedOut") qdf.Parameters("low") = "A" qdf.Parameters("hi") = "Z" and when I get the...

I want to automate importing of dbf files. the files are in a folder based on name of job. optimally what I would like to do is user opens program and is prompted for folder location program opens folder and imports or links selected dbf files.(the files are always named the same thing and...

I have a job which is run (which I have no control over) which creates several .dbf files, and places them in a folder named after the job number. I have a MDB which creates reports based on these files. what I currently do is open the database drop all the tables import all the tables...

I'm using the transfer database action and I want to transfer data to different databases at different times. What I would like to do is prompt the user for a part of the path in 'database name' how can I do this?

I create a lot of standard fixed length files for use on an as/400. I'm trying to create an application which will do the bulk of the work. What I would like to do is set up a macro to export a table from the mdb, however I would like it to prompt the user for location and filename. is this...

I have a form for login which contains a control whose contents I need several times throughout a session. I believe that what I want to do is save the contents as a global variable, how do I do that? and once I have it saved as a global variable how do I access it from a form thanks for all...

hi folks I am new to the security aspect of access, so bear with me. I am developing a database for advisement of students at my university. In this application I need to keep track of who advises whom. I have a table of all the users with several attributes that are necessary for...