Search results

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

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

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

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

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 have a date that is calculated from another date from the frequency. Thats value is not stored its calculated everytime. Now i need to run a query to find the events that fall in a range that would be covered in the calculated date. should i store that date, if so how do u store the...

how do i run a query on a date range that is a calculated date that is not stored but calculated in the form. i have a field that calcs the next scheduled date and want a to run a query that shows the calculated dates that fall in that range. thanks Jason

can anyone explain to me how to use this? i have a date and a frequency and i want to calculate the next event. I am refering to the example on mvps. Where do i put this code and howcan i store it so that i can use a query to find upcoming events. thanks i really need help on this one quick Jason

i have a table that holds all the customer info to make a work order. there are quite a few subforms that are datasheet associated to that particular record. when i make a work order, i want to save it some where else so that i can go back and look at the work orders like year later. how...

i have a customer database and there are two types of sales leads. either its a new lead, or an exsisting customer with a new lead for an additional service. i have a main table that hold the basic info for both types. but, when its an exsisting customer, the info is in a different table that...

i have a last service date, and i want to use the frequency of the service to calculate the next service date and save it in a new field. the frequencys are in days, like 7,14,30,60,90,180,etc. And i ideally i would like to run a report that shows me what things are due within 1 week , 2...

i have a list of phone numbers and there is a check box to say if its inactive. i would like to have it so that is always moves the inactive ones to the bottom(desending). any ideas? thanks jason

anyone have an example of how to layout the tables for a zip code autofill look up? i am trying to get this to work and in the ones i found in the search, they werent straight forward enough. If anyone has a method or example, that would be much appreciated. thanks jason

is setting up a dynamic combo box exactly the same for a datasheet view to? if some one could help me do dynamic combo boxes in the datasheets, that would keep me from pulling my hair out. Essentially i searched for this topic but didnt see anything about datasheet involved. or example if i...

how to i fix it so it shows the second column which is tha actual name not the ID number. here is what it looks like i dunno how to explain this correctly. thanks jason

i am trying to manage appts and i wanted to know how to see if there is a date and time conflict. I would be using roughly 6 crews and would have to account for travel time some how. any ideas? thanks jason

how can i use that default access calendar to open a report of the schedule of that day? is that even possible with that basic calendar? thanks jason