Search:

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

Search: Search took 0.00 seconds.

  1. Use form or other means to delete or add VBA code?

    I am working on a project for a companies payroll. What I am doing is taking payroll data and using a button to automate and organize the data to enter into our accounting software. I am moving along...
  2. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    Ok, Thanks for the help, I really appreciate it!
  3. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    I updated it to the following, but I get a null value. Is "ExpDate and IncDate supposed to have brackets? I have also formated all dates to short date to get ride of the time stamp.


    Private Sub...
  4. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    Yes, "IncDate" and "ExpDate"
  5. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    Ok, updated it to this. This is where I get stuck, for some reason the "between" subfunction is not recognized. Do I have the syntax wrong? I am a beginner at this, so thank you for your help!
    ...
  6. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    Ok, I have updated and am now showing my DSum functions. How to I add date criteria to these?

    Private Sub btnCalculate_Click()
    Dim txtNetIncome As Currency
    Dim txtIncome As Currency
    Dim...
  7. Re: Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    The DSum I used was only in the Expense and Income text boxes and I linked to the tables I had created, each text box separately. I would like to create a button with VBA code behind it that links to...
  8. Using Dates to grab data from a table to text boxes on a form? PLEASE HELP

    Hi,
    I have created an income statement form in access that has a Beginning Date, End Date text boxes followed by Income and Expense text boxes and lastly and Net Income text box. I have tables...
  9. Populating excel cells from a form formated as a number?

    Hello,
    I am trying to create a form in excel and I am dropping values from the form into an excel cell. The problem I am having is that I can't get the values that drop into excel to format as...
  10. Re: VBA to Open Another Instant of Excel and Run Macro

    Hello,
    I am trying to create a form in excel and I am dropping values from the form into an excel cell. The problem I am having is that I can't get the values that drop into excel to format as...
Results 1 to 10 of 10