Search results

Hi all, I have a subform which can be opened via a button from numerous main forms. I need to access the main form from the subform to update a value on the main form based on what the user has done with the subform. I created a textbox on the subform, which gets it's text value set when the...

If that makes sense? Say I have numerous forms, all of which can open FormB. These numerous forms can all open FormB via a button click. I create a value on FormB which I would like added to a value on the form which FormB was opened from. Beyond creating a seperate FormB for each of the...

Can I do this? ie click a button on the main form to delete a record on a subform? Ta, nry

Hi, I can get a button to open a form and get a button to close a form. Thing is, I want the button to open one form and close itself...if that makes sense? eg form1 has a button on it. When clicked, I want to open form2 and close form1 I've tried using the forms LostFocus property and also...

Hi all, I have a main form with a number of subforms on it each representing an appointment time during a given day and each subform adds the Client, Stylist and Cut details to the Appointment table. Since I want to force the user to enter all of the above details, I have the relationships and...

I wish to find records from one table whose date matches that in another table. Without putting in the criteria, the query returns records and some dates do match between columns. Thing is, when I attempt to add the criteria (eg =[Appointment.Date]) it returns no records at all....am I...

Hmm, I owuld have thought this was an easy one! I have a table which holds appointment details, one of these details being the appointment date in Medium Date format. I attempted to create a query which would list all appointments today so I created a query based on the appointments table and...

Hi all, I've tried using gif, png, jpeg and cannot get Access to display the image correctly. I have set the background of said graphic as transparent, and it is transparent when displayed within Paint Shop Pro 7. Can I use transparency correctly when displaying images etc in Access? It'll...

Hi all, I have a feeling I've seen this answered before but I've searched and back-tracked to no avail! I have a table with certain fields set as 'Required' which should mean a new row cannot be created without this data being entered....but when I use a form to enter this data a new...

Is there a way I can display the name of the weekday in a text box? ie display Monday, Tuesday, Wednesday etc etc? Thanks, nry

OK, I have a text box linked to a combo box on my form. When I choose a product from the combo box, the text box displays the price of the product. Which is good. Thing is, I actually want the text box value pulled from the combo to be bound to a data field of a record in a seperate table...