Search results

Hi All. I have a checkbox at the bottom of the form. What I want is when the checkbox is clicked, all of the received textboxes to equal the units ordered textboxes. I have tried a few different methods but none seem to be working. You are able to enter data into the textboxes. However I...

Hi. I have a combobox with different sizes of products like metal sheets and bars with sizes like 1mm up to 1500mm. The combobox is organising them like the photo below. The comboboxes are cascading and work fine but wont organise into numerical value. Is there a way that you can organise it...

Hi. I have a subform that is filtered on load. It shows purchase orders related to a certain quote. I have two text boxes to filter the subform based on a date range. How do I filter the subform back to the original filter? I have tried me.subform.filter = "" me.suform.form.filteron = false...

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

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...

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...

I am creating a new database for where I work. It is creating quotes for jobs. When I click the save button its save the quote and opens a new folder which gets its name from three fields on the form. I want it to import or copy files from another folder in the directory to the newly created...