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...
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...
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..
Hi there,
I want to make a field in a database a unique field, so no one can enter a duplicate value. The unique field will be for an invoice number. In some instances however, when the record is created we do not have the invoice number yet, so we need to come back to that record at a later...
Thank you so much for your help. I couldn't actually get it running with that whole path above for the scheduler (I have never used the scheduler till today, so probably something silly I am not doing), but there was an easy work around for that. I created a form that on load runs the macro, and...
Hi there. I guess I am doing something wrong. Sorry but I don't know VB really, so it is probably something very simple I am missing. It is actually coming from a query, nit a table. Does that make a difference? The qry name is Intro_Total_Daily_qry, and the path that it needs to save to is...
Hi. I have used the OutputTo macro, but it doesn't give me an option to save over the exisiting document. Any ideas how I get around this? I won't be using the excel document, so I would otherwise be relying on someone else needing to always delete that other document after they have used it...
Hi there, I hope someone can help. I need to create an event procedure on timer that will automatically take a query, and save it in excel format to a folder on our system. It should save over the exisiting excel document each time it runs. The query name is Intro_Total_Daily_qry.
I know how to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.