Search results

the data im wanting to import though is queried in access for certain dates etc should that still work with this method.

the preprinted paper i was on about was actually a table with lots of different columns and cells on it not just graphics. Some of the text i want to import has to go into specific cells etc on the forms.

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 it now working i think it was proberly an error on my part. thank you for your help

Thank you for your suggestion. I tried that and the other parts and no go its still displaying the same error. I even come completey out of the database and went back in with still the same error.

i have this for the OnClick Event for the Login button on the form. Hopefully below is all the code you want. Is it ok to be using the DLookup function or would your recommend something else?. Private Sub btn_login_Click() 'Check to see if data is entered into the UserName combo box If...

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...

its ok this was working i had done everything right but the security settings in access where blocking something i think.

thank you for your help im sure i was doing it the way you have suggested but to no luck i will try again later and see what happens. as i tried it in access 2007 and it works fine.

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...

that sample does indeed work and it outputs the details i need. I have a premade form or sheet where data needs to be places in particlar places is there any of doing this i.e with bookmarks.

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.

what other ways do you think are best practice.

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...

sorry it is only stored as an identifier in the child table its not being used as anything else. Just for the person using it could cross refernence with other information.

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...

thank you for your reply. this is one thing i did think about at the start how ever with the specification i was given. They just wanted to list they where training as an option in a list box but not going to any detail like you have suggested about one person on many courses etc. thank you...

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.

the start and end bit is what i have so thats correct once you hit the bottom i want it to load a form where i can select clients and then it load a report showing for those clients details for between those two dates