Search results

I have a form (frmTraveler) in which a user is given a selection of levels for a type of trip from a drop down box (TripLevel). Basically, if a user picks level A, then I would like a value to be written to the corresponding record in another table (tblHotel). The PK is an autonumber...

On a form, what is the best way to hide a label or text box? I'm guessing that I can do a checkbox which would work for me and just write a macro to hide on a false value?

I am developing a database which will track some of my companies clients bonus trips. Basically everyone is going to the same place but folks are of different levels. Level A is a 14 day trip with X number of activities, Level B is a 10 day trip with Y number of activities and so on. The...

If a form is created in design view without one of the pre-built designs. Is there a way to change that background to one of the basic ones included in Access when using the wizard?

I have a report with several subreports that I would like to have the exact same layout for 5 other reports. Only difference would be the main table that the report is linked to (which I did using a wizard) and the header. Is there a way for me to take my original report...copy it, and link...

In Access it's very easy to sort a Tabular form by a column. However I don't believe that there's a sort button in Runtime. The MDB (soon to be MDE) is pretty basic. One table, and one form linking to that table...pretty basic. Any suggestions on sorting columns in the runtime version? My...

I have a single record table/multi field table which I'm trying to load into text boxes for the user to edit. Any way to get this code to work? I know that it works the other way around, but wasn't sure how to load fields into a form. Private Sub Form_Load() Dim MyDB As DAO.Database Dim...

Pretty basic here I hope. 4 different tables, each has just one record with several different fields. In 4 different places on the report I want to display most of the fields from most of the tables in a specific format, such as FIELD1 and FIELD2 from tbl1 being right next to each other...

I have one table (tblComplete) with a listing of 30-50 company names and associated information... "tblComplete" has fields: AutoNumber, Company, Address, City, State, Zip, Phone On a form I created a combo box linked to AutoNumber and Company to drop down the list. Once the 'company' is...

I need to create a basic program that puts selected items into a letter. This letter would contain a scanned image for a header, then selected company names as the body, and finally a concluding line which is already entered into a table. If I want to do this without using Word mail merge, can...

I have a table which has 3 columns PCNAME PRODUCT, and SERIAL. For the PRODUCT I've narrowed them down to cpu's and monitors, along with their serial number. So basically a good portion of the work is done. However on the output the report of course lists most pc names twice since each one...

Very strange problem and I will try to explain it as best as I can. We have a custom program that has now been converted to SQL and runs on the employees Access 2003. At one point in the program is a call to send email to the persons manager and this is where the program locks up. Here's some...

I have an .mdb which holds one table. This table is referenced by two other Access applications which link to it. In one of the programs there's a form that all of the needed values are pulled into from that linked table (user name, administrator flag, etc...). A query filters into this form...