Search:

Type: Posts; User: CLCoop; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    1,647

    Re: Add next number based on previous record SET

    Yep think you are correct not putting in description_location.... Sorry I was out sick and just got back to working on this.
    I did fixs Micron's note of lngCurrentName... it should have been...
  2. Replies
    6
    Views
    1,647

    Re: Add next number based on previous record SET

    I get it to work as it does return a number... the first record set will show next number as 4 as it should.
    <tbody>
    DOC_NO
    Description_Location


    1
    Same_Same
  3. Replies
    6
    Views
    1,647

    Re: Add next number based on previous record SET

    I have found this code to do that is linked to the subform but can't seem to get it to work. What is missing... yes I'm not doing it on the main key number, the field I'm doing this on is in TEXT...
  4. Re: Query to auto populate another field in same record

    Ok I was able to update records based on Parent Child just had to manually type in each field I wanted to do. As well as there is a limit to how many parent/child relationships but it was enough to...
  5. Re: Query to auto populate another field in same record

    <tbody>
    Field
    Monthnum: Month ([Date])
    FY: IIf([monthnum]<10,Year([DATE]),Year([DATE])+1)
    Date
    FiscalYear
    REVISED_ALLOTMENTS


    Table
  6. Replies
    6
    Views
    1,647

    Add next number based on previous record SET

    Form called Input Allotments that shows the current funds of one Description_location.
    Subform that shows all the records associated with the Description_Location: ...
  7. Query to auto populate another field in same record

    Form called Input Allotments that shows the current funds of one state.
    Subform that shows all that states transactions: master_data_auto_fiscal_year_subform based on a Query.
    Query:...
  8. Re: How to search on numbers via dropdown box to return results in subform

    YEA THAT WORKED GREAT and I put in the recommend MSG on all my searches, guess the user will need that part more than me... now just have to figure out how to take the search results and put them...
  9. Re: How to search on numbers via dropdown box to return results in subform

    Neither of these two worked. My InvoiceID is a number, is there another work around?

    myInvoice = "Select * from LoanInvoiceALLQ where ([InvoiceID] = '" & Me.InvoiceIDcbo & "')"
    myInvoiceID =...
  10. How to search on numbers via dropdown box to return results in subform

    I've created the query on InvoiceID which is a large number. I have already created the search drop down box showing numbers in order. However when I select the number the Subform blanks out (there...
  11. Re: VBA CODE TO IMPORT EXCEL INTO ACCESS TABLE UPDATE and ADD TO THE TABLE

    This comes from the Tools, References, Microsoft Office 16.0 object library that then allows you to add the statement importexcelspreadsheet (got this form an online video) Still working on how to...
  12. VBA CODE TO IMPORT EXCEL INTO ACCESS TABLE UPDATE and ADD TO THE TABLE

    I'm trying to have access look out to a file (file name could change) then UPDATE and if not in the table ADD the information from the spreadsheet Tab ATT to the ATTORNEY table. Right now I'm...
  13. Replies
    4
    Views
    168

    Re: count up based on number of records

    THANKS this worked great, I cheated and recorded a macro to auto input the formula so it is working great thank you for your help!
  14. Replies
    4
    Views
    168

    count up based on number of records

    I'm trying to auto input in sequential numbers in the COUNT (Column A) based on the invoice number (Column B) this can go go on for over a thousand records depending on how many invoice were put in...
  15. Re: Formula for if L21 equals column AC then return value in AD to K21

    Yea got it to work with your help. Sorry I didn't respond sooner I ended up taking Friday off due to not feeling well. Here is the formula I got to work, yes I added a column so everything moved...
  16. Re: Formula for if L21 equals column AC then return value in AD to K21

    I have also tried this VBA code to get this to work...


    Dim Dept_Row as Long
    Dim Dept_Clm as Long
    Table1=Sheet1.Range("L21:L70") 'Branch names that will change as different Branches are...
  17. Formula for if L21 equals column AC then return value in AD to K21

    Fun times here. I have a Branch name in Column L21(which is a formula taking a branch name selected from Column C14 (drop down to select other branches) but always start in L21. I need Column L21 to...
  18. VBA if Cell is equal to this put a selected value in another empty cell

    Working within a pivot table and have added additional columns this way people can see what they spent and projected in the past and input for the future. However I have slicers so you select your...
  19. Re: IF Column E= "3100" and Column D="GLD" then put "3150" in Column E

    Awesomesauce!!! I was able to use the code and adapt to several other scenarios. Thank you for saving me a lot of time overthinking this. :cool:
  20. IF Column E= "3100" and Column D="GLD" then put "3150" in Column E

    Basically I have a code that changes (column d, BOC) into general ledger numbers converting all 3100-3140 into 3100-3157 however ONLY one Branch (column c, named branches) named "GLD" doesn't need...
  21. Re: VBA code to autopopluate FY year in Column A when date field is in Column Q

    Ok it worked so I saved in exited out then when back in and now Column A won't populate but it is 100% empty to include header. Is there a way to avoid the IF ISEmpty and have it override regardless?
  22. Re: VBA code to autopopluate FY year in Column A when date field is in Column Q

    Oh my goodness the formula was prefect however in an earlier code I had auto populated A1 to show heading so this prevented the code from working right. I moved the header auto fill to after the...
  23. Re: VBA code to autopopluate FY year in Column A when date field is in Column Q

    Ugh did the change and Column is still empty :(


    Set ws= Sheets("SOFData")
    lr = ws.Cells(rows.Count, "q")),2)
    For x = 2 to lr
    If IsEmpty(Cells(x,"A")) then
    Cells(x, "A") = "FY" & fy &...
  24. VBA code to autopopluate FY year in Column A when date field is in Column Q

    When you open the spreadsheet there is no date in Column Q. I've put in code to auto fill Column Q with a Now() structure. I then coded Column A to look at Column Q and if empty to take the date in...
  25. Re: VBA code to open workbook, select worksheet, save entire worksheet as CSV file

    You can use this kind of code when your not sure of the name or if someone is save a file with a date in it. This line isn't the issue it works great.
    For example if you have a file that is updated...
Results 1 to 25 of 34
Page 1 of 2 1 2