Search results

Someone gave me a tip-- open data base holding shift key down, then save as and prev version.. worked for me. the graphic on menu didnt come up, got an error msg, but i can change that. all the other buttons work fine.

HI again. yes on SaveAs, / no on holding shift key. let me try that

I created a data base in access 2007, but would like to convert it to 2003. i wanted to avoid installing 2007 on allmachines, but i could do that. the main reason i need 2003 is my web server-- they dont support 2007. I tried to file / save as/ 2002-2003 vsn, but get an error saying its opened...

I am creating a new data base in access 2007, just getting finished. I want to maybe coordinate that and use for antoehr company we have , but would need to convert it to access 2003 format. The program says you can do this, but when i try i get an error that its opened by another user [user...

ok how do we go offline. i have msn ims/ and aol ims. and think yahoo thru my msn ims

no, to be really honest, the me. commands i copy and dont understand exactly what they stand for. i would assume something about matching the cbomake ID /column 0 to the make we selected from cbomake? By the way sorry if i sound like an idiot.. i really appreciate your help in trying to...

to pull up the model that corresponds to that make ID.?

I am trying to do that. i see the MySQL = Insert Into TblMakeModel(Model,MakeID) "& _ How should i adapt that for the submodel though? since it is only relying on info from 1 table not 2.. that is where i think i am wrong.. and the next line beginnin with "Values.... where it gets to...

Private Sub cboSubmodel_NotInList(NewData As String, Response As Integer) Response = MsgBox("[" & NewData & "] is not recognized in this database." & vbCrLf & vbCrLf & "Would you like to add it?", vbQuestion + vbYesNo, "Unrecognized Data") If Response = vbYes Then '...

ok changed subform to auto number, do you think i should try the same code i sent you above on notonlist? or did i mess that up when adapting to this field?

ok i tried it get a run time error 3134

this is what you had written on the cbomodel not on list.: Private Sub cbomodel_NotInList(NewData As String, Response As Integer) Response = MsgBox("[" & NewData & "] is not recognized in this database." & vbCrLf & vbCrLf & "Would you like to add it?", vbQuestion + vbYesNo, "Unrecognized...

kind of .. my problem is the cbo model has to do with make and model id's and the submodel is simpler and only submodel/submodel id to deal with.. so trying to adapt it, but not sure which part to leave out

ok i can change that submodel field back to autonumber. which code should i copy to do that with ? which event? will it work same as the make model field if i copy and paste. gotta admit getting confused now :)....

wow that is perfect on make model! how can i do the same thing to the submodel field. tried looking in the properties,, but cant find where the CLOSE command is? How can i make it so when you add a submodel it adds it but then automatically closes the form and shows it back on frmvehicles

I didnt do an autonumber because i have a macro that will add each new transaction as one increased id #.. for example if you were to delete a number, next addition would be last number still in tabel +1, doesnt waste numbers taht may not be kept or used. Macro wont work with an auto number.

hi mr. rural guy! ok i found your post on the other thread. YES! thanks, that fixes the population when opening the agent field and teh dealer field.. THANK YOU! Sorry i missed it! ok, the only prob is that it wont work with my submodel field...still playing with that. Also, since the model...

Hi rural guy. 07/15 at 11:05 am you commented to me about me not using a code you gave me? i didnt see that exact one.. what was it named and what thread was it on? maybe that is my problem and i missed it!!!

ok, i have a dumb question, or am in some need of some more help. seems like stuff i wanted to do i have had to do several diff ways. on my FRMVEHICLES when i select a submodel, is there a way to havea it already populated in the submodelform? same wiht dealer, once i enter a dealer, not on list...

never mind... on the form current ()-- works great.. thanks so much!!!!!!