Search results

  1. C

    Display a Query Timer

    Dont worry I found it. Please do not spend any time replying to this posting because I have found many solutions using the search function. Sorry for the obsolete posting. Thanks for any interest. ;)
  2. C

    Display a Query Timer

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

    Passing through dates to Stored Procedures

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

    Editing SQL data on an Access form

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

    Refresh Linked Tables button

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

    Center the File Open/Save Dialog box

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

    Automation in Access 97 (I chanlenge you!)

    Thanks for the suggestion I have used Shell to activate the application but this also opens a new excel application which I don't want. I would like to know if it possible to activate a new application without opening a new window? Has anybody else experienced this problem? Let me know.
  8. C

    Automation in Access 97 (I chanlenge you!)

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

    Create a new exel file, lock fields and then exprot to it.

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

    Relinking tables

    Did you try using the linked table manager in tools/Database utilities, selecting all tables and the always prompt for new location tick box? You can re-link the tables in VBA by using the link table command (DoCmd.RunCommand LinkTables) and then renaming all the tables as they were originally...
  11. C

    Linking the backend to the frontend

    You can find the linked database from a table in the front end by viewing its properties. Do this by opening a table in design view and clicking on he properties box in the top left. The backend will be specified in the Description property. If as you say the tables are no longer linked the to...
  12. C

    Objects in Web Browser Control

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

    Browse for files

    You can use the CommonDialog Active X control but you will need to be licensed. I wanted to use this but I needed the developers’ version of Access. We now have XP developer and although it does more it isn't as reliable. Could please you tell me what you used to be able to drag and drop...
  14. C

    Open Exclusively using VB.

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

    IF all records in a form are null, 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...
  16. C

    IF all records are null 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...
  17. C

    Run code at speified time

    Thanks. This only works when a user clicks on the button at the specified time doesn’t it? I would like it to run automatically at the specified time. Is this possible?
  18. C

    Run code at speified time

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

    Deleting a database

    Yes your right, my problem was that the variable representing the name of the database had changed when I ran the kill line. I have sorted it now by making it constant. Thanks Chris
  20. C

    Deleting a database

    Thanks for the suggestion. The kill statement did not work with .mdb files so i need to find another way around my problem(in tables forum as 'file description'). Thanks
Back
Top Bottom