Recent content by krisleech

Access for production applications = :( the biggest problem solver in Access for me was to press ALT + F11 to open VB, then choose refrences from the tools menu and deselect all MISSING refrences. This cured many seemingly unrelated errors. However since you are using Access with SQL server i...

dd/mm/yyyy or mm/dd/yyyy - dont leave it up to Access to decide That explains my problem! I like to know why something is happening, not just a solution, thanks Pat. Moral of the story: If you are getting a date as user input (unbound textbox or prompt) be explicit with specifying format ie...

dd/mm/yyyy > mm/dd/yyyy That works Rich! But why, im assuming the Format re-arranges the users date from dd/mm/yyyy to mm/dd/yyyy, but how come that works since when i use dates in queries i use dd/mm/yyyy and that works fine! I am in the UK, so i would have thought Windows uses a dd/mm/yyyy...

Paddy - Would turning the filter on be the same as leaving the Filter property turned On, manually turning the filter on and saving the report? Ive noticed that if i manually filter the report it does not work as expected: For example if i filter the report to show all records for just May i...

Report <- Date range <- User Thanks for the responses, I tried your method first Calvin and the result was exactly the same as my previous method. When the report opens all the records are displayed. If I then put the report in design mode and look at the filter property it has the correct SQL...

I have a button which opens a report and filters the report to show only records between a date range which the user chooses by typing a date into two edit boxes called "start date" and "end date". The VB for the button is: Dim stDocName As String Dim stAcView As String Dim strWhere As String...

SWITCH statement in SQL Many thanks for that. How would i incorperate SWITCH into an SQL statement? I thought SWITCH was a native SQL clause, but it seems it is a Visual Basic function. Kris.

Could someone please tell me the format for the SWITCH clause in an SQL statement. And also where the SWITCH command goes within a SQL statement. I cant find it on the net or in Access help! What i am trying to do is take a number and turn it into a string without changing the orignal data...

dynamic criteria for charts Is it possible to do that from an on click event. ie. open the report and set the criteria. The reason for this the charts must display a certain date range, so the user enters the start and end dates in edit boxes and when open report button clicked the report...

I can create a button which opens report and filters the data using the 'Where' parameter of the DoCmd.OpenReport function: example: Dim stDocName As String Dim strWhere As String strWhere = "[Date] Between #" & [start date] & "# And #" & [end date] & "#" stDocName = "Trend...

Thank-you very much. Worked perfectly. I think i need to learn more VB, or learn the properties of the objects, this stuff is simple, yet allow so much more ability for your databases. Kris.

Is it possible to have the deafult value for a field be set to what ever the last records input was. eg. if i created a new record and selected "Smith" as the value for the name field, then created another new record, the default value for the name field would be Smith. Therefore all new...

I am developing a database using Access 2002 set to use the Access 2000 file format, however the target machine which the database is for use on has Access 2000, but different MDAC versions. The cause of errors is the MS Access 10.0 Object Libary. The target machine has MS Access 9.0 Object...

I see. So is there any way to prevent focus going to the subform, would an invisible control set to first in the tab order work or is it just the fact that the subform is displayed that the parent form looses focus? thanks Kris.

But i am not leaving the form, i am just going to the next tab on a tabbed control. Going from tab to tab does'nt cause access to save the record. It is only when i go onto a tab that contains a subform.