Search results

I have recently developed an access reporting tool that uses ODBC to connect to the AS400 using link tables. You should be able to change your ODBC properties to Read Only(Select Statements Only). Are you using Client Access? You should be able to go into Data Sources (ODBC) which can be...

Yep that's right. I will put the code up, but I will need some time to right the reply. One thing I'd better clear up is that the table the query is over is a linked table and it is using an ODBC connection to our AS\400. Since doing what you have said I have been recieving an ODBC Failed...

Nice idea, i thought you had it sussed then. Unfortunatly that did not work. I have also tried setting the record source type and record source within the VB code, still no luck. Thanks Chris Rice

One query loads both lists. Basically the query is over a file which has a Code and Description. There are 2 codes: 'A' and 'B'. Each code has several descriptions. The query has a condition on the code field. The query selects the records depending on the code. So if code A is passed into...

Thanks Thanks for your help, that worked a treat. I did not realise it was that simple!! Many Thanks Chris

I have two combo box's. The data in each combo box is loaded by seperate querys. The are 2 seperate lists of data that i want to load into combobox two, and I want to control which list is loaded into combobox two by the value selected in combobox one. (There are only 2 values loaded into...

I have created a logging application which has several forms. Form 1 is the form first displayed on entry and acts as a menu. The menu has several command buttons each one loads a different form. One of the command buttons when clicked displays a form which allows the user to enter data onto...

Magic!!!! It worked... Thanks very much for all your time. You are a star. Cheers Chris

I have a main form with a command button which runs the macro when clicked on. The macro needs to open the message form and then run the query. What is happening is that the Macro is opening the message form but not running the query. It seems to just stop after the message form has been...

Thanks for your time once again. I am having a problem however. The query will not run until the form is closed on screen. The form with the message appears and then nothing happens until I close the form. In the macro I had Open Form Run Query Repaint Form Close Form I then tried doing it...

Many thanks for your speedy reply, I would have never thought of trying it this way, I was looking at a more complicated picture. Thank you, I will give this a try. (Is there anyway this can be adapted to show a status bar?) PS (How do you repaint a form?). Chris Rice

I want to display a please wait message on the screen until a query or print preview has completed. I have an access form where a user selects a query using a combo box and then clicks on a command button to run the query. Some of the queries take a few minutes to run, and though an hour glass...

I am using a DOCmd SendObect to send an e-mail. I am sending it as True so that the message can be edited before sending. The command is activated when a button is clicked on the form. When you first load the form the command executes fine. It continues to do so no matter how many times you...

Thanks very much for your help. I managed to get all what i needed from that mailing list post. I do have one other problem, I am using the DoCmd Sendobject function to send the e-mail. This works fine when i first open the form. If i then close the form and then go back into the form the do...

What I am trying to do is set up a pre-defined e-mail to be sent. I want to retrieve individual fields from a table into a string so that I can use that string in the message text of the e-mail. For example I have a field which contains a registration number 'HT1002'. In my message text I...

I am trying to retrieve the contents of a field in a table into a text field which I have defined in VB. The problem I am having is actually doing this! I know a little about recordsets but could do with an example of seting a record set and retrieveing a specific field from a table. Unless...

I currently am developing a database to handle out IT Support Queries. As part of this I am creating an enquiry screen which will display the details of a query selected by whoever. Anyway i have created a form with a combo box (when droped down displays all the available query id's) this is...