Search results

  1. A

    Link to User Level Secured Back End

    Help, This is driving me mad. I am trying to connect to a database using User Level Security. I am setting the table name in code as below: NewTabName = "tblIcons" i have the following code so far: 'reattach table from new database Set tbl = db.CreateTableDef(NewTabName) tbl.Connect =...
    • Arry
    • Thread
    • Replies: 0
    • Forum: Tables
  2. A

    Display names of Query and Reports in a subfrm

    I need to be able to display the names of the querys and reports in my database. From here a user can then request to run the report they require. I know you can reference the database types in a query but cannot remember how. Can anyone remind me please. Thanks Arry :p
    • Arry
    • Thread
    • Replies: 2
    • Forum: Forms
  3. A

    New Query opens as a popup

    I have a database running with the application window hidden and would like to give users the option of creating querys based on the built in query wizard. The query when opened using a button on a form is not displayed on screen because the app is hidden. I need to somehpw set this to a pop...
  4. A

    Allow form to display fully

    I am running so complex code from a form button. While the code is running i would like to display another form which displays the work busy. I have included code from the button to Docmd. openform etc.. but the problem is that the form is not displayed fully. i e you get the outline but no...
    • Arry
    • Thread
    • Replies: 9
    • Forum: Forms
  5. A

    Running in background

    I have a timeconsuming task that is intitiated at the click of a button by the user within my access 97 database. Is there any way of continuing to browse throught the database (forms etc)while the code is still running?? Any ideas! Thanks Arry
  6. A

    Left() Function

    I am running code in Access 97 as follows. SQL = "INSERT INTO [Tbl_Adjustments_Data] ( [Invoice Number], [Invoice Period], Type, Type2, Comments, [Date From/For], [Charge (£)] )" & _ " SELECT Left([F1],10) AS [Invoice Name], Right([F1],4) AS [Invoice Period], TempAdjustment.F2...
  7. A

    Check to see if table exists

    In VBA i need to run code to check to see if a table exists. If it does i am appending records to the table from my VBA sql, but if it doesn't i need to create the table. I have created the code to append or create new but i cannot find out how to "check" to see if the table exists. There must...
  8. A

    Automatic import using import Spec

    I have written some VBA code to import a file with a click of a button from a CD. The file is not always the same name but always follows the following: D:\????f3??.vp Here is the code. DoCmd.TransferText acImportDelim, "550 Invoice Records Import Specification", "Tab 550 Current Month"...
  9. A

    View query names in a combo box

    I would like to view all of my query names from within a form using a combo box. Is this possible. I would like to do this so the user can select what query to run or delete. I cannot reference the query via a button etc... as the user can make new queries and name it as whatever they want...
    • Arry
    • Thread
    • Replies: 3
    • Forum: Forms
  10. A

    Convert Seconds into HH:MM:SS

    I have a field in a report which displays a value by total seconds ie 1827 seconds. I would like to convert this value into a new field shown as HH:MM:SS. Does anyone have any ideas on how i can achieve this. All help appreciated. Cheers Arry:D
  11. A

    Output to Excel

    Hello all, Hope you can help. Does anyone know a way to export data from an Access table/query into an excel file?? Sounds straight forward but what if the table/query is over 65,536 lines. Is there an easy way to split the records and paste into different excel sheets.:eek: For example...
Back
Top Bottom