Search results

Thank you for the post...I will try and decipher through this.

Thank you so much!

Is there a way to display more than 1 record at a time if I format it to look like a report instead of the Datasheet? When I created that form to look like my report and I have 3 records, I actually have to click next record to see the other records. Is there a way around that? Thank you!

How do you insert a subreport into my form? It seems that when I try to insert a subreport, it only allows me to pick from existing forms, tables, or queries and that’s not what I want. I actually want a subreport so it displayed in a report format. This report already exists. Thanks.

Could you tell me how to do that?

I’m checking to see if a value in one form for a combobox is the same is a value in another forms combobox. What I did is I used the Forms!frmForm2!combo1 = Forms!frmForm1!combo1 When I use this in my Form1, it’s saying that it can’t find my Form2. When I open my Form2, then it works fine...

I need some help creating some new tables in my existing staff database. Each employee will have: 1. Start Date 2. End Date 3. Activity for that period What I need is to be able to track where each person is throughout the year. I’m thinking what I need is a Usage table and a Need table. When a...

One of the fields that I have in my table is a Combo box Value list field called Category. In my query that I base my report on I said Eval([Forms]![frmLessonsReportMenu]![Category]) This is getting an error that something is wrong. Can you Eval on a value list? I never have a problem...

this doesn't work with the search panel, I have already tried it.

I have a form with 4 combo boxes. 2 of them are cascading. When and if I want to navigate through all records on that form, I have to requery combo6 and combo12. I also have a search button, so you don’t have to click next record to look through all the records, because with time there will be...

I have 2 cascading combo boxes on a form. One works good, and the other one doesn’t. When I try and pick from the list (which is correctly narrowed down) I can’t select a record out of it. On the bottom it says: Control can’t be edited, it is bound to Autonumber field ProjecID. 2 combo boxes are...

Thank you for all your help!

That Count(*) worked well, but how do I sum that one value for all records? Something like Sum([Satisfied])

Is there a way to count how many records you have in a form? I have one filed on a form – “How satisfied were you” - field “Satisfied” and a client can enter from 1- 7. What I need is to add this “Satisfied” field up and then divide it by the number of projects to get an average. Is this...

I will try and look it up to understand it a little better. Thanks.

Thank you all for your assistance and explanations. :p

I didn't before. Now that I treid it, it worked well. What does this nz function do? I'm assuming it's "not zero". Where can I learn more about functions like this? I didn't even know that this function existed.

I’ve created this total field in my query to add up 3 amounts. I’m not sure what I’m doing wrong, but when I add values into added fields, Total field doesn’t change value. Total: ([Installment1Amnt])+([Installment2Amnt])+([Installment3Amnt]) Actually, it doesn't work if one of the amounts =...

Is there a way to get rid of the “Design View” button on only 1 form? I figured out how to get rid of the “Design View” for the whole database, but I just need it to be gone off 1 form, not the whole database. Thanks.

What would be the best way to do this or if this is doable at all. I have ProjectsDatabase.mdb and there is a form frmDetailedProjectInfo. Then in one of our other departments they have a database that has Projects as well, except for this database concentrates on the Programmer side of a...