Search results

Tay! Hi Tay Not long now before your in France I have converted to Access 97 for you. I will email you during the week too Ian

here is the cut down version access 2000

Whats wrong with this query? ======================================= SELECT [Accident_Incident reports].ID, [Accident_Incident reports].[Report Number], [Accident_Incident reports].Type, [Accident_Incident reports].Location, [Accident_Incident reports].[Accident Category], [Accident_Incident...

Hi Merdok Did you get DaveUK's code to work I have cut and pasted everything into my dbase and keep getting the following error: Open the form, click browse button, select directory. The system tells me that i have found x number of files, press OK and then get the error message Type...

Thanks FoFa, I have tried the froms option but still I cannot get the Export Text Wizard to operate correctly. I keep getting the same error message: Too few Parameters. Expected 2. Any other ideas? :mad: :mad: :mad: :confused: :confused:

I have a query which I run that allows me to export the data the a Foxed Length Format which uses a spec from our client. The following code works fine: Between #01/08/2003# And #31/08/2003# The only problem with this is that I manually have to change the dates in the query for each month...

Steve Me.Frame2.Value = Null Worked a treat. As usual in these things, the simple answers are staring us in the face. Hadn't even thought about that. Thanks for your help

Hi DCX Thanks for your response. Your right, the option group is not bound. Have searched to forum for similar problems but found none, any idea of the coding required? MS Help files wasn't helpful! (Surprise) Mousemat

Help I have an option group on a form that populates a hidden text box, this works fine. Everytime i press save & new record, the option group is still displaying the entry for the last record. How can I stop this from happeneing and have the option group be blank each time? Mousemat

Kevin & Cosmos Thanks for the link. Have check it out and it 'sgiven me plenty of ideas for how to design my one. I'll keep you posted as to how its going. Ian

Thanks cosmos

Thanks for your response fuzzy. Yes the poor receptionist will still be the main point of input. As for other dept managers seeing the data, that isnt really an issue at all. So tabbed form with queries, sounds like a challenge to me. Ian

This idea is put all or as much of the data on one form. What they are currently doing is looking at the excel spreadsheet on the screen to determine who and how many people are off on anyone day. What they want is a similar system through access whereby they can see a similar screen to the...

I have been tasked with producing a database to collate information reguarding hours worked, overtime etc etc. That part is pretty simple. The problem I am facing is producing holiday chart similar to the screen shot provided. My main question is simple. Is this possible, obviously it will...

Mile Thank you so much. I have spent ages on this trying to work it out. Many thnks. Im not sure what you mean about the relationship problem though, but i will look into it. Many thanks once again

I have added my Database in Access 97 format.

Help. I have search the forum for some considerable time and tried most ofthe code that I have found. However, nothing seems to work on my Databse. The scenario is simple. From the Enter Invoice Form, there is a combobox, if the required name /company isnt listed I want to be able to double...

JT No, I havent produced a report in access, as this is simply an additional item. they have been using the old sytem for over 18 months now!!!!! Plus, Im not sure how to produce a report similar to the excel sheet from access with boxes and lines etc?? Ian

Hi JT The attatchment I havce sent is an excel spreadsheet yes, that is how they are doing things now, but everytime we have leavers or starters, they have to update both the database and the spreadsheet. They want to be lazy and just do the database.

Hi, not sure if this is possible, but I have a database with all the details. I have now been asked to produce daily tick sheets, similar to the excel spreadsheet I have added. The idea is simply so that Manager can see who is handing in their labour vouchers and who isn't. The data will not...