Search results

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...

Actually, I'm having second thoughts about what I recommended for you. The problem is: If you have an entry that has a quote or two in it, and you take out the quotes and then search for that, you won't get a match. Perhaps someone else has handled this and will buzz in with some better advice.

OK, ten posts on this thread...and you don't seem to be any further along than when you made the original post. 1. I am assuming you run WinXP? If you have WinXP Pro, you can install IIS web server and serve up intranet pages from ANY of your networked computers. 2. You have SQL...

Make a variable to hold cboSearchItem's value. strSearch = cboSearchItem Do a replace on it... strSearch = Replace(strSearch, Chr(34), "") strSearch = Replace(strSearch, Chr(39), "") Then run your query against the variable strSearch.

Data access pages are crap. You say you understand HTML, and if you use Access, you must know some VB. Put the two together and use ASP to build web pages. (You need access to a web server...or at least a computer capable of running IIS or PWS.) There are a lot of tutorial web sites for...

Hi, In your first post, it is very difficult to figure out what you are having a problem with. I know you were trying to elaborate here... ...but it didn't help much. If you explain what you are really trying to do in a nutshell, perhaps we can streamline your code and get it to work at...