Search results

Well it definitely doesn't seem to be size related. I did some more playing around and sort of made some progress. In the OnLoad of the main form I added: Me.Communication.Form.Requery Me.Community.Form.Requery Me.Functional.Form.Requery etc. Naming each of my subforms, there are nine in all...

I would think if it were a size issue it still wouldn't display when I go back to that record. But it's not, I have the scroll bars displayed and that all seems to be fine. And when I open the same form to enter a new record (add) it opens just fine, I can see all the subforms immediately...

I have a form with some tabbed subforms. Master/Child links are set, everything is bound. When I open the form to display records (based on search criteria on the switchboard form), let's say it returns 6 records for someone, they are sorted by date and so the newest would display first. But...

Update: It actually does work for all of the Cases where it is just running a DoCmd.TransferSpreadsheet with a query. However for the Case that I had to code to use the recordsets, Adaptive Behavior Assessment, it does not work. The same would be true also in the case of "All" for only that...

I have a set of queries that need to be exported to an existing Excel file to the appropriate worksheets and within a date range that the user enters on the form. That part all seems to work fine, the correct data goes to the correct sheets, etc. The queries themselves, if opened while the form...

The parameters are just coming from two fields on a form, user enters start date and end date. That was the problem, VBA couldn't determine what the parameters were. Below is my code as it is now, I think I've got the problem sorted out. After much head banging and many many web searches! If you...

New Problem! The above code worked perfectly until now. I added the WHERE criteria to my 2 queries. The criteria is based on a date a user enters into a form. Both queries work perfectly from within access. But when I run the VBA it is not getting the Parameters. Yes, the Form is open when it...

I have a solution, finally, should anyone else need something similar. It may not be the most elegant or best solution but it does work! I had to make 3 queries to get the fields from all 11 tables. Including the "Main" table in each of the 3 queries so that the records are related by the ID...

Set your form property to Data Entry: Yes. That will make a new record each time you open it.

Thank you. I think I may be getting "close" to a solution.....famous last words! I've gotten the data that I need down to 2 queries, about half the tables in each one and of course the main Patient table in both to match the ID numbers with. Both queries work as they should, show everyone's...

Thanks for your response Esuardo. An array might work. But quite honestly my array experience is almost nill. I understand what they are and how they work, but creating and utilizing them is a whole different animal. Another issue that just popped into my head this morning though is if I...

A quick solution would be to have a query create a TempTable of all of your Leaders with a simple "If name already exists don't append" thrown in. This way your TempTable would only have each name once and send your emails based off of that. Then just clear the table at the end of your code...

I am using Access and Excel 2007. Here is the general scenario, I know I have used a complicated method, but it seemed much cleaner at the time and I am open to suggestions. This Db is for a mental health practice to track and store the paper questionnaires that the patients fill out. The data...

I did consider it, and tested it. My problem is, I have 3 different reports that the data is coming from weekly (3 tables), and there are different dates for all of the data, so i end up with a REALLY long table, where there is a lot of 0's in every row (if the data came from the Call Data...

I missed a lot in here over the course of the evening! Thank you, thank you, for everyone's help. The query criteria does not limit to only those that have data in any or all of the tables. I wasn't really sure on how to word that in the criteria, but that by itself may take care of the...

Thank you for the tip. I tried changing them to both left and right, just to test, and neither way returns any result. Here is the SQL as it is now: SELECT AgentListingtbl.Agent, AgentListingtbl.Supervisor, Avg(AgentCallDatatbl.ACW) AS AvgOfACW, Avg(AgentCallDatatbl.PercentHeld) AS...

I have a query that is using my 3 data containing tables. It is selecting the stats that i need from each table using the criteria that the date in the table is last month. they are related by name. (To get last months average of each stat) For whatever reason, not every person has a stat in...

We're using 2003 in both Access and Outlook. I have no idea what the Exchange Server is, but yes, we use one. We do have an internal Web Server, that's a possibility that I hadn't thought of. The important thing is that the Agent has to manually Accept or Reject the information. It really...

I'm guessing that this is possible, but it's not something I've seen implemented, so let me know if I'm way off base! I have a Db that is used to track Agent Stats. Once a week, Supervisors have a coaching session with each of their agents. Prior to the coaching, the Sup opens a Form, reviews...

I have to use both tables because there is a field in the second table that I need the Min of. To show the oldest age of the contracts in each group.