Search results

  1. W

    weird bug ?

    hi, has anyone seen this problem ? Access 2003 - i have many queries in a DB. they work fine, but *sometimes* some of my queries are wiped - when i try to run them they say "query must contain at least one cell" or something.. when i check the query then, its empty! i have saved out the...
  2. W

    preparing a DB for users to install.

    Hi i have pretty much finished a complex DB app that uses 2 DSNs for 4 linked tables. The DSNs work, but when i ZIP up the DB file and ask others to create the DSNs exactly as I have them on my machine, the linked tables fail on the other persons system I am using SQL server authentication...
  3. W

    update all currently showing records

    hi all, how about this? I want to allow users to click a check box on a form to 'flag for testing' thats fine - works great but what if there is 100 records and the user wants to flag ALL of them for testing? how can i have a checkbox that basically 'selects all' however, the 'all' must...
  4. W

    Form datasource as query problem.

    Hi All, another day another problem! I have a SQL table shown on a form which i wish to filter by current logged in user - I have a local table storing the currently logged in user and all records in the SQL table have a field called userEmail so - i have forms that take their datasource...
  5. W

    driving me insane. how to update current record on a button push

    Hi this is mad, for three days i've been scouring the web and my books on VBA, Access etc... I have a linked table from a MS SQL server for some reason I can't edit any data in it directly - ie, when typing into a form, i just get a locked message. however, when i run SQL queries on it, it...
  6. W

    query won't work in a form

    hi i have a DB which tracks order numbers, the main table is a SQL table linked in, and there are lots of local tables as well, one of which is called userDetails and contains a field useremail i want to open a form and only show records from trackermaindata that contain my useremail -...
  7. W

    pull all worksheets in a excel file into a table

    Hi i need to get all the worksheet names from an excel file and dump them into a table - so if the excel file was as created, my table would look like: Sheet1 Sheet2 Sheet3 i can find various methods for listing the worksheet names from within excel, but how can i get Access (VBA) to...
  8. W

    import one column of many sheets from Excel into link SQL table

    Hi, I'm fairly new to access and SQL, but have a background in other DB apps. here's my problem I need to allow users to choose a file for import (could be anywhere), then, i need to determine how many sheets are in that excel file, and import any numerics on column G from ALL of the sheets...
Back
Top Bottom