Recent content by keiserc

Thank you Thank you. I finally got it working, but here's the next step (or catch). My combobox is multicolumn, - I have model.column(1) and model.column(2) displaying on the form. While it is very exciting to have the combo box - add a new model to the table directly, (I'm sure I'll use this...

Thank you Hfnet for your help, unfortunately my lack of traning is shining brightly. I have asked for, received, and copied VB before - with the help of all you great folks on Tek-tips. But this time, I'm afraid I do not have a clue what you mean with your response "check your references...

sorry, also Model.Undo is coming up error???

thank you, but I'm coming up with an error on this line - CurrentDb.Execute "Insert Into ModelTable (Model) Values (" ' & NewData & "')" something missing perhaps?

my main form "datasheets" has combo box "model" - based on table "modeltable" second form (for entry of new model to "modeltable" = "ADDmodelform" I need to allow the user to add a new model to the list (combobox). I tried faq702-4283 and can't get it to work. I set up a commond button to...

I have a simple database, with one main table, containing data for three years. I managed to break the table up so that there are now 3 tables. Problem is HOW do I get querries/reports to work now? You can enter a query, design view, right click the underlying table and change alias to the...

I'm printing a simple label [Lname] & "," & " " & [Fname] which needs to be LEFT justified. then I need to follow it - on the same line with two additional fields - which need to be RIGHT justified,to the end of the label. space between the two sets of fields will vary on length of name. two...

I don't know the proper name for it - but I have a field which automatically displays related data in a field. =[field].column(2) it works just fine. only I need the data (only one digit) to actually be saved in the table. presently it 'looks up-from the lookup table' and 'displays'...

I have a basic param query/form which displays a certain record (or recordset). How do I create a command button to requery a new record (or recordset). I don't want the user to have to close the form & start over to check a different record. I'm sure this is a basic thing. But I don't know...

thank you hneal98. I knew it was something STUPID... and I spent 2 HOURS trying different things.....well, at least I learned a LOT OF OPTIONS that WOULD HAVE worked if I had taken care of the STUPID error in the beginning.... I have learned so much from you folks at tek-tips, Access is not...

I have a form - which pulls data from a table by different criteria. Works fine. But once I get the record I want in the form - I can't get it to print. It doesn't show in print preview either. I tried several posts - all dealing with setting up a report, then having a cmd button on the form...

I have a command button that runs a query that runs a report. I have set up the query as a param query - [enter job#] and it will run the report on 1 job#. How do you set it up so you can enter -in a pop up TEXT box - more than 1 job#? All I find help on is selecting from a list box... I've...

Have a form with subform. have command button which runs macro output to excel. HOW do I output the data on the subform at the same time to the same spreadsheet????

basic. three tables. contract & equipment & notes. all linked by contractID on contract table. Form based on contract with two subforms. equipment & notes. As long as I only use 1 subform - works great. when I add the second I get the message, "cant add or chage record because related...

I have a detailed access form. Client info & order detail stuff. I need to have salesmen in the field be able to e-mail me data which can then be imported into access - which will handle the printing & record keeping. What is the best vehicle for the salesmen to enter & email their data from...