Recent content by BIGGY

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?

Ok that makes sense...this TravelerID value, that could be the autonumber since the company is not assigning any numbers of it's own?

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...

Perfect, got it thanks!

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...

Found the code...pretty basic. Me.OrderBy = "[Name]" Me.OrderByOn = True

Know any good links off the top of your head for vba code that'll do it? No doubt it's already been written for a function like this.

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...

No, not a stupid question at all. Maybe the answer is though :) Well, I know pretty much nothing about Access or VB. Everything I know is picked up on my own, so I teach myself as I go. I couldn't even tell ya what a bound form is without looking it up.

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...

Ok, this would be new to me...how would I use the dlookup? Let's say I'm starting off with a blank report...

I just tried simply using the toolbox to create a 'text box', should that work? From there I simply select the control source table and field that I need such as... =tbl1!Field1 However when I try to view the report it only shows #NAME?

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...