Search results

i checked the links they are fine, if this helps anyone figure the mystery out i noticed when i delete a record from subform A and take a look at the other two subforms, one shows the correct updated number of records and the other still show the old total and the fields in the record show the...

Subform Hell!!!! I have no idea what is wrong with my form!! I have a form with a tab control which has a subform on every tab. when i update say subform A i need subform B and C to update. The problem is that subform C updates and subform B does not! they both have the same record source and...

sorry i had trouble sending the file. hopfully this will work

I dont think i want to use option buttons for the other fields but maybe if you took alook at the form you could give me another suggestion. The area you want to look at is the Course Packet group. Then the other field is called Course Packet completed. that is the field i would like to...

I forgot to mention that there are other check boxes in this form that i do not what to be evaluated. So this doesn't work for my form. Is there a way to use this code but reference only those 5 checkboxes? Sorry to be such a pain but i am learning! Any help would be greatly appreciated. thanks

thanks for your help dcx693 but i guess i am not very good at building functions and reference them in event cause i get an error message when i tried what you suggested. the error message i get is Comple error: Expected: line number or label or statement or end of statement. not sure what is...

Ok, how would i do that?

Actually what i need to happen is the opposite. When all the check boxes are checked then need another check box (check8) to check yes when all boxes are filled in. I figure an If statement but i dont know how to write one with multiple conditions. If [check0] = True Then If [check1] =...

Not sure what to call this I have a (Check List) form that has several yes/no fields. I need another yes/no field to automate to yes when all the other yes/no fields have been checked yes. Not sure how to go about this. Any suggestions?

Thanks Hayley i will take a look at the thread. I did find a fix for the excel spreadsheet addresses!!! I did an update query that added "mailto:" to all the addresses in the access table and now they all work. That was easy, now to work on the other issue, let you know how i do once i take a...

GumbyD, that didn't work for me. It puts the "mailto:" somewhere in the middle of the address even though I typed the format exactly the way you show. I also have several excel spreadsheets that have email addresses and when I import them into access they lose their "mailto" feature and access...

I have an access table that has an email address field that i have assigned a hyperlink data type. If i type an email address with the "mailto:" in front of the address it works fine. Is there a way to have the mailto come up automatically when you type the email address so you dont have to...

I have a db that is used for creating several different labels. I need help building a form that will allow the user to select multiple selections from a list box for the purpose of using those selections in a queries criteria. For example: I built a query for labels but want to have multiple...

i tried your suggestion but got the following error message "The page number you enter is invalid" Any idea what that means? Thanks for you help

is there anyway when opening a report to have it automatically open to the last page?

I have a main form that has a tab form with multiple subforms on each tab. I would like to create a button on one of the subforms that would jump to another subform that is on a different tab and match records based on a common field. For some reason the event procedure I wrote a month ago...

Thanks for replying Databasedonr, but i figured it out already. I used the "DoCmd.FindRecord" and added the criteria, that seems to work for me. Because this subform is not tied directly to the main form, it is tied to a subform in the main form i had to try something else and this seems to work.

Hello, I have a form with a tab control that has subforms on each tab. I want a button that when clicked on will go to another tab and goto the record that has the same jobid number. I am able to get the code to work as far as going to the next tab but when i tell it to goto the record that...

Thanks very much, it worked great!!!!!

is there a way to have the rename macro prompt the user for the name? thanks in advance