Search results for query: *

No, actually the ID fields in the Visit Data Subform table are text since they were intended to display the names on the form but only the ID#s in the table! Duh. I can't believe I did that! Fixed that, and now it works - I just have to adjust the layout for a standard 8.5x11" sheet, not...

Ahhh.... This is because I misnomered my fields clientID and practitionerID thinking I would use them to look up and display names from the info tables related by the ID# to the visit record table (each visit participated in by one client and one practitioner only). This, of course, is not...

Thanks for the code. Actually, it's telling me that: "The record source '~sq_cVisit Record~sq_ccbxClientID' specified on this form or report does not exist." This is a new error (before your code), which is a bit befuddling as the cbx does not have a Record Source, but has Control...

Report recreated. Wow, its faster the 3rd/4th time around. Still no luck... Center for World Indigenous Studies www.cwis.org "Always carry a tuna sandwich in case of tigers."

I have a client data form. I want to be able to select a name from a combo box and show the record of client contact info on that form, with the visit records related to that client appearing, sorted by date (most recent first) on the subform (not in tabular style). The relation is through the...

Verify data type of fields in tables or in the report? Can I just change the names and control sources of the # fields (as well as those relevant fields in the tables)? I've done that. Otherwise, the recreation will have to wait until tomorrow, as even the wizard takes 15-20 minutes. Going...

jigjag, I don't know where to find the Sort/Grouping expressions, or how to unmuddle them, or where to go to create a query with the pseudoSQL Access generates. I tried with a"normal" new query design and got the same error message. Access created all this from its wizard, and the...

Hey all, Here's a question: I have one combo box that works properly; it's not the only one in the subform, and its pertinant properties (in the box) are: Row Source Type Table/Query Row Source SELECT [Test].[Test] FROM Test; I have a table by such name (my original attempt at creating...

Sorry for the lag time, I've been out sick. I added the breakpoints you specified, and it stops at Report_Open: "End Sub", so its started reading data... Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) End Sub Private Sub...

This is the most hideous form of Access torture yet. I created a sample report through a *shudder* wizard to see if I can get the report to pull text in as a result of calculated values, e.g.: If (value)>(limit) Show Text.rtf ... or some such thing. However, I have an unadulterated magicked...

Tony, Yes, I typed in the error message - I can't copy it from the dialogue box. No, of course I don't have [table].[field], but I did most of the design with *shudder* wizards in the interest of time, and now I am paying for it with the poor layouts and naming.... (I'm really a web...

Exact error message: Record Source 'SELECT [table].[field] FROM [table];' specified on this form or report does not exist. ... and for all I can see, it does: 'Heading Column PName PNameFieldValues = "PracticionerID; Name" Call LoadPractitionerName(0)...

I had list boxes, which I've converted to limited combo boxes. I had changed the order of my table columns (thing; thingID) so it would show up properly, e.g. a list of things, not the IDs. Now I've changed it to your format, which I now recognize as far more sensible than my cobbled fix, and...

Thanks for the enlightenment. However, why would I get this problem when replying to an email I received? Emm.

Bill, I'm having trouble e-mailing you, from either of my accounts, either replying to yours or typing in the address, so the problem seems to be in transmission (see thread858-639092) or that your system does not recognize that you exist. Any ideas?

I am getting a delivery failure message that's new to me. Any ideas? FROM: Mail Delivery Subsystem [MAILER-DAEMON@fallback-mx3.atl.registeredsite.com] TO: <Me> SUBJECT: Returned mail: see transcript for details The original message was received at Tue, 26 Aug 2003 14:39:37 -0400 from...

Wonderful! It no longer complains! Now, if I could just get the form to update the table... Thanks! Min

Wonderful! It no longer complains! Now, if I could just get the form to update the table... Thanks! Min Center for World Indigenous Studies www.cwis.org &quot;Always carry a tuna sandwich in case of tigers.&quot;

The error message I received appeared to be identical to yours: The LinkMasterFields property setting has produced this error: &quot;The object doesn't contain the Automation object 'Client Personal Info_ClientID'.&quot; ...where refers to the list box (lbx) ClientID which links to...

No, The error says &quot;...object 'TableName_lbxName'&quot; Emmali