Search results

Hello All, I have a quesiton: I have in place an error handler that traps the Runtime error 429 and resumes with the rest of the code; by trapping the error , will it overtime corrupt my database? Thanks!

No opinions?

I am glad I could help!

Crap! I didnt see where this post was 2 yrs old. Sorry! Maybe: .FormFields("fldInvestigator").Result = Me.comboboxname

I dont know if this will help or not, but this is how I have the textbox from my access form linked to the word doc: .FormFields("field on your word form here").Result = Nz(Me![whatever your textbox is name goes here]) The field DESTINATAIRE, is this named in your word document under...

Ok, new development: I changed the combo box to populate with [LastName], [CaseNumber] and now it populates the Access form as it should. I would still like to know why it did not work the other way around, Please. I still have the issue of having to double click the print button.

Ok, now it is working somewhat. I have the code to populate my form (which works, yeah) from another site: Private Sub cmdPrintForm_Click() Dim appWord As Word.Application Dim doc As Word.Document 'Avoid error 429, when Word isn't open. On Error Resume Next Err.Clear...

Hello all, I am trying to populate a word document from a listbox selection. The word docx populates just fine with a form (Rowsource is a query) and the code below in the click event of the button. What I would like to happen, is when the user selects a record from the listbox and then...

Hello all, I have a few auto populated forms (Word docx) and was wondering where you guys store your forms? Do you just keep them in the documents folder on your computer or do you store them in a table within Access? Thanks!

Thanks for the tip Pat!

I will try this, thank you! I wish I could think of things like this! Good idea.

Thanks for the explanation plog! I thought it had something to do with the empty values.

Hello all, I am running a query that is used to show a count of certain values. For example: The number of different Allegations. The values would be grouped and counted: Damage Claim 3 DUI 2 and so on. This works as it should in the query, but I noticed that the query...

pr2-eugin, That works! I was trying the true, false part in both statements, arrgh. Thanks pr2-eugin!!

Hello All, Is there a way to use the "AND" operator in an IIf statement? I have two statements that need to run in the control source of a control. IIf(DateDiff('d',[LDStartDate],Date())>=366,"*","") Checks to see if the LD Start Date is over a year old. ,IIf(IsNull([LDEndDate],"*","")...

Hello All, Yet another question from me. Is there a way to make the mini toolbar, with the attachment control, visible all the time? Thanks!

Thanks again Bob! You hit the nail on the head again.

Hello all, I have a subform on a tab of my main form. I get an error message: The Link Master Field property setting has produced this error: User type defined not defined. I noticed that this happens when I navigate to a record in the subform that does not have any values. For instance...

Ok, I changed the form to have the main form populate from the main table and the subform from the secondary table. Bob, if I could ask a favor, when you get the time would you be able to create an example (from the db example I posted) of what you were suggesting with the tblTimelineTypes...

Bob, Thank you for taking the time to look at my issue. I see what you are saying. If I change things, then doesnt that mean I will have to change my form design? Will I have to use combo boxes for the user to select each Timeline event? (JZ gave me an example of a junction table setup, but...