Search results

I would like to implement a timer into a MS Access form that displays when the user clicks on a button that runs some queries. If possible I would like the timer to group the whole process together and show a percentage bar or the time remaining to run the queries. Otherwise it could I could...

Hi I am trying to pass parameters from MS Access to SQL server Stored Procedures. I'm passing a date-formatted value and the formats of the dates are in different orders. I.e. dd/mm/yy > yyyy/mm/dd 00:00:00 000. Is there a quick reliable method of converting the date as it is passed through...

I have to use Access 97 to allow a user to edit data in an SQL back end database. I am using pass-through queries to call Stored Procedures and I am not able to edit the results. I have tried creating extra text boxes to insert data and then run an Update stored procedure to put the data...

Hi Is it possible to code a button that opens the linked table manager? Ideally I would like it to automatically ask for the location of all tables. I.e. tick every box on the first dialog. I would be very grateful if someone knew how to do this because I have tried many long-winded ways of...

I am using the API – File Open/Save for Microsoft Access, which is like a substitute for the common dialog box. I would like the dialog box to open cantered on the screen. Can anybody help me achieve this? Thanks very much

When automating Excel using Access 97 I can only seem to run commands in one Excel application in a procedure. I use the function: AppActivate ("Microsoft Excel - 'bookname'") to change the application in the taskbar that is being automated but Access continues to automate the first application...

Is it possible to create a new excel file and then lock all the cells. So that when I export to it (Already can do) the user is unable to change the data. Thanks very much

How can I assign a variable to the selected object in the Web Browser when it is being used to view local files. For example If a user click s on a file in the browser, the name and/or location of that file is dispayed in an Address box in Access. Thanks very much

How can I re-open an open database Exclusivly when a user click a button, using VB code. I need the loading section of the database to be run exclusivly. By trying to open it exclusivly I could also dispay a massage saying that they are unable to load data now if there are other people using...

How can I use VBA to find if a field in a continuous form is null in any row. I can find the first row using the following: If me![Combo13].ListIndex = -1 Then I would like to know how to do this for a set of records and express if any are null Then ……. I want this to use in an IF statement...

How can I use VBA to find if a field in a continuous form is null in any row. I can find the first row using the following: If me![Combo13].ListIndex = -1 Then I would like to know how to do this for a set of records and express if any are null Then ……. I want this to use in an IF statement...

I would like for some code that is behind a button in Access to be run automatically everyday at a certain time. Can any body help me? Thanks

Is it possible to delete an unopen database on the click of a buttonin visual basic? Thanks

Is it possible to create a button that allows a user to open a find file window to select a file, with the location being pasted into a text box on an access form. If this is possible I would love to know how. If it is not possible I would like someone to tell me. Please help Thanks