Search results

Hi. Sorry. I have been out of the office for a few days. Here is the code that I have. Private Sub Units_Recived_BeforeUpdate(Cancel As Integer) If Nz(Me.Units_Recived, 0) > Nz(Me.Units_Ordered, 0) Then MsgBox "Units Received Cannot Be More Than Units Ordered", vbOKOnly...

Now I am not able to enter any number without getting the msgbox. Not sure why?

Hi. Thanks for the help. Been stuck on that all morning and it was just the space after the backslash after quotes that was messing everything up.

Thanks MajP. That worked a treat.

Hi Peter Is the code correct as it doesn't seem to do anything. I've moved it to the Before Update event and it still doesn't do anything. I've also moved the greater than sign around and it doesn't allow me put anything in the field. Private Sub Units_Recived_BeforeUpdate(Cancel As Integer)...

I have just tried a way around it by adding text boxes with the right information in it and making them invisible. This still isnt working. Private Sub Cbodeladdress_AfterUpdate() On Error GoTo Cbosite_AfterUpdate_Error If Me.Cbodeladdress = "Site" Then...

Hi I have a combo box with two options in it, Site or Yard. When I click site I want it to pull the address from another combo box and when I click Yard I want it to pull it from a different combo box. I have the code below but it dosen't seem to work properly. I think my IF statement might be...

Hi I have a form with a button to open a specific file in a folder. I have recently changed computers and now this wont work. It only works for new folders created and not the ones that were on the old computer. Private Sub Btnopenfolder_Click() On Error GoTo...

Hi I have two fields, Units Ordered and Units Received. Units Received cannot be more than Units Ordered. I have code for it but it dosent work properly. I have tried the greater than sign both ways but neither work. Private Sub Units_Recived_AfterUpdate() If Me.Units_Recived <=...

Hi there. I have two number fields and one field cannot be more than the other. What is the basic code to check that one is not more than the other. Thanks

Tried it. It just wont upload. Have you got any suggestions on the question.

I have tried to upload my database but it says it is to large. I have zipped it but it says its to big. As far as the threads below they are mostly about combo boxes and not relevant to my problem.

Hi there. I've searched all morning and haven't come across anything that can help. I have a form with a sub form. I need to filter the sub form based on a checkbox which is on the main form. The sub form displays a list of purchase orders and some are invoiced and some are not. I want to...

Minty There can be multiple lines on each order so we need to differentiate which items have been delivered and which ones are still outstanding on the order. We can receive 5 out of 10 items and it will be classed as not completed. It will be part invoiced. The check box isn't visible until...

It is for a purchasing system. When we receive an invoice and the units ordered is equal to units received then the check box will available. The button is to show each item on the order has been received. Sometime we only receive half of the items so it hasn't been fully invoiced and should not...

Yeh I know if you use that code all the check boxes appear but I only want one per line to appear. I've never done conditional formatting before. What would I have to do to make it work. Thanks.

Hi. I have a sub form for a purchasing system. I need the check box to be invisible until the units ordered field equals the units received fields on a continuous form. I need each check box on each line to be independent of each other. I'm not sure at all how the code would look for this. I...

Thanks Gasman That has worked perfectly. I cant thank you enough. How would i go about searching for this newly created folder from another form. Or how to create a hyperlink to this folder on creation that can be stored in the table. Sorry to keep bothering you but I have spent 3 days trying...

Thanks Gasman What would I need to add to the code to get it to copy the files. I understand what you are saying but im quite new to this. Thanks

I want to create a folder and copy files from another folder at the same time. I cant seem to figure out how to create and folder and copy at the same time. I can put another button on the form to copy the files but would prefer it all in one button.