Recent content by 83dons
-
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...