Search results

sorry for all the code but they asked for the SQL so i pasted it in. Because the form im using it is trying to record if they are getting training from a combo box and a start and end date but also doing a second time incase they are doing two courses.

Here is my SQL Code for the query that someone wanted: SELECT Jobtrain.Situation, Jobtrain.Client, Jobtrain.[Start Date], Jobtrain.[End Date], Jobtrain.[Situation 2], Jobtrain.[Start Date 2], Jobtrain.[End Date 2], IIf([Situation]="Training",1,0) AS Expr1, IIf([Situation2]="Training",1,0) AS...

I have a query setup from lets say a table called table A In table A there are two colums one called Job A and Job B I want to run a query so that if the job say window cleaner is found in either job a or job b it will show up the results but if i try putting in window cleaner in the critiria...

Re: I have tried using Between [Forms]![form name]![cboStartDate] And [Forms]![form name]![cboEndDate] and this works on the reports form on its own if i access the reports form as a subform from the main form it still asks for me to enter a paramater value. what else could that be.

Re: Form Paramanters in Query I have a form with two combo boxes they get a start date and a end date and are named as cboStartDate and cboEndDate. You then select a report name from another combo box and hit a button and it opens up the report. I have put in a query say for the first report...

Re: Database The file is stored on our file server but the time both on the server is correct the time on the PC is also correct now it wasnt before but its still showing only access files to be saved 1hr behind

We have this database which is used by a member of staff for some reason even though the system clock is at the correct time and all other office programs like word and excel save the file and show the correct time. when evre this user saves there database and goes to view the time its showing...

thank you thank you for your post i will try and have another look at this at see how i get on with the database. this may prove to be very useful and i will let you know how i get on. phill

Code I have tried amending the code to work in the drop down list box. I have a table called contacts and a query called Training Course Query are you able to amend the code and paste it back to where these go so i can compare it to mine to see if im doing it right . cheers

thanks hi Keith G didnt think of it like that i may try this tomrrow and see what happends.

the command button just runs a macro which closes down the current form and then opens up the other one. on this second form im wanting to pull up data about dates and times from that course i have select on the first form.

i have been trying to for the last several weeks create a database which holds information about companys e.g addresses etc on it. It also has a subform on it which runs a query and shows me the courses they run with a button beside it. This subform propertys is set to continues and so there is...

designer here if you could message me back with a list of things you would like it 2 do and also what you would like to have it include i have rough someting up and then send it to you and see what you think

hi i had a go with ur example but still couldnt really get it 2 work someone has suggested i could create 3 querys each one filters out the e.g the course duration for that particualr company and then create 3 forms and then use a button to load each one but i have created the 3 querys and...

hi could you explain in more detail how to do this sorry im being thick but didnt relise you could filter on a form?. they now what the database done by tuesday so i need 2 get a move on

I have a form which has a subform on it and this performs a query and displays a list of courses only done by a particualr provider which changes when you change the record i now have buttons beside each course and want to be able to get it to open up another form and then display dates for that...

will it still work will it still work though the inital box on the form showing the company name is a text box.

im creating a database for a team that run courses. someone else started the database but never finished it. I have 2 tables which i will refer to as Contacts & Training Courses. I also have a form that displays the information from the Contacts Table. All the information that is being displayed...

I have two tables both with a company ID field in the same numbers in both tables the first table contains also a field with the company name and the second table contains the course title. There is also a form and on that form i want to be able to create a drop down list box showing the courses...