Search results

it works...thanks man [Forms]![1]![Combo1]

i place that in the update to column of the update query

i have query"X" with all the records that have true values in their checked box. now on a seperate form the user selects a value from a combo box and i want all the records from the "X" query to update to that value...i think i need an update query and some code on the after update of the form...

how do i copy the data from one record to another. lets say i have a table of "movies" "best movie 1" has the same director, producer, star as "best movie 2" i need a way to build a form that selects the two movies and copies the data from movie 1(everything except the title) and duplicateds the...

if i have a form (call it form 2) with a text box who gets its default value from a form 1 field...what would cause the text box in form 2 to not display the value unless the form is totally maximised???

anyone? please help and send the attachment

Can anyone help me with this attachment…I want to create a data entry form that already has info from the first form…

anyway you could update attachment

Heres an example

ILL EXPLAIN IT DIFFERENT I load a form that gives location specifications. It also has a subform that shows every light bulb that goes to that location. I want to a button that loads another form…and on this form the location specifications of the previous form are already loaded

I have a form (form1) which gets its info from table 1. once I load this form and its data I want to use that data so when the user hits form 2 (which also gets its info from table1)(and which is strickly a data entry form) some of the information from form 1 is already inputed to form 2 Any ideas

take a look at this DB...i have a "last" date field and a query that adds months to that field to create a new field called "next"...in the query when i do a between criteria it wont pull the proper records...example start date 1/1/09 end date 12/30/09..it should show all records for 2009..it...

i have a query that has records based on true. i want to change these values to false when a user hits a button....i could make a macro to update this query but im lost is this what i should do...and how or is there another solution

i have a location table and a location type table i also have an issues table. so when the user selects location type (meeting room) the next form should filter all locations to display just meeting rooms. when the user selects meeting room 101 then a new record in the issues table should be...

I have these 100 location names which are categorized by 10 types. I would like to create a combo box listing the types…after the user selects the type… this form or another one has a list box filtered of locations only pertaining to that type…that value needs to be used to input data like an...

I have a light bulb table. It lists all the lights used. One of the fields is (rated life in hours) I have a location table. This lists all the locations and fixtures and date relamped. So lets say I have a hall and it has regular 100 wat lamp in it. I have a querry combining the tables. I want...

It is a (dateadd)…so you are saying this can be done if I include the (third element) and what is that? in the querry i have a field next relamp: DateAdd("m",[lasted],[relamp date]) the criteria is Between [Enter Start Date MM/YY] And [Enter End Date MM/YY] i added the third element if the...

i have a field that adds a certain amount of months to a previous date inputed. when the query is open the user inputs a date range to pull up records. im using between mm/yy and it works when i dont compute the date but when i do compute it gives an error...is there another way to do this....i...

it all works perfect thanks again

now the bonus question what if the second form i am opening is an order form (data entry) how do i get the [lamp id] into the id box