Search results

  1. C

    DLookup using equals or less than

    CJ_London, Yes it can numerous XNON before the other code. So I would need the one closest to the XASU code. Gemma - I have two huskies myself, 1 female and 1 male. They are the best dogs in the world. My girl (Aiyana) is deaf and we rescued her from a shelter. I have never seen a...
  2. C

    DLookup using equals or less than

    I thought that my DLookup was too simple as well, but did not know really how to move forward. The XASU code can only be ran once per account number. So do you have an example of how the two lookup values would work? One thing to mention the XASU date is being populated in textbox...
  3. C

    DLookup using equals or less than

    I would like to get the date for code XNON that happened before code XASU. The XNON code can happen same day or before.
  4. C

    DLookup using equals or less than

    tblaccountnotes acctnumb, custname, NIIN, code 123, Donald, 1/1/17, XNON 123, Donald, 1/2/17, XASU 123, Donald, 1/3/17, XNON
  5. C

    DLookup using equals or less than

    The code tags I am not sure why it is randomly splitting that apart. Maybe because the code has [] and it is cancelling the code tags. So what I am trying to do is get a date based on system code 'XNON', but it has to be date that is equal or less than system code 'XASU'. The dates come from...
  6. C

    DLookup using equals or less than

    Hey guys, I received such great help yesterday with another DLookup issue so I am hoping someone can help with this one. I have a table with account notes and I am trying to find one code and the date it happened. Then find another code that is a date less than or equal to the first...
  7. C

    DLookup Where Clause using OR

    Thanks guys!! That worked perfectly!!
  8. C

    DLookup Where Clause using OR

    Hey guys, I am trying to do a DLookup, but instead of using AND use the OR in a where clause. Below is the is the string and I cannot get it to work Me.txtdemand = DLookup("NIIN", "tblaccountnotes", "[acctnumber]= '" & Me.txtacctnum & "' AND [code]= 'Serve' OR 'XAServe'") The table...
  9. C

    Highlight words in MS Word from Access

    Hello Everyone and Happy Monday, I am trying to export a form and it is basic now, but in the end it will be populating a table with data from Access. I am trying to highlight one sentence when it exports to Word. I cannot figure it out after many Google searches. This is my first time trying...
  10. C

    Recordset using GROUP BY

    Hi everyone I was able to solve it by using a parameter query and passing the variables through the recordset. Below is part of the code that I did to make it work: Set db = CurrentDb() Set qdf = db.QueryDefs("qryvendorlist") qdf("EnterManager") = varUser Set rs = qdf.OpenRecordset()...
  11. C

    Recordset using GROUP BY

    Ok, so the managers have requested a page where they can see the stats. So I am creating a dashboard for them. I want to list the vendors that they are assigned too. So a form with a snap shot of the vendors, how many orders and etc. That is why I have it populating to a list box. So whoever...
  12. C

    Recordset using GROUP BY

    it is actually one table and the table name is tblorders. When an order comes in it logs the vendor name and manager automatically through a query I believe. So it is all stored in one table. I was thinking about making a separate table with just the vendor and manager and grabbing the...
  13. C

    Recordset using GROUP BY

    Hey everyone, I have a table that has vendors and managers associated to that vendor. I am trying to create a recordset with an SQL statement that picks the vendors based on manager and then group by. I need this because the table can house the same vendor multiple times. I have it working...
  14. C

    Access to Word using Currency

    I got it to work - We were both on the right track, but the layout changed with 2013. So here is the correct way to do it: .formfields("Cost").result = Format(Me.txtcourt, "$##.00") Then you just add to it depending on the currency for example $1,000.00 would be "$#,###.00"...
  15. C

    Access to Word using Currency

    I have Word 2013 and it does not give me an option to change to Currency. It seems to have everything, but that as an option.
  16. C

    Access to Word using Currency

    I tried - .formfields("Cost").result = Me.txtcourt.Value = Format(Me.txtcourt.Value, "$0.00") and on the Word Document it comes up as False. The word file has a textbox inserted with the bookmark named Cost if that makes any difference. Any other suggestions?
  17. C

    Access to Word using Currency

    Hey guys, I built a form that exports a table to Word. I am using Bookmarks in the Word Template and one of the fields is Currency. I am having a hard time trying to get the value sent over to word with currency. I have tried the below: .formfields("Cost").result = Me.txtcourt =...
  18. C

    Combo Box to populate Text Fields via Recordset

    They used an INSERT INTO command, but with the article you gave me I was able to figure it out with some trial and error. Below is the code and as I assumed you have to open the recordset because they are not choosing the name from the combo box. I also discovered the hard way that you have to...
  19. C

    Combo Box to populate Text Fields via Recordset

    I took over this project and they went with unbound forms. The guys who actually had the project were programmers and do this day in and out. I was just trying to match what they did in case it goes back to them. If I end up keeping this whole project (I hope not) then I will probably switch...
  20. C

    Combo Box to populate Text Fields via Recordset

    This is the code that I have for updating the record: Private Sub cmdupdate_Click() rs.Edit rs!vendorstatus = Me.cmbvendorstatus rs!FirmShort = Me.txtfirmshort rs!FirmLong = Me.txtnewvendor rs!Contacts = Me.txtcontacts rs!AuditAddress = Me.txtaddress...
Back
Top Bottom