Search results

Heya, Can anyone tell me how to pause the macro until a dialog box has been displayed before sending the {enter} command? (probably about 90 secs) I'm having troubles because it wont wait for the dialog box to come up. Help! Russ

Ok I have found the "send keys" command, but it sends the keystroke before the dialog box comes up, is there any way to make it wait for the box to come up before sending teh {ENTER} command? Russ

Sorry Mate, I have set warnings to off, but apparently (from looking in the help database) that this only turns off modal warnings, and any dialog box that requires a yes or no input is still displayed. The dialog boxes are displayed by ACCESS and only pertain to the tables created by the...

First one says "you are about to extract 61877 to table TSTBeforeRefresh, do you wish to continue?" then it has the "yes" and "no" options. The second one says "would you like to open the table TSTAfterRefresh?" and has "yes" and "no" options. I want to answer "No" to both.

Hi, I am using a macro to run a few extractions from our SAP system. It involves opening a form, going to a record, getting focus on the "extract" button, and viola, its done (the extraction takes about half an hour and it is done multiple times) Everything is going fine except 2 dialog boxes...

Hi, Can anyone tell me how to crate an export specification? I cannot work out how. I am using a macro for this transfer.

Ripper! Works like a charm. Thanks very much Raskew Russ

I am battling through a query, writing it in SQL. My SQL knowledge is very limited but I am keen to learn. the query looks like this SELECT UNAME, AGR_NAME FROM QASBeforeRefresh WHERE (QASBeforeRefresh.UNAME and QASBeforeRefresh.AGR_NAME) <> (select UNAME and AGR_NAME from QASAfterRefresh)...

Thanks for the reply, and I think you may be right, and I can say for sure if you can tell me where I go to set the text qualifier. I have been looking but cant find it anywhere. Russ

Hi, I am having a problem running a macro which calls on 4 queries. Each one relies on data from the last one, they all seem to run properly except one which displays the message "this recordset is not updatable" down the bottom of the screen. Anyone know what the problem is here and how I...

Cheers Mate, All its all fixed up, I have a couple of selectqueries but I just close them with the close command after they have run. Russ

Hi, I am trying to export a table to a .txt file using a macro. I am doing this to import to it another system. The export works, but when I open the text file all the entries have "inverted commas" on each side. The problem is that becuase the records are all in inverted commas the other...

Hi, Tried that but it jus seems to loop out. The query takes over an hour to run (there are 180,000 entries in one table, and 60,000 in the other) and comes back with no data. To clarify, I want to check if a user+role (combination of the two fields) appears in the other table. Both tables...

Hi, I am using the "open query" command for some queries I want to run as part of my macro, The problem is I dont really want to "open" the queies, just run them without displaying the data on the screen. Is there a way I can run them without displaying them? maybe I need to use a different...

G'day, I am using ACCESS to compare roles for users on our SAP system before and after a QAS refresh. I have two tables, one listing roles before and one listing roles after the refresh, how do I have to relate these two tables and what type of query should I run to present me with a list of...

I have been using ACCESS a fair bit but havent really used VBA that much, actually I hardly know anything about it at all, can anyone reccommend a way that I can make sense of this. Im pretty keen to find out what it's all about Russ

No error message comes up, the vertical bar on the left hand side of the form flashes black for a second and thats about all that happens. The same code works on other forms. Russ

it doesnt seem to work, any more ideas?

Good evening, I am experiencing a problem with the delete buttons I have added into my forms. I have 3 different forms that operators use, I added a delete button using the wizard on each form to delete the data if the user makes a mistake. I have allowed deletes in the form properties. My...

Thanks Mate, Forgive my ignorance here, Im only new at this. I have made a module with the GetUser = CurrentUser etc etc that you said to do. Then do I make a defalt value in the UserNumber field of my table as =GetUser() Well thats what I tried to do and it didnt work, if possible could you...