Search results

thanks - thats an excellent site.

hi many thanks for this. It has helped. I am having a problem with the following where clause. it is not picking up the approveID. SELECT qry_approve.ID, qry_approve.name, qry_approve.start_date FROM qry_approve WHERE (((qry_approve.ID)=[forms]![frm_homepage].[approveID])); approveID is in...

thats great. I have copied what I can from your database, but this statement is still chucking up an error. any ideas? approveID is in the subform in a tab control. SELECT qry_approve.ID, qry_approve.name, qry_approve.start_date FROM qry_approve WHERE...

I can load frm_test and it looks like it loads qry_test. when I could click any box it doesn't do anything. any ideas?

could you explain that please, I have looked in it and can't see the bit that helps? Thanks for this.

I would like to pull that record accross to new new form and then have 2 buttons on the new form, 1 saying accept and 1 decline. then I was going to have it so that when they click accept it adds that data to another table and if decline then it just emails the original user and deletes that...

I have a subform in datasheet view and when i click on a box (record) i can use the onclick function to load another form. But how do I get it so it brings over just that record data that i just clicked on on the datasheet on to the new form? Thanks

ok that sounds good. how would I pull that specific record accross to the new form? how will it know which one i clicked on?

oh right, that seems to work for 1 button but what if I need 2 buttons, i saying accept and 1 saying decline?

Hi all, I have a query here that displays all data from a certain table. But when it displays the table data on the form (I have it as a query as a subform in a form) I want it so the user can click on one of the records and click either accept or decline on that record. So there is an accept...

wow that is great, so quick as well. the !'s worked. Thanks a lot.

I get an object required error on the following code. Can anybody help please? Thanks If frm_homepage.user_id.Text = "Jo" Then etc....

the above sounds great, I'll just now try to program it all. thanks for your help cheers

ok your second paragraph sounds like a good idea. So person A sends the completed form to a waiting table and at the same time it emails Person B saying there is an approval to check. And the rest would be the same as your paragraph. Sound about right? I was trying to do it with sending...

All, I am trying to get an approval database to work. Basically if somebody fills in a form in the database it sends it to another person to approve. If they say yes then it fills in the database with a yes and also adds the amount of holiday they wanted to the users record. If they say no...

All, I have a login form where the user types in their username and password. It looks up these from tbl_users. If the username and password match what is in here then the button loads another form. Also if it does match then it copies the username and date to tbl_logonname. I am asking how...