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

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...

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)...

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...

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, 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

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...

I am nearly ready to release my ACCESS 2000 database to 150 employees in our office (client/server network). However I have two problems, I have looked through countless posts and cant find exacly what Im looking for. ACCESS automatically defaults to each individuals network ID when it is...