Search results

resizing switchboard when opens i also have the switchboard opening at startup, on access 2007... and cannot find out how to resize.. did you ever figure out this problem? I have auto size off/ i have tried everything i can think of... thanks for any input.

Make sure your access options are to enable macros, and that its a trusted site location.

In my database, there is a form frmvehicles. i would like the zip code field to populate based on teh DealerNo i select [in other words, when i select a dealer/ that dealer is linked to my forms, and would like the dealer's zip code to automatically populate. i have been playing with this for a...

sorry here is a copy of data base.. hasd to delete old stuff so it would be ok sizewise to upload...

I am trying to update an older access (2002/2003) database to 2007. I have a Form [availableInventory2007] that i enter vehicle info into. I then want a button that will open a seperate screen [Equip2007] and allow me to ck boxes for the equipment for THAT particular vehicle. My form...

ok.. i had figured a way around it.. but this is much cleaner and easier. thanks so much.. the me.make I think is where i was stuck, and while i was ok with living with make id.. the make name is much cleaner and neater.! thanks so much... i really appreciate it!

I was trying to do this without a bunch of tables for every make. what i have is one table with all the makes. one with make and model. I finally got it to where i select the Make cbomake, then the models shown in cbomodel are only those models filertered from the makemodel table. I click on...

I have a database in Access 2007. ON my form [frmvehicles] i have a combo box field for cboMAKE, once selected will allow the user to use another combo box cboModel. if an item is not available on the cbomodel, i have a button [add model] that will allow a user to open a subform...

cascading combo box usin state and city thanks!! didnt catch that. got it handled... thanks for your help, i really appreciate it!

Making combo box fill in after new item is added I tried that, thx , but now when i do that my "cbomodel" reverts to wrong info. I am sending uploading a copy of my Access 2007 data base. on the FRMvehicles i have a command button Add model. I want to [if the model is not in the cbomodel...

I have a similar problem. I have a form with Vehicle makes, and Vehicle Models. The models are a drop down box. if its not on the list.. a subform opens to allow me to edit. that works great. .. BUT i would like to close that form [this is all access 2007 by the way], requery the model drop down...

Cascading combo box using state and city Ok, i changed the bound column on my cbostate to 1.. which is the stateid.. but still not coming up.. sorry it is v2007. I also fixed my tblcitystate.... there was no info in the copy i uploaded. any ideas? thanks!! i really appreciate the help! I...

Cascading combo box using state and city sorry, my upload didnt upload. ! thanks

Ok. i was on here and got some help with a cascading combo box [ vehicle makes and then teh corresponding models.] I copied the "format" to apply to states and their corresponding cities. It looks like i have it all typed down right, but for some reason [I am sure its something i am...

Thanks! This part works great.. I select a vehicle/or enter a vehicle. I select make, then model. if the model isnt listed in teh cbomodel box, i can select the cmd button ADD MODEL, and get the data sheet to add a new model corresponding to the make i entered. Question [and sorry i dont want...

I had a similar problem when I upgraded to Vista on an older machine. I couldnt open with my 2007 version. I had to call microsoft and they signed in and did a fix... on a machine built iwith vista its been find. they did a data fix of some kind on my server machine... took an hour on phone and...

I have a form that has information about a vehicle.[formvehicles] I also have a form and subform for a list of makes [form - frmmakes] and their corresponding models [subform- frmmakemodelsubform]. i am trying to but a button on my formvehicles that will pull up the subform, matching the Make...

works! thank you SOOO much.. u r great!

if i do that.. on the FORM Page properties.. i get Microsoft Access cant find the object 'ME',. did you mean the cbomake or cbomodel on current?

Ok, Problem. When I Enter The Car. I Select The "make" [lexus], And I See The 2 Diff Lexus Models Under Cbomodel. Then I Go To My Next Car.. I Can Enter A New Car.. But If I Go Back Then I See Only The Model Info On The Lexus. Not The New Car [for Example Buick Lacrosse] That I Entered. Any Ideas?