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

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

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

thank you both so much, it all worked a treat :) one more thing to do and then i can start using my DB :)

thank you so much namliam :) will take that on board. i have another question along the same lines... i also have some code which runs onload event: But it loads jobs for every user regardless if it belongs to them, what i would like to do is combine fOSUserName with this so it checks the...

thank you so much namliam saved me a headache :) i've now implemented a form opening in datasheet view for admin's to add users