Search results

i have a form which uses a calender then runs a query and picks out staff members who are in the next day and you can click a button to open an access report which then shows there jobs for the next day. This means i then have to put preprinted paper in the printer with logos etc. I have...

I have been trying to create a login form so people have to enter a username and password. the username box is working as when i press the login button without a password it displays an error which is in the VB code. However if i try and do it with a password as well i get the following error...

i have tried adding a label to a form and putting some vbcode in so that instead of the time being static it updates it like a real time clock. I put this in the ontimer event in the form and set the number of seconds but the form is not displaying the clock. is there something im missing over...

i have a database where by it runs and query depending what date is selected from the calender and then in a drop down box shows the avaliable reports. I want to be able to import that particualr data and put it into a preformatted excel. Is this possable to do.

i have been trying to create a field that will store multiple values but when using the lookup wizard as suggested after i click the table i want it to get the values from it doesnt give me the check box for allowing multple values. has anyone else had this problem or what am i doing wrong...

I have this subform which records all the training undertaken by a client. It also stores the ID of the client which it grabs from the main form and this is all stored in a training table. One thing it use to do was also record the clients surname in the table which it also use to get from the...

i have a table setup in a database to store information on a clients training. They want to store 2 lots of training information. So i have setup to colums within the table as below e.g Training Training 2 In these colums its storing that they are either doing training or seeking training...

i have a query which filters out and shows outstanding payments it works really well expect that if there is two dates the same e.g payment date made: 03/03/2008 payment date due: 03/03/2008 it still shows them up in the report is there anyway i can stop these from showing.

i have a sub form with a calender on it and you enter a start and end date and then it runs a query between those two dates and opens a report. I want to have another form to also open up so they can select to only show the results for particualr clients. is there a easy way to do this.

i have a form which has to controls on it lets call them control A and Control B. If i put a date in Control A and one in Control B and then hit the button to open the report its not filtering out between the dates selected. Its showing dates previous to that. In the query that the reports...

i have a query and i want it to not show the results if the dates are the same in two columns.

I have a query with two fields in A: Date Payment Made B: Date Payment Due I want it to filter out and show if someone has an over due payment and also by how many days. i have tried [Payments]![Payment Date Due]>[Payment Date Made] and also in the Payment Date Made column tried putting in...

Re: Form Combo Boxes for Search I have a form with two combo boxes in both getting the customerid from the customer table. what i want to do is to select certain numbers from the list and then get the report to filter out and show the ones i have selected after hitting a button. what is...

i have two forms lets call them Form A and Form B on Form A there is a button that opens form b and shows up only the records that are related to the customer that i have open on Form A. e.g if im on Client A it shows up Client A in Form B. I can fill out the information on Form B and it...

Re: Groups in access report i have a query which is listing all the clients that are male and female and also if they have a disability and also there ethnicity. What i want to show is below: Male = Total Number Female = Total Number Disbilty = Total Number List of All Ethnicity's and how...

i have a database with a number of tabs on the first tab it has all the details of the client e.g Name, Address etc. On the second it has a sub form and they can fill out there training. This all gets stored in a table called jobtrain. It seems to be logging the name and and there employment...

Re: Spaces in Field Names i have a field name with a space in it. With the code im using how can i stop it brining up the error. expected: list seperator or ) the fieldname is CFirst Name

i have this form in which when you press a button it opens up word and using bookmarks pulls in the data from the form. But if someone hasnt filled in one of the fields it brings up invalid use of null when i press the button how can i stop this. i have pasted the code below. can anyone help...

Re: Date Field Order I have a form with a text box in it where someone puts the date in. This was showing all the dates in order but now the most recent entry instead of going at the top is at the bottom. How do i order them in date order. I have heard you can use the Order By option. Can...

i have a database which i have created with a form. Now there is also a word document i have been given and i want to be able to add a button to the form and when i click the button it loads up word and then exports out the name and address from the record im on into the word docuement which is...