Search results for query: *

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

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

I have a calculated field already rounded to the nearest whole dollar in excel. now want to round it another level IF less than $100 - no action IF $101-250 round up to nearest 4 or 9 IF over $250 round up to the nearest 9 how to do this with formulas, no vb. I'm a simple user. thank you.