Search results

thank you very much

actually, i did do a search with my username, i couldn't find any posts.. i asked this question late last year, and i think its scrolled off of the forums. i think my problem is lying on the linking of the two tables, i'm not sure i'm asking for the sources of information correctly. e.g. i...

What i have now are two tables one has the generic info (equipment name, date last maintenance done, etc.) the other is called PeriodTab and contains three fields 1st field is Periodicity, next is the operator designator for weeks, months, years, etc., next is a field i called "number" Formula...

/grins i am using the DateAdd function correctly. What my formula is currently doing, is going to the table that i have everything listed on (all the equipment stuff, etc. etc.) but, it seems to be just pulling whatever the code (be it, ww, or q, or m, or yyyy) in the row for whatever record i...

stupid me, but, what is the Me. supposed to be? The database name? The form name?

sorry, one other question. with a combo box, is there a way so that the empty white space below the last entry in the combo box does not just scroll endlessly? i.e. when i pull down a combo box from my form, i don't see any blank white space below the last entry?

Hiyas. I've asked this question before, and i remember getting an outstanding answer from the guru's of this board. Basically, i need the answer again however. Problem: i am setting up a database to track equipment (by asset number, description, etc.) and have fields that i can enter a date...

i dunno if they are broken, so much as they seem to want to work whenever they feel like it. /shrug /grins

is there a way of doing this without using the wizard?

Once you have initially created a form and you have selected a table (s) to get data from how would you link another table (say, to a combo box)?

hmm i tried to duplicate what you did... so that i could have the option of having more than one maintenance type per piece of equipment and i seem to be having some problems. how could i attach a zip'd file to this message so that perhaps somebody could explain what i screwed up and how to...

yes thank you!!!! thank you so much!

also for trying to tie values that would be used in an expression to fields in a combo box is there a good keyword to look up? (in access help)?

is this something where i would want to create a relationship that would tie the text of "Monthly" to a Character "M" and then to a Number? So that this effect would happen DateAdd ("character selected by selecting monthly, using relationships to tie it to an "M", "Digit selected (in this case...

okies somehow i must have been making a typo guess what i REALLY want to do is have a combo box with the following: biweekly monthly quarterly semiannually annually i would like perhaps to have those fields in my table with a number in them. BUT. here is the kicker... i would like to...

okies, now if the date i want to use as a starting point (i.e. DateAdd ("yyyy",1,"[field in table_01]") when i have tried this, i get a #name? response.

question: how do i take a date that i have stored in a table (inputted by a form), then add a period of time (e.g. 1 week, 12 months, 365 days etc.) to it and have that value pop back up on my original form (in a seperate field)?

Hi all... just wanted to say thank god this forum exists. I'm posting this question here in the general section, because it pertains to a form, a table etc. This is what i'm trying to do: I have a form that asks for when the last date that maintenance was performed on a piece of a machinery...