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...
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 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...
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?
I am trying to run a simple query of two rather large linked tables and when I run the query I get an invalid argument. I thought about importing the tables into a blank database and running them that way as opposed to being linked and got an "Invalid Argument" while trying to import.
HELP~!!!!!!
I'm trying to open one of my customer forms and I get the message "Too Many Fields Defined". HELP. Do I have too many on the form or too many in the table????
I have a control button that will run a query behind the scenes when a user clicks on it. What I would also like to happen is for the main form to refresh this data as well. Any idea what code to use???
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.