Search results

Not confusing at all, nicely laid out. Added to it to include being able to search via telephone, mobile, post code etc. Works a treat. Thanks

Thank you agehoops. Works better than what i was coming up with, much more than i could of asked for, thanks again. :)

I know what you mean, one result will be returned, then its a case of tabbing across for the other 4 bob's. So its not the best peice of code, but its somewhat serving it's purpose to saome extent. If you can offer any alternatives i'll greatly appreciate them. Thanks :confused:

Hi, I have a form based on a table of buyers, i also have a copy of this form which includes a search button, so you can type in a surname and it displays the records above. I have got it to work, but when it finds the record it still says "Record not found for: [Surname]. I think its just a...

Are you using a button to delete records? If so, create the button again and use the wizard, that'll do the code for you and work. Ive not had any problems before by doing that. An axample of mine: OnClick Private Sub DeleteRecord2_Click() On Error GoTo Err_DeleteRecord2_Click...

View this, i think this is what your asking: http://www.access-programmers.co.uk/forums/showthread.php?t=81704 Try the Search feature, it really works...lol

You could do a requery command to update the part number automatically once you have selected the catergory and the same with the state based on the city chosen. Also a bit of colour would make it more appealing.

Me too please... :)

I viewed the first 10 pages of google and didnt find anything before coming here. Didnt think to search this site, thanks for you help...again. :)

Is it possible to insert a moving .gif into a form? If so how? Thanks in advance..

That code works fine. Thank you for your help, much appreciated. I didnt know you couldnt use the cancel event command for an OnClick event. Can someone explain why? I cant see why that wouldnt work.. The code is confusing, because i kept changing things around, taking things out and adding...

It now looks like this.. Private Sub DeleteByDate_Click() On Error GoTo Err_DeleteByDate_Click DoCmd.SetWarnings False If MsgBox("You are about to delete a record. Do you wish to continue?", vbYesNo, "Warning ...") = vbYes Then DoCmd.OpenQuery DoCmd.SetWarnings True Else...

There is two queries, delete by date and delete by dates. So the user can enter the date or between 2 dates in the dialogue box. The button on the form runs the query, but to prevent records being deleted by mistake, then i want some kind msgbox, to prompt the user, basically to confirm if this...

Code in full.. Private Sub DeleteByDate_Click() On Error GoTo Err_DeleteByDate_Click Dim stDocName As String Dim msgResult As VbMsgBoxResult msgResult = MsgBox("You are about to delete a record. Do you wish to continue?", vbExclamation + vbOKCancel, "Delete Record?") Select Case...

VB isnt my strong point. What is the ok/cancel code after vbok and vb cancel? Thanks in advance. Dont wish to complicate things, but is it possible to have this message box appear after the query is run but before the deletion takes place, to confirm whether or not the user want to perform...

On Click.....

Ive written this error message, to prompt the user before they run a query. If they click yes, then the query runs. If they click cancel, then i want nothing to happen (query being cancelled and the other msgbox 'You have cancelled the previous operation' to not appear). MsgBox ("You are about...

Thanks SJ McAbney, that code worked a treat. It doesnt check for invalid characters, but it does what i want it to, for testing so im happy, thanks again, your help is much appreciated. :)

how do i create a module, that isnt an event procedure? How does this link to the field i want it to? Probably basic stuff, but im a little unsure what you mean... Thanks for you help

Hey all, What is the easiest way to create a validation rule for entering email addresses i.e. making sure the @ symbol is between text. e.g. texthere@texthere.com Thanks in advance...