Search results

I also had this problem, its fixed now for themost part, but sometimes, [expecially with my switchboard] after i open another form, the switchboard reopens FULL size, not smaller... any ideas how to fix this?

Ok fixed it.. one of the tables lost the autonumber, so added that back in and works fine!

This is the code for not on list.. for the cbomodel. I changed the source data for the form to my query, and can select records on the list, but not any that arent on the list. Private Sub cbomodel_NotInList(NewData As String, Response As Integer) Response = MsgBox("[" & NewData & "] is...

Here is the last working copy. to get the size small enough, i had to delete tblemployee data, tblequip data (not relevent for this problem, the equipment was working for the individual cars, and some of the records from both Tblmakemodel and tblsubmodel. I left some records... but at least you...

I have a 2007 Access DB, which i am developing and want to then import data from an existing db. i have a form [frmvehicles] that adds new cars, when a new Model [one not prev on list] is entered, the form will as you if you want to add it, then add it to the tblmakemodel, and go on to next...

I Have A Questions. I Have A Field That Is 17 Digits, [letters And Numbers] And Would Like To Show The Last 8 On My Report. I Tried To Adapt These, But Its Not Working.. Any Ideas?

I am trying to export a table to excel from access 2003 db [but using 2007]-- a lot of the fields are ck boxes on the form, or yes/no fields. WHen I export them, they become true false. this is a prob though when i try to import them into a new db, says wrong data type.....its a query in the...

I have an old data base, with 98k records, and am designing a new front end. I have had to add one field. now i have 98k of records that are missing this one field. if i import, it doesnt append to fill in that field, and i cant copy one column and paste to other like i thought i could. (think i...

I have an old data base, with 98k records, and am designing a new front end. I have had to add one field. now i have 98k of records that are missing this one field. if i import, it doesnt append to fill in that field, and i cant copy one column and paste to other like i thought i could. (think i...

i am not sure, you could test it and see, i havent run into that. I would assume a blank record, but not positive, and you wouldnt want blank records in there

msrookie, add "DoCmd.RunCommand acCmdSaveRecord " in front of code on your close command .. should force a save before closing. i added it to a Command button that opened a form, right before the code that opened form and it works great. see earlier post from ajetrumpet.

msrookie, what was your problem exactly? not sure i understand, other than you said similar issue.

It does, and thank you both so much for helping me clear some of these problems up!!!!

I got it.. just the one line! Great... it works! yeah!!!!!!!! Question.. someone mentioned about my data base needs to be compiled. Where do i find to do that?

Just the DoCmd.RunCommand acCmdSaveRecord part? or the whole thing starting from private sub - end sub

Aj, is there a way to put the "save" function into the same command button, so clicking on the enter equip command button will save the frmvehicles then open the other?

No, after i enter a vehicle in the frmvehicles, i click on teh enter /view equiptment command button to enter the corresponding equip, and when i try to close the equip form i get that error.

Thanks craig. when i try to add a new vehicle, and click on command to enter the equipment, everything is fine til i go to save it. then i get an error "You cannot add or change a reccord, because a related reccord is required in teh table 'tblvehicles'.

I "think" the problem is in my frmequip [vehicleid] field. i have the default value set to : [vehicleid]=[Forms]![frmvehicles]![vehicleid], so when i click the cmdbutton for add new equip, i should get the vehicle id to be the same as the form i am on, but its not working. should there be a...

on the frmvehiclesALL i got teh command button to open the right equip form by adding an embedded macro. / so its just adding the new equip to the table frmvehicles with the code that i am having trouble with. i would like to be able to add, and then go back and view as well. if that is possible--