Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TheEnigma
  • Order by date
  1. TheEnigma

    Parsing Data

    That is perfect, thank you! :)
  2. TheEnigma

    Parsing Data

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

    Parsing Data

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

    Searching by combo box

    It is displayed as the second column.
  5. TheEnigma

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Searching by combo box

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

    Force field entry

    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?
  14. TheEnigma

    Force field entry

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

    Unique fields - not recognising null

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

    Unique fields - not recognising null

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

    Automated export to excel and save

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

    Automated export to excel and save

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

    Automated export to excel and save

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

    Automated export to excel and save

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

Part and Inventory Search

Back
Top