KayCee
Last Activity: Dec 12 '06, 03:12 PM
Joined: Nov 13 '06
Location: Sartell, Minnesota, USA
-
I tryed the SQL with out DISTINCT and I still get a record for each client equal to the number of services. In the design on the query I still have the Client # field from the Services and the Client List tables linked. If I remove the link I get a record for every Client in the Client List. I only want one record for each client that has a service (s). Any other suggestions? -
Thanks Mary - I have changed the Client # to pull from the Client List rather than the Services table and added DISTINCT to the SQL. It worked, however I am now unable to add additional records in my form. Do you know what will fix that?Leave a comment:
-
Sorry to scare you with that last SQL and Thank You again for the help on this. I sure am learning a lot!!!! I have been looking at subforms as you suggested and I think that a subform in a datasheet view will be very helpful here.
Here is the glich I have run into. I have created a query "Clients with services" as the staring point for the main form. I would like it to return just one record for each client # that...Leave a comment:
-
Thank you NeoPa and Thank you Mary - I have made some adjustments based on the infrmation you privided. This is what my SQL looks like now:
SELECT [SERVICES].[Client #], [CLIENT LIST].[Client Name], [CLIENT LIST].[Type], [CLIENT LIST].[Partner], [SERVICES].[Service], [SERVICES].[Promise Date], [Due Dates].[Due Date], [SERVICES].[OUT], [SERVICES].[Ext DONE], [SERVICES].[Ext Date], [SERVICES].[e file], [SERVICES].[Notes], SERVICES_1.Serv ice,...Leave a comment:
-
Just want you to know I will be on holiday until Monday next week. I look forward to getting back to this then. Have a great weekend.Leave a comment:
-
Thank you NeoPa for looking at this with me. Sorry I do not know what RDBMS stands for. What is the best way to set this up - I don't need any tears.
I tryed the LEFT JOIN, but it populates my query with all of the Clients and thier information from the 'Client List' Table.Leave a comment:
-
KayCee here again -
I have never used the SQL, but I wanted to add the SQL from the query if that helps. This is for just 4 services not all 12.
SELECT SERVICES.[Client #], [CLIENT LIST].[Client Name], [CLIENT LIST].Type, [CLIENT LIST].Partner, SERVICES.[Service 1], SERVICES.[Promise Date 1], [Due Dates].[Due Date 1], SERVICES.[OUT 1], SERVICES.[Ext DONE 1], SERVICES.[Ext Date 1], SERVICES.[e file 1], SERVICES.[Notes...Leave a comment:
-
Want query not to require data in fields.
I am using Access 2000
I have three tables I am using to create a query that will be used for a data entry form. Table one - Client List, Table two - Services, Table three - Due Dates.
I want to create the form with room for up to 12 services to be entered on the same form, so I created the Services table with fields for 12 services including fields for other information that would go along with each of the services... -
I got it - I got it!!! I just double click on the line and it moves me to the other form.
Thank You! Thank You! Thank You! for all your time and your help.Leave a comment:
-
O.K. I have the code set up in the properties of the Table formated Form, now what? How do I run it? If I am in that form and want to go to the same record in the other form what do to need to push?Leave a comment:
-
Good catch, however I was using the expression builder and it had pulled the correct field name. I still just get the form to open to the first record.Leave a comment:
-
That expression does the same as the last and I apologize - it does not go to the correct record when a client # is entered. It goes to the first record in the forms.Leave a comment:
-
Well almost. This expression gives a pop up that asks for the client number, and once entered goes to the right record, but I would like it to get that information based on the record being viewed. Any other thoughts?Leave a comment:
-
Sorry - I am not understanding your answer.
I am looking for the expression I would type into the macro design for the OpenForm Where Condition.
If you can explain where I type the code you have provided - I will give it a try.
I am really new at this - hope it my ignorance is not to annoying.Leave a comment:
-
Sorry I will try to be more clear. I have a table "CLIENT LIST" and a form "CLENT LIST FORM". The form has all of the information from the table, but it is layed out so that all of the information is viewable on one screen.
I have been asked to make it possable to move from a record in the table to the same record in the form with the push of a button.
If I have it right - it is not possible...Leave a comment:
-
KayCee started a topic {SOLVED} Macros; Where Condition expression to move from form to form based on pkin Access{SOLVED} Macros; Where Condition expression to move from form to form based on pk
Hello All - I'm new to the community.
I have been asked to move the used of a database I created from a record in a table to the corresponding record of a form. After much research and trial & error - I have come the conclution that this is not possable (please let me know if I wrong.) So to achieve what has been requested I am planning to create a form that looks just like to table the user currently looks at and some how create...
No activity results to display
Leave a comment: