Recent content by NOVAmichelle

Can't believe i'm asking this... I have a master form. I have a control which the user clicks and it prompts them to enter a "Customer Number". When they enter the number and click ok it opens the Master form to that record and all corresponding data. The thing is this. Sometimes user error...

Thanks! Have a great weekend!

One of my teammates has a master form. On this form there is master data etc in the header, including an autonumber field. In the details section she has 5 tabs with various subforms on each. On one tab, for example, if you check a yes/no box, a subform will pop up so that information...

Is it possible, or what would be the best way, to have an option box with say, 12 choices, and the user can choose as many as they want? Not just one. Also, can I query off something like this?

I have a report and when I export to Excel, some of the headings of the columns say "Text43" for example, instead of the names of the fields. I have checked in the properties and all have "Captions" which correctly identify the field. Is there something i'm missing?

I know that sounds silly, but what does it stand for?

=[SumOf01/05 LPcom]/[SumOf01/05 Total]

thank you. do you have an example?????

I have a form which has 4 fields across... Column A has a number in it Column B has a number in it Column C has the Total of A & B Column D represents the percentage of the Total/Column A Problem is that when there's no value, meaning no total, then i get #Name in the percentage. How can I...

okay, the transaction # is the primary so... Trans #1 can have 01, 02 or 03 in any combination. It will not be null. I want to know which transaction #'s have only ONE instance of 01, 02 or 03. Hope this helps. It's Friday, I'm slammed and working on three different databases this...

I have a query that i need to group by transaction #, and then I have another field which identifies a code for the type of transaction. example: field 1 = Transaction # and field 2 = transaction type which can be either 01, 02 or 03. So, i want to group by trans # and ONLY see those instances...

I'm advanced enough to not have to ask this but for some reason i am stuck! On my switchboard is a control to open a master form. When a user clicks on this they are prompted to enter the customer # and the master form opens to that record. PERFECT. Only problem, my it opens behind my...

ok, so if I do that in the list box, how do i get my selections to copy into a memo field on the same form?

I have a communication form which is being used for customer distribution of various messages etc. There is an auto date field, a field for any comments, and then I have a memo field where my admin manually types which customers are going to receive this broadcast. IS THERE A WAY to have a...

I have a master form that has totals by month for various things. I want to create an unbound field on this form which will total some of the fields. Please help. Also, I just realized that my fields are text. Should I change them to number fields?