Recent content by TheEnigma

That is perfect, thank you! :)

Sorry I have this in a query. I actually have the - in the query, I just copied and pasted the original piece of code and forgot to change the , to a - I have a basic understanding of what this code is doing, but I guess I am not sure how to join both parts of the code together so that I am...

Hey there! I found another thread 701-797928 that talks about parsing data and how to get the information before a character, and a seperate one for how to get the data after a certain character, but would I would like to do is do both from the same field. I have a field in a table where there...

It is displayed as the second column.

Thanks! As you can probably tell I am not very affluent in my knowledge of code. I take it that [name of ID field]should simply be [id] as that is what I am using in the database as my primary key and also as the extra field in this combo box. So the following code is what I am now using...

Ok there is this code in the event procedure, but the combo box wizard must have created it as I didn't. It is in the after update field. Private Sub Combo106_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst...

I originally created the combo box using the combo box wizard in the MS Access forms. I adjusted the code slightly so that it would sort that field numerically rather than the order they were entered into the database.

This code. SELECT [VendorInvoice_tbl].[CustomerInvoice], [VendorInvoice_tbl].[id] FROM [VendorInvoice_tbl] ORDER BY [VendorInvoice_tbl].[CustomerInvoice], DESC;

I will either type the invoice number in this field and hit enter, or type the invoice number in and select the record from drop down menu from the combo box to display the invoice numbers and then select the correct invoice number from the drop down menu. This will then bring up the details on...

Hi, I think I am missing something here? The sql statement is in the data/row source properties of the combo box. I use that combo box to search and display the details relating to that invoice number. Other than that there really isn't any other code relating to searching and displaying that...

SELECT [VendorInvoice_tbl].[CustomerInvoice], [VendorInvoice_tbl].[id] FROM [VendorInvoice_tbl] ORDER BY [VendorInvoice_tbl].[CustomerInvoice], DESC;

Hi there, I have a problem where I have a combo box set up on a form which I use as a search field to bring up various invoice numbers. My problem is that in the search field, there are at times duplicate invoice numbers, but the invoice numbers have different information against them. Both...

Hi PHV. I don't know how to write code, so not sure what exactly I need to put in there. I understand about the set focus part, but not what else I would put in then that would make it mandatory they will that field in?

Hello there. I have a form for entering invoice information, and I have 2 different currency fields. Field 1 is for AU currency, and the other field is for foreign currency. If a foreign currency amount is entered, then the user is supposed to select a drop down menu in another field which...

Hi Roy, Thanks for that. The only problem I have is that the invoice number is both numeric and alpha numeric. I am also unsure what you mean in the second paragraph..