Search results

Okay. User open forms, starts completing the necessary data, then decides he/she needs to abandon the entry for whatever reason. They have completed certain primary key fields and some other fields that require data are missing. I do not want this part record saved in the table. They can go...

Evening All, I have a form with the following event codes:- Private Sub Form_Current() DoCmd.GoToRecord , , acFirst End Sub Private Sub close_Click() DoCmd.SetWarnings False MsgBox "Returning to Main Menu." & vbCrLf & vbCrLf & "Any details on this form will not be saved.", , " " On Error...

The Doc Man, Thank you very much for your concise and very informative reply. I understand VBA in excel as I use it every day so I totally understand what you are saying with regards to ranges/cells/columns etc. However, I am at the novice stage when it comes to Access VBA so I am a bit lost...

Hi all, I would like to export results from an Access query and append it to existing data in a spreadsheet. I do not want to export the headers from Access either. Also, if a spreadsheet has several different tabs, can you define which tab the data can be appended to? I would like to...

Evening all, This may be a really silly question so I am preparing myself for a barage of pleasantry abuse! I have created an inventory/invoice database for a client. Works fine, no probs. They have now decided that when a particluar type of sale is processed, they would like the letter "G" to...

Hello All, I have seen many threads on this mouse wheel issue, but all I am looking for is an appropriate code to deal with my related problem. My form opens to a new auto-number record of, say, 100. If you scroll the mouse wheel forward the record remains at 100. If you scroll backwards, the...

Thanks for the code. WIll give it a go. Cheers.

Thanks for the quick response. Can you explain how I would e-mail it as a snapshot please. Is it part of the sendobject command? Not sure. Thanks.

Afternoon all, I have a report which has a bit of formatting in it, i.e. shaded boxes, logo etc., to make it look presentable. My objective is to e-mail the report whilst retaining the existing format. I have started to venture into sendobjects and have tried using several of the output...