Recent content by Wesley

The advice will work - you'll have to change a couple of references in a query so that the form the comboboxes are included on can be referenced. any advice on how to do that? in my initial forays into figuring out how to do this, i wanted to use my dateAdd formula in my query, but, i am not...

hmm ok my form uses two tables to calculate the next date equipment is due for preventative maintenance: table 1 contains: Equipment name, drawing number, date maintenance last performed and the type of maintenance. table 2 contains information about what the interval should be. my form has a...

kk please disregard my edit till i have a chance to look at this. I didn't know you could simply calculate things in a query.

question to your response i made a seperate text box that now can get the "DateNextDue" from the form field that calculates it, but, how does that information now get passed to my table? -OR- is it not necessary to port that data to my main table. Your response seemed to indicate that it was...

ahh thank you very much, that sounds exactly like what i was looking for. regards,

is there a way to create an access database, and then distribute it in some form to people who do not have microsoft access? i realize that sounds kinda dumb, but i thought i'd ask in hopes that there was some way around having to purchase a license solely so our secretary could keep track of...

Hi All, I'm continue to work on my little preventative maintenance project. What i'm looking for is some advice on how to do a couple of different things: 1st - I have a date / time field that is calculated using the dateadd function based on a date / time that maintenance was last performed...

k, got that figured out now as well

k couple more things is there a way to pre fill a field on my subform? Basically, everytime i hit the "Corrective Maintainance" command button on my main form (to open this subform), would it be possible to "pre fill" the newly opened subform with the Equipment Name?

k one more thing if i have the subform on the same "page" that my form is on, then all my entries are kept sequentially if i use a command button on the same "page" that my form is on to open the precreated subform, then all the data is kept, however, corrective maintenance entered for machine...

k one more thing if i have the subform on the same "page" that my form is on, then all my entries are kept sequentially if i use a command button on the same "page" that my form is on to open the precreated subform, then all the data is kept, however, corrective maintenance entered for machine...

ok i have put in a subform into my main form. The keeping track of data part seems to be working correctly - meaning that, i can enter multiple instances of corrective maintenance for each piece of equipment i have on my main form. Question: This "subform" that i have dutifully called...

trying that now... i'd be further along, but i keep getting interrupting every 37 seconds by suppliers, contractors, or my wife.

it really doesn't matter too much which i use, be it form or subform.. the thing i'm still having trouble with is properly syncing up corrective maintenance records with their respective piece of equipment. i can get the form to open with the fields i want but if i go to a record containing a...

thanks much slowly but surely its coming together. Honestly, i realize i'm a complete noob, but, the only way i can learn is to just plunk away, and ask questions. I do sincerely appreciate all of your guy's help.