Search results

Cheat by using the Header and Footer section for some of your data

Not quite sure what you are after but if you use the Expression Build part on a Query you can pick its name up on a Form in a bound text box. For example, (in a completely different db) Name: [FirstName]+ " " + {LastName] will give you a field Name that you can access in your Form.

No offence taken; the bulk of this code was taken from this forum and as you can see, I have a joined string for the path. When I wrote the code, I wanted to debug it using a separate variable without affecting the core underlying code which was not mine. I appreciate that I have coded it...

We all learn something everyday. I defer to your greater knowledge - perhaps you can take this thread over now. At least I got Cereldine on the right track.

How about opening the form and selecting the first record by docmd.gotorecord,,acfirst - read all the data fields into public variables and then just print those off on the report? Note - you will need to set focus on each field to get the variable to record the data.

The Warnng Its a standard Access warning say that it cannot write the record as it would create a duplicate record. It would be nice to get this warning from my cmd button that is set to close the form.

Thank you - the problem also seemed to be with the nested If statement. Any thoughts on why the X close gives a duplicate warning and why a simple cmd close button does not? Ted

I have what should be a simple problem but cannot get a simply DoLookUp to work. I have spent the last hour running through your searches but jsy can't fix it. I have a table of Unique Part Nos and just want to do a simple user message to prevent any duplicates being entered. I know the table...

I have a for where the field has a Lost Focus event that checks the content of the field. For some reason, when the form opens and the cursor is flashing to await information, after about 20 seconds it triggers the lost focus event. Can't see why the field does not remain with the focus until...

Outlook You may need to bear in mind that Microsoft XP regards mail being sent to Oulook via VBA coding as a potential virus. It therefore will trap each "send". The conseqence is that for any bulk mailing, you will have to accept each individual e-mail. There is a method to switch this off...

Thank you So easy too.

Docmd.ApplyFilter, "Field = 6" finds the record where the data equals 6. BUT. Docmd.ApplyFilter, "Field = intVariable" fails. I have tried all sorts of other syntax. Help please. Thanks Ted

Thanks I like Outputto - it works fine. Many thanks

NotePad Thanks - but can you be more specific. Let me give you the whole story. I am outputting some data from a report as a .txt file. When this code runs, the created file opens. All I want to do is Close it with code. (or prevent it from opening) Thanks

I want to Create a NotePad or WordPad object. I know the VBA code to create a Word Document but as my file must be a .txt file, I need to use NotePad or WordPad. The usual Word Code I have use is: Set WordObj = CreateObject("Word.Application") changing this to...

I would like to use a form button to open a word document in the My Docs folder. Whar VBA code should I use behind the button? Many thanks:rolleyes: