Search results

Hi there, I use a form to input data or orders and have a command button which takes the current record and attaches a snapshot of it to an email. I can currently view all records that I have entered by using the arrows at the bottom of the form. I would like to still be able to do this if...

This would allow up to 9999 orders. After that its not my problem, it was asked to be done this way :)

Hi, This has probably been discussed before but i didnt know what to search for... I use the following code on a form to check for the number of orders in a table and then add 1 to create the next order number: =Count(OrderDetails!ID)+1 This works fine but displays the number as an integer...

I have used an option group. I will look the afterupdate. should have known as I used it somewhere else. Thanks

You could always use the on screen keyboard (all programs/accessories/accessibility) to input data using your mouse

Hi, I am having a problem creating some code for some option buttons. I am using these over a picture background (scan of a paper form) so that the user can easily enter the info. however this leaves me with over 200 option buttons to code. I am using a textbox under the picture so that when...

I had a bit of a play with the change event and it seems to be working fine now. I changed the afterupdate check to Insurers_Informed.value Thanks for the replies Private Sub Insurers_Informed_Change() If Insurers_Informed.Value = "Yes" Then Me.Label104.Visible = False...

Hi, I am trying to add an event to a combo box that has two values (yes, no) so that when yes is selected other options appear. I have tested the code in all sorts of different ways but all I could manage was making the other options appear whether I selected yes or no. Here is my code...

Thanks for the reply. Seems like a good way to do it

Hello, I am creating a database for a user that has a health & safety report form on paper that he would like replicated on screen on a form that he could fill in. Is there a way to do this? If not any ideas of which way to go from here would be much appeciated. Thanks in advance for any help...

Ah, thanks that makes it easier for me :)

I have a report for accidents which has a list for how many days off sick people have had as a result of the accident. I am trying to calculate a severity rate for which I will need to add up all the days off over a year. Is the best way to do this by using running sum or is there another way...

Thanks again it is now working. A problem that I still have though is that the file I am taking the data from needs to be open otherwise I get an error. Is there a way to open an access report in the following code somewhere? Dim tStr As String tStr = "The current severity rate is: " &...

Yes I am trying to get the value of the running total and display it in the messagebox. Ill try doing it like in your example. Thanks for the help

I am trying to add an expression into a messagebox but I am not sure how to make access view it as an expression instead of as text (I am new at using the expression builder) =MsgBox("The current severity rate is: @ «Expr» Reports![File name]![No of Lost Days].RunningSum «Expr» @ ",64,"Severity...