Search results

Hi Ajetrumpet, first of all I selected different records to demonstrate that each text box was showing the relevant record selected in the subform. I navigate to matching records, and both test1 and test2 are showing the same number, but it always appears as incorrect. The above code is in the...

Yes I've double checked and I am using the container name - if you look at the first screenshot above, right at the top it shows the test1 and test2 fields are bringing back the right data - I've also tried pasting the data into these fields using the oncurrent event of each subform, but when I...

Hi, I have a form called "InvoiceForm" - on this form are two subforms called "NewPurchaseTable" and "TheirPurchaseTableQuery". Below is a screenshot of how "InvoiceForm" looks: I have blanked out other columns that are irrelevant to this problem to avoid confusion. What I am trying to do...

maybe there has been no response because this is an Access forum and not Excel.

only took 8 hours in the end! had to base the second subform on a query that included the "Invoice ID" field in it, so it was then displayed on the subform and filtered out that way.

Hi, I have two tables, "NewPurchaseTable" and "TheirPurchaseTable", I am viewing them side by side in subforms on a main form called "InvoiceForm". Each subform is called "OurPurchaseTableSubForm" and "TheirPurchaseTableSubform" respectively, and they are both being viewed in continuous forms...

I think I've got it now: Private Sub Match_Click() Forms!InvoiceForm!OurPurchaseTableSubForm.Form.[Invoice ID] = Forms!InvoiceForm!TheirPurchaseTableSubform.Form.[PurchaseID] End Sub Thanks for your help ajetrumpet, and for your advice dreamweaver.

the datatype of the [Invoice ID] field is Number>Long Integer>Indexed with No Duplicates allowed. the datatype of the [PurchaseID] field is Autonumber>Long Integer>Indexed with No Duplicates, it's also the primary key for this table. So in theory it should be fine but it's not, I'll backup and...

Thanks for replying Dreamweaver, I couldn't get the HAVING code to work however I've just managed to crack it with the following code: If Me.MatchedFilter = True Then strWhere = strWhere & "([Invoice ID]) Is Null AND " ElseIf Me.MatchedFilter = False Then strWhere = strWhere &...

Hi Dreamweaver, I get what you are saying, but I already have a system that tells the supplier our order number, where to send the invoice to, and where to send the goods to. I've used the system for a long time and it does work, and it works a lot better than many order systems that are...

Hi Dreamweaver, First of all, regarding the code I didn't really understand what you meant by "dao.recordset" - I tried using: Private Sub Match_Click() Dim rsSource As DAO.Recordset Dim rsTarget As DAO.Recordset Set rsSource =...

Hi, I have built a search form where I use various checkboxes and combo boxes to filter the data that is shown on the continuous form. However I am struggling with the code for the following instance… I have a field called [Invoice ID]. I also have a check box called “MatchedFilter” . If...

Hi Guys, Thank you for your posts, the reason why I need do it like this is because my company has sneeky suppliers and they have tendancies to overcharge and to put through the same order twice. What used to happen before was we would place an order on ID 3456, and our supplier would invoice...

Hi, I have two tables, "NewPurchaseTable" and "TheirPurchaseTable", I am viewing them side by side in subforms on a main form called "InvoiceForm". Each subform is called "OurPurchaseTableSubForm" and "TheirPurchaseTableSubform" respectively, and they are both being viewed in datasheet view...

Hi, I've tried to search for "use Like in vba" and "like in code" but I can't find anything similar. Does anyone know how to use the like function in vba? here's the statement i'm trying to write: If me.transaction_code.value = like "RC"* then me.Internet_Order.value = true any help would be...

Solved it! In case anyone looks this up in future the code is: Me.[Order Details].Form.[Product Name].Locked = False which unlocks the field in the subform.

Hi, I have a form called “Quote Entry Form” which contains a subform called “Order Details”. There is a field inside the “Order Details” subform called “Product Name” which has the “locked” property set to “Yes”. Does anyone know if there is any code that I can set to a command button to...

I don't usually post advice on here as I'm still a relative newbie so forgive me if this advice isn't correct as I'm just trying to help, but I hope it helps. Create the form you want to popup, go into the "other" properties of the form and select "Popup" as Yes. Probably the best method to...

Got it in the end, I made a query against the union query to return the specific data required. Thank you very much for the time you spent helping me TehNellie, I thank you very much indeed.

sorry that might not have been very clear, at the moment the list produces results for every product in the "ourproductstable" - I want to restrict it to a single product, in this case product "XYZ" I've tried the following code but to no joy: WHERE (((Ourproductstable.[productid]) = "XYZ"))...