Recent content by gmc2k2

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

any help on this would be really appreciated

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

I didn't realise it was a lot easier than i tried to explain :( i was up all night and havent had much sleep, sorry for the confusion. Thank you so much again Paul absolute legend.

Hi paul again :) The code should be attached? there's a checkbox (check45) i know i will rename instantly :) it was just a temp code with the code above it should run on click of the check box and what i want it to do is if its clicked and checked it then runs this code: If...

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

thank you so much again Paul, i'm sure i selected the code tag?? i double checked it this time too? it's been a very long day...apologies. i've adapted it to use the fosusername function: Private Sub openpipeline_Click() Dim userStr As String Dim oApp As Outlook.Application Dim...

Sorry i've cleaned it up slightly now paul to this: Private Sub openpipeline_Click() Dim strEmailreg As String Dim userStr As String Dim oApp As Outlook.Application Dim oMail As MailItem userStr = Nz(DLookup("Group", "tblUsers", "Username =""" & fOSUserName & """"), "User") Select Case...

another quick question paul, Ive adapted the code slightly to return a message box with yes and no buttons, what i would like is to email the details if the user is unregistered and they click yes on the messagebox to email me, but it's returning a expected a Sub, function or property...

Paul you continuously help me out, i can't thank you enough buddy :) thanks again, i don't know why i selected quote...slip of the finger i think :(

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

works like a charm :) thank you so much AGAIN paul :) means a lot

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

yes line continuation is what i meant, i couldnt think what it was called :( ah ok i understand :) not i have to try and style 42 lines using the above method haha, here we go!!! thank you so much pr2 it means a lot...and saved another headache

thanks for this AccessBlaster :) when i get back this evening i'll start with what you've said. really appreciated