Search results for query: *

I am not sure what happened, but all of the sudden our database won't let us in. 1st it tells me it needs to be repaired or isn't a database file. It then asks me if I want to repair the database, when i say yes and try, it says the password I put in is not valid. I am not sure what to do...

Thank You, I will give it a try and get back with on how it works. Joe Lawn joe_lawn@cardinalbuilders.com

I need to be able to search 2 tables to see if a client exists. I will probably have to do the search either by last name or phone number, and the field names are different, and it is possible to multiple matches in both tables. If I join 2 tables in a query, is it true that I will only get...

Thank You, I will try these options and let you know how they work Joe Lawn joe_lawn@cardinalbuilders.com

I am trying to create a report using three different tables, with a one to many relationship. If I just create the query I get the records repeated a number of times. What I am looking for: At the top of the report Customer name, address etc... Next I would like to show the labor costs for the...

Thank You, I will let you know how it all works out. Joe Joe Lawn jtlawn@hotmail.com

Thank You, My question now would be, can I print this from an Access form? If so, how would I go about that, if not how do I have the users access and print the letters? Joe Lawn jtlawn@hotmail.com

I would like to automate a form letter. I would like to create a form letter in Word and populate it with data from multiple access tables. Is it possible to write a macro that can run an Access query, then pass the values to form letter in Word? Then make the letters print? Joe Lawn...

Currently I have a primary table with a primary key, the key is an autonumber field. I have six other tables that are related to this table by this field. Is there a way to pass the primary key value to all other tables when a new record is entered. Currently, after a new entry I close the...

My job initially empty's out my access table, next it executes a job to download data from our mainframe to a text file.&nbsp;&nbsp;Then it imports the text file into my access table, runs a query and exports an excel spreadsheet.&nbsp;&nbsp;<br><br>My problem is the job clears the table and...

I was able to get the code to finally work.&nbsp;&nbsp;I was using transferDatabase and I needed to use transferText.&nbsp;&nbsp;I also needed to use use a command line string to first execute the software, then execute the specific job.&nbsp;&nbsp;Here is a sample of the code.&nbsp;&nbsp;Thank...

I have been able to run the executable, but now my problem is with trying to import the CSV file.&nbsp;&nbsp;Would I be better off having my executable create an ODBC file instead?<br><br>If so how would that code look and how do I actually make set the ODBC connection.&nbsp;&nbsp;I have tried...

Okay, I think I can do the import, but I am still not sure of the download part:<br> <br> Are you saying: DoCmd.TransferDatabase=C:\DAS\WORK\PGM1.as<br> <br> Where PGM1.as is the name of the job that will actually run the job that will download the file for me.<br> <br> Thanks <p> <br><a...

I am trying to execute a procedure out of a software product called 'application systems' or 'AS'. We are using their command client piece to extract data from our mainframe to a PC. I am using AS, because it gives me the connectivity to the mainframe and allows me to write my code directly...

I am a new user to ACCESS, I am using ACCESS 2000. I want to be able to execute and external file from a button on a form. Our Company was using Approach and just recently swithced, in Approach I had to create a package in an object, I can do this in ACCESS also, but I need two buttons one...