Search results

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.

is there a way, that when using a query if i have a field on my form / in a table called EquipmentName that when i push my command button, it will open a form, and preload things like Equipment Name, Drawing Number (Contained in same table as Equipment Name), Asset Number (Contained in same...

okies getting closer i set up a query to the breakdown table. Made a command button to open that form. i just need some help linking the records of corrective maintenance to the items on my main form. I'm probably not doing the query correctly. I have 3 tables. 1 is for periodicity that...

great great ok, the "open form" was a great step in the right direction. But, its not really getting me where i want to go. When i am on my main form, and i press the "new corrective maint" button, the form i created opens - great. However, this form shows me all the maintenace that would...

okay i've been plunking around and it seems as though you can use the command button to create a new form =CreateForm([InvtervalDemo],[CorrectiveMaintLog]) when i use this for the "on click" of my new command button, it successfully creates a blank form. However i get the following error...

I noticed that in the toolbox you can create a command button, that you can do things like increment or decrement records etc. What i am doing is working on a Preventative maintenance database. I have the Preventative Maintenance side of things working, but, i want to have a feature that will...