Recent content by Sergeant

Set all your width attributes in % instead of pixels. There is no reason for the horz scroll bar to show unless something is too wide.

This is definitely do-able. Search for FileDialog in VBA help in access. There are other ways, as well...I believe there's something in the Sample Databases section that will help.

So, to ask the question again... Can you do this with a report, or MUST you have a word doc? I would be leaning toward a report in Access.

OK, so you're using Mail Merge. Does this currently give you one doc per record? Or does it put the whole query on one doc? The other obvious question is...could you do this with a report, exported in *.rtf format?

I'm sorry, you need to elaborate a bit more.

Just make this the first line of your sub... Me.[SomeOtherControlName].SetFocus

What method are you using to transfer the data to the word template?

Why do you need to store a value that can be derived whenever you need it? Iif(IsDate(salesdate), "Sold", "") If you must, use the AfterUpdate event of the salesdate text box... If IsDate(Me.txtsalesdate) Then Me.txtstatus = "Sold" End If

Did you ever think that you might have engineered yourself into such a corner by having a separate table for each subject? Perhaps you have your reasons? In any case, I believe you could use the Report_NoData event in each report to run code like 'Cancel = True'. When no records exist...

If all the fields are type = string: DoCmd.RunSQL "UPDATE [Location settings] SET location1 = '" & [Forms]![View die locations]![location1] & "', location2 = '" & [Forms]![View die locations]![location2] & "' WHERE PSM Code = '" & [Forms]![View die locations]![linked] & "'" If all fields are...

This will produce the windows user name (string): =Environ("username") There is also an API function that can be found on this forum. If you wish to use that, search here for "fosUserName". I normally have a hidden form open on db open...it runs on a query against the user table, with the...

So you have this...(If the picture works) You have just pasted data onto row 60 and you want to activate the row or cell that coincides with the date that you pasted? Are you going to leave the data on row 60? If not, then why put it there in the first place? You could use the .find...

If you wish to do it the way you described, perhaps you should have the popup form load the current record and then move the main form to a new record? You might even do it with an unbound subform to keep it all on the same page.

From where? Inside SQL Server...trigger/stored procedure? Inside Access?

Sorry for the delay... Here is the basic usage of the .find method of a range object: Dim rng As Range With Sheet1.Range("a2:a34") Set rng = .Find(Sheet1.Range("f1")) End With rng.Select Set rng = NothingMaybe that will help. I'm still not clear on your overall process, so I just focused...