I'm having a hard time getting an answer to this because I don't really know how to explain. I need a combo box that will have two tables with one field from each in the same column ( i can do a union query ok), the fields are (subContractors & primeContractors). I need this combo synchronized...
I want to synchronize three combo boxes and the information needs to come from two different tables. I made a union sql from the tables and this is where I am stranded, anyone have any ideas? The two tables need to be separated other than for this purpose, I have access 2000.
Combo box titles:
1001 Demolition
1001 1.1 Concrete demolition
1001 1.2 Wood Demolition
I have a combo box which will show [1001 Demolition only], if I Pick 1001 demolition it will update a list boxt to this:
1.1 Concrete demolition
1.2 Wood Demolition
This in turn is...
I have a text box that can take 3 lines of information, I have a list box that when I click on a row the info is inserted into the text box, then I click on another in the list box and it is inserted too. My problem is that when I insert some info to the text box, the info can be broken in half...
I have this code in the current event of the main form to set focus to a text box of a subform.
Forms("FrmSubmittalLog").SetFocus
Forms("FrmSubmittalLog").SubmittalIDNo.SetFocus
I get an error saying it can not find the FrmSubmittalLog, and I can't figure it out, so some...
I have a continuous form (form view) and new records are inserted after the last record. I would like a blank record line inserted between two records, then I would be close so I could copy some of the related information to fill out the new record and (2) it would then be next to the record I...
I'm trying to do something like this in a continuous form and report:
02900-1 HEADING
1.2 Some info
1.2 More info
1.3 More info
03440-2 HEADING
1.2 More info
1.3 More info
Every line will...
I would like a text box in form view to expand when it has focus (show 55 characters)and then shrink back (to about 20 characters) when it looses focus. I found the code to make it zoom, but I need to limit the characters to 55 and the zoom box lets you add more letters and then truncates it...
I was moving my tool box around and lost it. It is in computer cyber-space. It is hiding some where and how do I find it. The button says it is here, it is just being hard to find.
I have my Name and address table and this goes into my different forms, so it is foreign, but is related. I am trying to make the table into address form with name row, address row and city state and zip concatenation into the report. Every example I find uses individual text boxes for this...
All the ways I have seen so far to make incremental numbers can eventually be different than the navigation button number on the bottom of the form. I am afraid this will confuse the end user. This number always seems to be accurate, is there any way to use this number in our form, then they...
I have two tables that are related, and I am trying to make a form with a combination of the two. I can change the information of both tables on the form of existing records all I want, but when I scroll to the last record, and go one more to make a blank form, it will only let me fill in new...
Got through realationships, got my tables normalized, thought forms would be a snap. Wrong!! I am probably missing something, but as I see it, I can only have one table on a form. I can have sub-forms, but they can only be viewed. I tried a query, but when I made a form of it I ended up with...
I found this formula: =DMax("InvoiceID","Invoice")+1, where Invoice is my table and invoice ID my number field. It works good, I just can't find out how it works. Whatis DMax and why "INvoiceID","Invoice" and the quotation marks. Also, can you have it...
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.