Search results

  1. J

    Importing Numbers from Excel to Access

    I'm about to lose my mind with this one. I've got a spreadsheet that I'm importing into an access table. In the excel file there are a number of text fields and one field that is formatted as percentage and another that is formatted as number. When I import the excel file into access...
  2. J

    Multiple Tables - Single Qry and Report

    Scratch that. figured it out.
  3. J

    Multiple Tables - Single Qry and Report

    Hi Doc Man, Attempted to use your suggestion, but I seem to be failing miserably. Tried to write the SQL in VB but just doesn't seem to be working (I'm pretty amateur at this stuff). Other thoughts on how this could be done? Thanks
  4. J

    Multiple Tables - Single Qry and Report

    Thanks, Doc Man. I'll give that a shot. May work to my advantage since I'll have the old data in the table as well, I may be able to use it in other ways if the boss wants/needs it.
  5. J

    Multiple Tables - Single Qry and Report

    Hi Doc Man, That is exactly correct. Each table will be kept for historical purposes.
  6. J

    Multiple Tables - Single Qry and Report

    Hello all, I'm hoping someone can tell me if what I'm planning on doing is possible. Each week I'm going to be pulling an excel file that will be imported into a table in access. The only difference in the files will be the file name and the data contained within. The structure will be the...
  7. J

    Make field visible dependant upon group

    Hi all, I have a report that groups on a field named "Action" which consists of four different values: Opened, Closed, Accepted, Mitigated. I want to add a field named "details", but only want that field to be visible if the record appears in the "Accepted" group. Is something like this...
  8. J

    Compile Error

    Hi All, I'm having a problem with some VBA code. This was converted from a Macro using the Covert to VBA tool in Access 2016. When I run the code it fails at the line in bold below. The error message is Compile error: Sub or Function not defined. Any help would be appreciated...
  9. J

    Counting Days Function _ Error 13 Type Mismatch

    Never mind. I figured it out. Had the wrong field names in the function call. time to go back to bed.
  10. J

    Counting Days Function _ Error 13 Type Mismatch

    Good morning all, I am using the VBA code below to count the number of workdays between two dates. I call the function in a query, but when the query is run I get a Error 13: Type Mismatch. It seems as it may have something to do with the variable declaration, but I'm not sure. I'm not a VBA...
  11. J

    Coversion to Access 2016 whacked a subform

    Never mind....I just found out Microsoft removed pivot table capability from Access beginning with 2013. Awesome. Many of my prior DB's are now screwed. Way to f up something useful. Thanks once again, MS.
  12. J

    Coversion to Access 2016 whacked a subform

    Hi all, Just wanted to see if anyone has had any issues or may know what's going on when I open a DB created in 2010 with 2016. I have a subform on a main form that displays a graph. When I open the form in 2010, no problem. When I open it 2016 it reverts to a standard subform with...
  13. J

    VBA code for pivot table in report

    Hummm...not exactly sure how to perform what you are suggesting.
  14. J

    VBA code for pivot table in report

    Hello all, Hoping you can help me with a little problem I've been trying to figure out, but can't. I'm wanting to customize the "Yearly Sales Report" from the MS Northwind Traders DB. The existing report totals the sales by quarter and groups by employee, but why I'm trying to do is...
  15. J

    Subreport Headers

    SkyCraw, I'm having the same problem you had, but I'm not sure what you mean by creating a dummy group (=0). Can you clarify for me? Thanks!
  16. J

    Toggling filter on subform

    Well, Galaxiom's code for the filter works fine on form load, but the code for the check box toggling of the filter on and off doesn't do anything. Does the subform need a requery command or something?
  17. J

    Toggling filter on subform

    Okay, So I've updated the code which now looks like this: Private Sub FilterCheck_Click() If Me.FilterCheck = -1 Then Me.sbfCPECourses.Form.Filter = "" Me.FilterOn = Not Me.FilterCheck Else If Me.FilterCheck = 0 Then Me.sbfCPECourses.Form.Filter =...
  18. J

    Toggling filter on subform

    Ok, I managed to get it working by referencing some other posts. This is what I have: Private Sub FilterCheck_Click() If Me.FilterCheck = -1 Then Me.sbfCourses.Form.Filter = "" FilterOn = False Else If Me.FilterCheck = 0 Then Me.sbfCourses.Form.Filter =...
  19. J

    Toggling filter on subform

    Hi Minty, I tried using the code you suggested by I receive the following error: Compile error: Else without If. Not sure what's going on.
  20. J

    Toggling filter on subform

    Hi all: I've searched and reviewed other posts related to my problem, and I can't seem to figure it out. :banghead: I've got a form with a subform. In the subform properties a filter is run on load. The filter is Year([Course Date]) = Year(Date()) to filter for all courses taken in the...
Top Bottom