Search results

Hello I have been searching for ages for a solution to my problem, I am trying to call a public sub within a subform. The main form is call Document Details The subform is called DocumentDetailsSubform and the sub is called GoToFirstRecord I use call...

Thank you for that, the problem I found when I do this is that it comes up with "Access can't find name 'email' you entered in the expression" I am putting =[email] in the macro to argument. If I drop the = sign it happily works and tries to send an email to [email] Hope can I get it to call...

I have a form which has a field which has an e-mail address in and would like the Sendobject to take the e-mail address in that field and put it in the to line when the e-mail opens. I thought it would be as straight forward as Form![Customer]![email] in the TO box within the macro but, it...

No, it is called Document Subform. Thanks Iain

Thank you Bob, this is to try and combat the problem that you posted an answer to the other day. This is how my code stands but I keep getting an error. Please, where am I going wrong? Me.[Document Details subform].Visible = DCount("*", "Document Details", "[Part Number]=" & Me![User ID]) Main...

I have a subform and some of the users keep typing in it without a master record and thus creating orphans. I really don't want a pop up box. Would there be a way that the subform was invisible if the user hadn't added a record to the master. I was thinking in if user id is less than 0 form =...

Bob Thank you so much for that but I already have the referential integrity ticked and it all works fine apart from when someone forgets to create a parent record and just starts entering info within the subform and then we get an orphan record. What I would like is if it would either create...

Hello, I have done a search and can't find an answer to this. I have a main form and when you start to fill in the fields it will fill the default values for the others. If I start filling in the subform before entering in the main form the data is lost. Is there a way in which when entering...

Xolo, Old thread I know but did you find a solution to this? I am trying the same thing since if you enter something in the subform with no master it gets lost. Thanks in advance. Iain

Many thanks, that really helped and found the problem. STAR!!

Hello, I have a macro which runs several queries, some of these queries do not work on some of my computers. It doesn't bring up any error message and looks like it is running properly. I'm not sure where to start looking for a problem. If I run the query on its own then it works fine. Any...

Many Many Thanks

Hey, Think this is a bit of a silly question but I can find anything about it. I have a select query with the criteria that the user enters. Is there a way I can get it to show information that is contained in the cell but may have other text in there as well? Find James when the cell...

Sorry if the above isn't that clear. Access displays the text as a suggestion, you then have to either type it in or copy and paste then Access will reecognise it. Thanks Could there be some other code I could use as an event procedure to accept the suggestion???

Hello Thank you for that, I have got it to work and even best when the user has to double click on the cell to transfer the data to the relevant cell. The only thing is that Access doesn't recongnise the text in it as text. You have to either type over it or copy / paste. The main reason is that...

Hey, thank you very much for that but I was hoping I could get it to do it by user request. It is the case that if we haven't got a 001 we can offer a 002 to the customer and the user then presses a button / shortcut and it takes the 002 and puts it in the next row down. Thanks

Hello I recently found the shortcut CTRL + ' will take the information from the field above and insert it into the next row. But I want to take information from the previous row but different column and insert it into the selected field in the next row down. So for example Part Number...

I would like to get Access to add the contents from a specific cell from the row above and put the details into the selected cell. I would like this to happen when the user selects either a button of shortcut key. This is used when we type a part number in and it suggests a different one (...

Ignore me, Done cheers. Iain

Wonderfull, Many thanks, would you know is there a simple way to get it to return more than one field, ie Home Address & Home Postcode. At present I just have 5 IIF statements for each address line. Yours Iain