Search results

Nah... it won't matter. I just try to make the relationships screen easily understood. See the attachment. Tom

Steve: Generally, you would have a table that holds all the information necessary for a new lease. If that is the case, simply base a form on that table for input. Why you are being locked out of editing is unknown at this point. If the data you need to establish a lease is held over more...

David: I think your explanation of WHAT to do is good... but HOW is it done? What I mean is... I can create a report with whatever field control I need, but how do I query on just the current record with code so that when I click the button only the current record prints to the report...

RESOLVED: In my underlying table of client activity, I established these fields: ServiceAutoNum Date Department Service ClientNum I established a query that allowed me to query a date range using BETWEEN in the query Date field. Then, I set up a query based on that query that pulled...

I am attempting to query and report on service activity, but I am having trouble conceiving the parameters. I have a table with four fields related to this query: Date, Client, Dept, Service. What I need to do, in the end, is report on how many clients were provided each service in a certain...

Dawn: What you sent is great. I think I understand what you are saying. I am going to try to implement it exactly as you have sent. Thank you thank you thank you. Tom

Would it make a difference if I put the update requery property in the underlying table's field rather than in the form control property? That would seem to make sense to me, but I'm not sure how to accomplish that... or if it would actually work. Dawn: Sent the file 5:50pm your time. You...

I put the requery in the After Update property of the first combo, as I followed the example of the sample you posted (the one I had seen before). Thank you. Here is the code I put in the After Update property: Private Sub Service_Department_AfterUpdate() Me.[Service Provided].Requery End Sub...

ghudson: THANKS!!! I will note this code for future use MANY times!! Tom

DBL: Thanks. I have seen that example before and it is a good one. The problem for me, though, is that the dependent field is going blank in previous records. I would expect the field to blank in the current record, but all records are going blank. The problem does not occur in the...

The query must have the related field from the MANY side of the relationship and all the other fields from the ONE side, except the related field.

Rich: Thanks! I did check and the best answer seems to be to take the combo off the continuous form, which I cannot do in my situation. Thanks.

I have set up a set of cascading combo boxes for "Service Department" and "Service Provided." When you choose the Department, the Provided field dropdown shows only those entries appropriate to that department. I put a Service Activity subform (continuous form) in my client data form for entry...

David, Pat, Doc: Thanks SO much for the input. ALL OF YOU have been extremely helpful. I believe the 'character limit' theory has weight, since it didn't matter which two of my 23 lines I cut to make the union report run. It must be somewhere around 3000 characters. I like the idea of...

David: THANKS! I will try that!!! Actually, I have a second follow-up question: I have gotten an error message "Not a valid alias name" when I run the report based on the Union Query. Now, there are 23 fields separate queries and fields that are referenced by the Union Query. If I cut any...

Doc_Man: Well, it is 8:10am here, and I have worked on following your instructions since very early this morning. All I can say it "THANKS!" The report looks great and I know all will be VERY happy! I certainly am!! I do have one follow-up question: Some of the fields I am reporting on are...

Doc_Man: ULP! Thanks so much.... and, yes, that is what I am looking for. I will give it a try this weekend and report back. yowee...

I have a table of client info that has several fields of demographic information. Related tables have transation information. Each demographic field and transaction type field is limited to a list of entries, but some lists are quite long (25-50 entries). I would like to develop a query that...

Is there a way to display ONLY a custom toolbar? I would like to create a toolbar of just sort and filter functions and only have that display. Thanks!!

madhouse: These are independent companies in different locations, located all in the same city and surrounding suburbs.