Search results
-
8
Searching for a particular ID number across all tables in an Access Database
I have inherited an old Access database with about 300 tables. We need to be able to search for a client ID number (for example 'R12345') in every table in the database and to return all tables that it exists in (all rows would actually be good but a list of the tables it exists in would do as a... -
8
Add a simple date picker to an existing form
I have now tried it with and without and I get runtime error either way so I don't think it makes much difference if it is there or not? -
8
Add a simple date picker to an existing form
No its Arne's code. I have tried removing it and it works with or without the zero seemingly. -
8
Add a simple date picker to an existing form
Hi is there a reason why you are adding the initial zero to the string as the previous comment asked? -
8
Add a simple date picker to an existing form
The only thing now is that when i paste in a UK date format to the text box txtDateOfBirth then when I click the calendar icon it doesnt take you to the correct DOB it is still stuck on todays date. If paste it in then press return the calendar icon vanishes and when I click back in the text box... -
8
Add a simple date picker to an existing form
Thanks for your help. Yes the square brackets was the answer around the field names in particular. Also changing the date format to american mm/dd/yyyy also helped as I initially has swap round the day and month in the query text box to get it to work (despite the source database using... -
8
Add a simple date picker to an existing form
I don't want to go in and edit the column names in the original database although I am aware spaces can be tricky. Any idea how to get the query working as expected? I had to put ' around the DATE OF BIRTH field or else it was throwing up other error messages. -
8
Add a simple date picker to an existing form
Hi I am almost there but at the moment every search seems to provide the no results warning message. So the query is not picking the rows as expected from the original table. Any ideas where I might be going wrong? Private Sub cmdSearch_Click() If DCount("*", "WICS - IDENTITY", "'DATE OF... -
8
Add a simple date picker to an existing form
I have created a very basic form that lists all the fields and you can also scroll through the entries in the table. This was done simply by highlighting the table, right clicking and going to Create > Forms > Form. What I require though is to copy this form but add in the feature that when you... -
8
Query to return entire rows with Min Date only
Hi sorry to be a pain any idea how I would add in one more criteria to the code below in order to narrow the output down to just episodes with a start date equal or grater than 1/9/14 (ie [D_S__Episode_Start_Date] >=# 01-09-2014#? With it being complicated query I wasnt sure how to fit this in... -
8
Query to return entire rows with Min Date only
Hi the query works in Access 2007 but Access 2003 tries to optimise it and breaks it! -
8
Query to return entire rows with Min Date only
On a brief google seach it seems that Access 2000-2003 has a query optimiser that can change the code if it thinks its wrong. In 2007 this isnt the case. I will try the query as is in 2007 as we will all here be moving to that soon but it would be better if I could get it to work in both versions! -
8
Query to return entire rows with Min Date only
Has anyone else come across Access changing ( to [ and adding full stops? I am abit loathe to use this query now despite it appearing to display the correct results. Bizarrely if I go to the results list and try to drag a column wider and save the layout then it comes up with the same error... -
8
Query to return entire rows with Min Date only
Hi i think Access 2003 is changing your code when I save the query! I cut and pasted your suggestion into the SQL box and it ran ok producing output as required (not tested yet by looking up rows). But when I go back to design view I find your code has been changed to the following. There are no... -
8
Query to return entire rows with Min Date only
The actual code is below it wont let me save it as it is saying 'Syntax Error in FROM clause'. Strangely this error did appear with the simpler version but only after I viewed the results and tried to widen the columns in the display which was odd! SELECT tQ.PIN, tQ.P__Business_Unit... -
8
Query to return entire rows with Min Date only
Hi this seems to work as expected I tested 3 or 4 rows and they do return the correct EventID and the Min EventDate. If the original table had other columns how do I ammend the query above to brings all of them across? They have to all come from the row that the Min Event Date is on though. Say... -
8
Query to return entire rows with Min Date only
I am looking to return one row from groups of the same EpisodeID whereby the row with the minimum date is selected each time. This includes returning all other fields in the row such as EventID below and ideally others as well if that will be possible. To illustrate I include the following... -
8
SELECT returns more than one row
Hi I am using a simple Pass Through Query in MS Access to pull data from a Sybase database and populate a table in Access. This query has always worked in the past but has recently been throwing back the following error message: ODBC -- call failed. [Sybase][ODBC Driver][Adaptive Server...