Search results

hi, i need some help with my database, i'm trying to search a subform and return its parent record. i have my DB setup as a main form and subform which is linked. the main form contains a customers type form and the subform (in datasheet view) contains their products. what i would like is to...

Hi, i have a database which has a main form and subform built in linked by parent/child customerid, what i would like to do is search all the subform records from the whole DB and return its parent record on the main form? can this be done? because if i use find it will only search the...

Hi, i have code which is attached to onclick of a checkbox, what i want it to do is if the user clicks it and checks it then to add some note to a memo field, if the user clicks it and its already checked then it doesn't add a note to a memo field. Private Sub Check45_Click() If Check45 = 0...

Hi all, I have an issue with code for a button that sends an email: the strEmail has loads of text (which i've not pasted due to length) but i have 2 different types of emails to send depending on values on the record... i'm trying to write some code so the .htmlbody is strbody1 or strbody2...

hi all, I need some help with some code i have, i have a button where if the user is an admin (in a table) it opens a form if they're a user it pops up a message box, the problem i'm having is if the user hasn't had any details put in the table it opens the form anyway. i'm using the...

Hi All, ive searched the forums but nothing which meets what i need, i have some code which creates a HTML email from button click using fields within my db, the problem being i need the email to be quite long and VBA is not letting write more than 25 lines on an email using the _ and i have...

Hi, I have a main form where it has a subform linked by a reference number which displays in a datasheet view, then when you doubleclick the record in the subform, it opens up in more detailed version of the same subform on a form which also has a subform linked by the same reference number so...

Hi, I need some help in regards to a dlookup problem I have, I have a switchboard which has 2 buttons, I'm trying to set-up the "Admin" Button to only load if a user is an admin. i've setup a table (tblUsers) which has 3 fields (UserID,Displayname and Group) the userid field is based on the...