Search results

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

thats interesting... but, how do i use that command ? Driver={SQL Server};Server=serverName;Database=Tracker;Uid=Tracker;Pwd=xxxxx;

interesting, but how do i implement that ?

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

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

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

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

thanks - i did try an inner join. the result was always the same. I have now got it working - what i had to do in the end was set the forms record source to the name of the query, rather than the table. I think this is a bug or glitch in Access 2003... there is nothing wrong with the...

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

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

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