Search results

How is it that Word is able to complete the line? Using a different font? Is the left margin smaller on the mailmerge version? One option might be to decrease the default margins used by Access. I have a label report which successfully puts all five lines on the label when a "Company" line...

Full: I did not try to recreate your problem, but there are several things to try first. Is the zip code field text or numeric? A zip code can have some or all numerals for the characters, but should be treated as text (if only because they often have letters!). Once you have the [Zip] in...

Mr. Dot: With the report in design mode, find menu selections "View/Sorting and Grouping." From your description, you should have at least two options for grouping: Field/Expression Sort Order Field 1...

Brian: First create your query which combines your Contact, Category, and Address information so you have fields: Category, Subcategory, Name, Address, Zip, etc. Then, "Select Distinct" would work simply by leaving the subcategory field out of your report query. Select Distinct Category...

Antomack: Thanks for the reply! It will take me a bit to interpret what you've done here... Is this your own construction? Thanks again, Matthew P.S. It looks great! I'll probably save the insert until the final sql statement, since I have to group by some other data pulled from the...

I have a database with data recorded along with the date of an event. Current state of the database can be reported using the most recent data, and monthly reports can be generated for any particular month. Now what I need is an historical monthly report. For every month back to the origin of...

It seems to me that if you can refresh the final form and maintain the errors, it could be that the errors are not caused by a problem in timing. Matt

Can you explain your table structure a little better? For example, you probably have a "Patient" table, with: Patient ID; Name; etc.; and an "Equipment" table, with: Equipment_ID; Description; etc.; Is this correct? Do you also have a linking table to relate these two or others? Matt

Disregard! Problem not solved, but I found a way around it... OK, this is a new one on me. I have created a form "fsub_Summary." This form uses sql as the recordsource. In most ways, the form is functional. I use it as a subform (hence the name) and I've created some code which rewrites...

And visible! Still trying... Could it be that the "frm_Fish_ID" is in the wrong state? A "not in list" event on "frm_Fish_ID" generates the current form, and when I return to "frm_Fish_ID" it's still functioning with that data in the combo box which generates the "not in list" event. Maybe I...

I have the following code straight from the lookup field wizard: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Fish_ID] = '" & Me![Fish_IDLookup] & "'" Me.Bookmark = rs.Bookmark It works. Now I also want another form to locate the same bookmark I have just...

It looks like the ' and " may be out of order on the final phrase. You need: & " ' )" instead of: & ' " )" Tell me if it works, Matt [This message has been edited by Matthew Snook (edited 03-14-2002).]

Imagine a "Tbl_Event" table for recording events. (This is a database of fish culture info.) Fields are: Event_ID (unique to each event) Observation_Type (selected from limited list) Event_Date (a date) Entity_ID (linked to a fish entity) This table can be linked to any other table in the...

Fran: I looked through my project but I couldn't find exactly what you want. I use this to set the date on a popup form to match the date of a main form: Me.Event_Date = Forms![frm_Fish_ ID]!frm_Pathology.Form![Event_Date] it refers to a control which is on a subform which is on a tab. In...

Jesse: If instead of "{put in variable}" you wrote "[put in variable]" then Access would not recognize what's inside the brackets and would bring up a dialog box asking you to fill in the expression at runtime. The dialog box would say "put in variable?" In other words, whatever you put in the...

Saleem: Everything is a compromise. It sounds to me like what you need is indeed the replication/synchronization offered by Access. It may increase the size of your database, but by the time you rewrite the code to achieve the same capabilities you'll have used a lot of time and probably will...

Thanks, I'll look for something like that. Matt

Would this work?: If fraSecIIIa = 2 And Not IsNull(fraSecIIIc) Then DoCmd.OpenForm "frmComments", acNormal, , "[AdmitCriteriaID]=Forms!frmAdmitCriteria![AdmitCriteriaID]", , acDialog Else Me.fraSecIIIb.Visible = True Me.lblSecIIIb.Visible = True Me.linSecIIIb.Visible = True End If Matt

Thanks! Actually, I did try pulling the msjro.dll from one machine to the other, only to get even more cryptic error messages, so I put everything back. I'll give both of your solutions a try. Matt

In developing my front end functionality, I have used the JRO library to both compact and synchronize my backend database. It all works as designed. When I use it on the development machine, that is. When I copy the front end database to other machines, I start getting error messages...