Search results

its shows all the records on separate pages... jason

restructure the report like how? i have a query that has all the info i need, all i need is to find a means to print a bunch of them on a page. jason

i have a small block of info that i need from a lot of records, is there anyway to put as many as i can on a page and save paper? I can fit about 4-5 per page and that would save a lot of time and paper. Thanks Jason

i have a small block of info that i need from a lot of records, is there anyway to put as many as i can on a page and save paper? I can fit about 4-5 per page and that would save a lot of time and paper. Thanks Jason

i wanna run a query for employee activity on a certain day. how do i make the query ask what day to use? btw i have it made already, it just shows all the dates, i just want one at a time. Thanks Jason

i checked that, it works with everything else except access.

there is one computer in the office that cant print correctly. when i print reports from it, the fields are all in the right place but the frames and text box lines are all compressed and crunched in the top left corner. any advice? Jason

oh regarding the first question Private Sub Jobtype_AfterUpdate() stDocName = Me.Jobtype.Column(1) stLinkCriteria = "[WOType] = '" & Me.Jobtype.Column(0) & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub WOType is where i want to store the formname in the other table...

ok great. it opens the correct for each as you instructed. but the value i put in for the "some key field " prompts me to input something. i know for sure now that i have no clue what that is for. also i was still unclear on one thing. when i open this new form, it makes a record in job...

quick question on that one, the column in the first line is 1 the second is 0, is there a reason? and what exactly do u mean "[SomeKeyField] ? is that were is stores the value? if not how do i store it in a table/query other then the one im currently using. i need it to store the form name in...

ok heres a senario i have been looking at. having a CB and using that to open a from that creates the record. Then having the form name stored in its table. we have all these records viewed in a list box. now is it feasible to be able to click on the row of the list box and have it open that...

ok i have this table with several subforms attached to it. i need to pass all this stuff to another table(s) so that it is history once it is processed. right now i have it so the info passed from main table is independant, but when i make changes to the subforms it effects the onces linked...

Hey, I work with Russell. First off thank you for the response. I had a few questions about that code section you sent. How does this method tackle list boxes, combo boxs, etc. The way we use it is that the work order goes out with all the info that is standard , then they crew writes in the...

can i default access to print selected record as a default anywhere in access? this is so people dont print 5million record by accident. jason

i wanna open a different work order form based on the service selected. but the value in the combo box is not what i need to choose is another column in that table it looks up from. how can can i change the open form command to plugin the name thats in the unshown colnm of a specific field...

no i mean that i have all the info, i want to print a summary report of this company to take on the site with me. but i dont need all the contacts for that company just one that i pick. i am trying to find out how to pick the contact. its setup so that there are infinate names with infinate...

im sorry i was very vague. i find a company thru a search etc and i am in the record for that company, and i want to print the info of the company i am on. right now i have a button that does this but i cant figure out how to include a specific contact which is a subform in the customer...

in my report i wanna prompt to choose a contact, based on the company chosen. it is viewed in a subform right now. how do i go about making that work? Jason

i got it figured out, but thanks tho. Jason

how would i use calculations in queries, i thought only reports and forms could do that. my dilema is that is that i need a query to list what events fall in a certain time frame, i know how to do it with a stored value(date manip etc) but i dont know how to run a date comparison on something...