Search results

Paul, They both worked like a charm. I did go with the form option you mentioned. I really want to thank you for dealing with all my newbie questions and helping me with this. Thanks to the different people on this forum including you I have learned a lot about Access and I thank you for that...

THANK YOU THANK YOU THANK YOU!!!!! I found one glitch though: If a contractor charges $25.00 for one find but $50.00 for another find, it doesn't group them together. Is there anyway that I can fix this? That is what I wanted but can I ask just one more question. Is there a way that I can...

That code isn't working for me. I open my query in design view and in the column named Total I right click on the criteria and click build then I copy and paste your code and it is coming up with the error "The syntax in the subquery in this expression is incorrect. Check the subquery's...

I have redone the database a little bit so that you can hopefully see what I want to do. If you look at the table test table, it tells you what I am looking for and how I want it to look. I will give you a little bit more input as to what my client wants. My client is a PI, he wants to keep...

Okay, I got the IIF statment to work: Here is the code I used: Total: IIf([Status Code]="FIND",1*[Service Price]) Now I have two different issues: 1. How do I make it so that blank fields are not showing up As you can see in my Order Details query? 2. How do I make it so that the totals...

For some reason my help in Access isn't working for the group by option I tried re-installing it but it still isn't working so I need some more input. 1. How do I do the group by option? Do I just right click right click on the sort option in the query and click totals for that field or is...

I am making a database for a somebody who sends some of his work to subcontractors. He needs to be able to pull a monthly report on the work that his subcontractors have done along with the amount of money owed to them and I don't know how to do this. I know I should make a query but how do I...

Okay, I agree that their is no need for a second order table. I will delete that one. I got this database from a client and he had already started working on it, he just had the tables done and realized it was too much for him to do so he handed it off to me. How do I separate inquiries and...

I got the autofill figured out but I ran into a couple of issues. My client number is my primary key so there is not allowed to be duplicates so here are this issues: 1. I can't enter any new information into the field. Such as a new client. I can put in a client number but it won't let me...

Please forgive my ignorrance as I am very new to the advanced access. I still am not following so I have attached a copy of my database. I'm hoping you can take a look at it and give me some additional insight on it especially with having it right in front of you. The names are all fictitious...

I think we are mis understanding each other as well. I have a form here are the fields in the form: Client number client Name client Address client City client State Etc I want to be able to enter or start entering a client number on the form and it automatically fills in the client address...

I have tried that and it still doesn't seem to be working. This is what I do Open Form In Design View Change Client Number to Combo Box Row Source Type is Table/Query Click on RowSource click the three dots Opens SQL Statement:Query Builder Select Table Clients Then In Field: client Number...

I have been searching this site and I have found numerous postings that people are having the same problem as I am but I still can't seem to grasp it so I am posting myself. I have a form that has 12 fields plus a subform. The fields are Client Number, Client Name, Client Address etc. The...

never mind I did it okay

Okay, I understand the Queries thing but is there a way to make it so you can just enter a date without messing with the code? Tracy

Okay, I looked at the link you sent me about my first question I will have to take a look at the code and see if I can figure it out. As for my second and third question: I did the open report macro and it worked fine I have to figure out the click event thing though. This is what I need, my...

Hi everyone, I am a newbie to the more advanced stuff in creating a database in Access so I would really like some input. So I have a few questions. Question 1: I would like to create a macro or some code so that you can import data from spreadsheets with different file names with a click of a...

Never mind, I got it figured out. I needed to delete the column in the spreadsheet labeled internal Id and it worked great. Tracy

I have a database that a client of mine has started to create. He wants to be able to import data from an excel spreadsheet into a table in Access. I created a macro that works fine but now I am having an issue with importing additional data. His excel sheets consist of Agency ID numbers, first...

I have a database that a client of mine has started to create. He wants to be able to import data from an excel spreadsheet into a table in Access. I created a macro that works fine but now I am having an issue with importing additional data. His excel sheets consist of Agency ID numbers, first...