Recent content by gersheff

i sort of want the button to change colour once i select it and stay that way until the next button is selected

I have a switchboard set up for my database, and i want the buttons to change colour (or some other noticeable change) when selected. Right not all that occurs is that a small dotted square appears in the button. is this possible?

I have been able to change some properties using "if statements" (format, visible) but not others (inout mask, back colour). Is possible tp change all properties or just some. if it is possible, where cani get a list of the commmands VBA uses?

not really what i meant. i have to lists A and B. Any number of the items in B can be applied to A. But only once. deoes this make more sense?

how would i remove something from a list which has already been used in a previous record?

but then how would it know which 1 to save to the table?

Is there any way to set a date field in a form that has the format of dd-mmm-yy or mmm-yy depending if the date is an estimate or a real date ex) If estimate the user will input "Nov-04 ", and if a real date the user will input "12-Nov-04" i will have a combo box whill allow to identify if...

ok here is the new databse with proper names for most objects and the buttons are now controlled by VBA not macros. thank you.

can noone help me?

ok everyone attached is my problem database. there are a couple of issues. the most important one being that the SubstanceTrackingID is not being transfered from the Substance tracking table to the priority source tracking table, and consequently not being passed on to the Instrument/Tool...

is there anywhere i can post my database and someone can help me work through some of the issues. for me that would be a lot easier than trying to explain it.

yup the "record source " row has got something in it. I found that if i go to the next record it saves it also, so i created the macro to do that for now.

For some reason i am having trouble saving the data in the form to its appropriate table. I have a macro setup so that when i am done with a form i click a button wich saves that form and opens a new 1. however if i were to check the table it is supposed to be saving to the data is not there...

help please

please help with troublesome form Hi everyone!! I was wondering if anyone has an example of 3-tiered system. This is what i mean: Level1 has a list of items, for each item the user can go to the next form to choose a colour, and from that form(where you pick the colour) the user goes to the...