Recent content by TazAdams

Hi Chaps, I haven't used subqueries before, so I am not 100% on the best way to approach this. The Scenario: I have tables; tblJobDetails tblMissingKit tblSiteDeficiencies JobID is the primary key for tblJobDetails. tblMissingKit and tblSiteDeficiencies are both tables containing (funnily...

Hi Guys, I am having some strange difficulties with trying to open an excel file. To briefly outline what I'm trying to do; I have numerous queries which I am using as reports, once the user has set the parameters for the query, I run the query and then export it to excel (using this...

Thanks for all the help guys. I've now sorted it with your help. It turned out that the formats were being interpritted as US dates instead of UK. I think I may have made a few changes code-wise to it to, anywho, anyone who has this problem, here is my fix: SplitStartDate =...

Thanks for the ideas Jon. I have tried using # to define dates beforehand and that didn't work, have just tried the DateValue() and that hasn't worked either! The code I got was: sSQL = "SELECT tblSiteLog.ExchangeCode, tblSiteLog.ExchangeName, tblJobDetails.Phase, tblSiteLog.JobType...

Yes Alc, and it shows 100% correctly. If I run the query manually then it runs fine too.

Hi All, I am having an issue with a parameter query, let me try and explain... I have a table (tblsitelogs) which contains records with dates on. I want to be able to query between 2 dates (from a form which the user specifies), and then export the data from the query, to an excel spreadsheet...

Excellent guys, thank you very much!

Hi Guys, A real quick and stupid question here. I was playing around with the startup settings of my database, and I literally unchecked everything to see how it would load up.... It loaded up with no extra functionality (like no extra menus or no database window/status bar showing) - which...

That's a great idea.... what a simpleton I am! Thank you, will let you know how I get on.

Hi Guys, I have a query about splitting a database, and then restricting access to certain forms. I have a table with 5,500 exchanges in. I then have another table of 'jobs' which are all allocated to certain exchanges. When the user loads up the database, they are presented with a form which...

Thanks RuralGuy, I have changed the form to an unbound one and used the OpenRecordSet method for saving and it's working fine now. Ta !

UPDATE: I have found that it is adding the record into tblSiteLogs when I select/setfocus on the subform....

Hello All, I am having some problems with an access form. I have a form named frmEntryDetails - which is joined to: tblSiteLogs, within that I have a subform named frmViewMissingKit which is joined to: tblMissingKit. The user will fill in the top bit of the form (frmEntryDetails) and then if...

Hello, I am relatively new to Access and am currently in the middle of creating my first proper database, so please go easy on me if its a simple solution :D. Basically, I have a table (tblMissingKit) which I am displaying on a form. I have about 6/7 fields in that table, one being 'Item...