Search results

thanks Gemma works great

Hi, I would like to insert the currrent time in a feild on my form once a checkbox is ticked. Can anyone please help me with this. Tks Rgds Roc

Thanks unclegizmo I will try it.

Hi, Can anyone advise why I am getting these two error messages in attached image. I am running Access 97. The first message refering to fDesign appears each time I have something open & click on the Design View icon. The only way I can go into design view for a form or table etc is when I...

Hi I have a calculated Field query which groupes all the different order types by the first char A, B, C, & D with the corresponding total sums for each order type. Now I would like to have a form which displays each order type & the corresponding sum value for each type via a text box. I am...

Thanks Pat I will give it a go.

Thanks for your help BL

I have a main form with a few imbedded sub forms. Sometimes these is a great deal of data in one of the sub forms & non in the others. Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks...

I have a popup calendar which works perfect on my form but will not work in an imbedded sub form. If I go to the sub form itself it works perfect both in datasheet view and Form view. But if I go to the main form which this same sub form is imbedded (datasheet view) it does not work. The...

Uncle Gizmo, thanks for your time. I am only new to this and am learning as I go so I am not sure I understand what info you need. “They are in the subform because field x=? “ The subform is based on a query which extracts all the outstanding orders for delivery which includes the weight for...

I need to know the combined total weights of particular orders so that I can organize delivery trucks which are weight restricted. I just need a quick reference of weight for these orders so I don’t overload trucks when assigning deliveries. I hope this makes sense.

Can anyone please help or advise where I can look for help on this problem. I have a subform which shows all my outstanding orders. Below it is a calculated field which shows the total weight of all the orders. (Steel Beams) I would like to be able to highlight the weights on certain orders &...

Thanks Stopher for your quick & detailed reply. I will try it out & see how I go. (not sure if I understand everything fully but its something to work on) Thanks again

Hi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused) Anyway I have a form which is based on a table that holds all the info for orders placed by customers. It holds info on all the...

Thanks for advice, I will search for info.:)

Hi I am new to Access and just need some advise. I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items. I want to make an access database to hold all this info. Should I make one table to record all information from the 5...