Search results

Thanks that fixed it

Hi I was wondering if anybody could help me with this? I have the following code on an on click event for a button If Me.practicecheck.Value Is Null And Me.rolecheck.Value Is Null Then DoCmd.OpenForm "filtered results no role no practice" End If but I get the debug box pop up, and when I go...

Many thanks for all your advice, I think that I will need to rethink this issue, and it probably would be better if I stored the onhand values on the fly. Thanks Marcus

hi thanks for your suggestions, it has definitely given me some more ideas on how to move forwards. I would be interested to find out if you agreed with the way I intended to keep a track of how mcuh stock is around, for example, when a supply item is distributed, the value in the onhand...

Hi I am trying to develop an inventory control database and would really appreciate some advice on the way I propose to develop the application Inventory Control Database. Outline for inventory control database. The database will have the following tables: Supply Table Person Table...

One way of doing this is using a select case on the on chage event for the dropdown box for example dim mydropdownvalue mydropdownvalue = me.combobox.value select case "mydropdownvalue" case "value1" me.textbox.value ="New value1" case "value2" me.textbox.value ="New Value2" end select

Hi Have alook here uses select case to validate on the before update event http://www.access-programmers.co.uk/forums/showthread.php?t=95923 Thanks Marcus

Thanks for that.

Hi I gave that a try but it is not quite what I was trying to do. I just wanted to change the detail colour of the detail section on a continuous form if the value of a text boxx = 10. I used the conditional formatting and managed to change the colour of the textbox itself when the value was...

Hi That did the trick I just replaced the if statement at the bottom of the page with if cancel <>"true" then docmd.close docmd.openform "switchboard" end if Many thanks for that Marcus

Many thanks for that, Will try that now and see how it all works. I really appreciate your help Thanks Marcus

just gave it a try and it worked. Thanks

Thanks for that

Hi Was wondering if anybody could help me with this? I would like to be able to perform a requery Me.cmbgplistname.Requery everytime a user clicks a navigation button on a form to move through the records? On which event would I place it on? Thanks Marcus

Hi Was hoping that somebody would be able to help me with this. I have a continuous form showing all the records with a button that allows the user to click through and edit a particular record in the list. What I was hoping to do is change the colour of the detail background if a value of a...

Thanks Hi John Thanks for that. Gave it a try and it does what I want, but there is one small problem, I was hoping you could help me with. The code works and highlights the field as being invalid. However, it still procedues to the next record. Can you tell me what is wrong with my code. I...

Hi I was just wondering which event would I use to make something happen when a user uses the navigation buttons to move between the reocrds on a form. I have written something that basically, validates a form, and I have attached it to the close button on the form, but now want it to also kick...

Thanks for your help Got it back now Marcus

Hi I was wondering if anybody could help. Up until yesterday, whenever I placed a button on a form a box would popup giving me the option to make the button open a form, a report a query or close the form. For some reason this wizzard has now disappeared and I would really like to get it back...

Thanks Will give that a try