Search results

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

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

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

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

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

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

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

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

I've got a tabbed page with a number of labels and controls. I'm trying to create a second tabbed page and for some reason one label and control keep appearing on the new tab page. If I try to delete them from the new tab page they get deleted from the original tab page as well. I've tried...

Hello all: I currently have a form from which users can select their name and it will open a report listing events they have attended. It does this through a macro running a filter (I know, macros suck...but I suck even more at coding in VBA). What I would like to happen is the same criteria...

Hello all: I currently have a report setup and the higher ups would like to generate the report by quarters or YTD when ever they feel like it. I've created buttons that allow them to simply click for the prior quarter, the current quarter, or YTD. The problem is I would like the report...

Hello all, This is driving me nuts. I have a query the field "Objective" and the data in that field is "A.1", the next record is "A.2" and so forth all the way up to "A.18" I have a report that is pulling its data from that query, but in the report the data shows up in the following...

Hi All, I've got a table that has several yes/no data type fields. I'm trying to the data into a report and show either yes or no as opposed to -1 or 0. Any thoughts?

This is probably so simple that I'm overlooking it, but I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out. Thoughts? Thanks in advance!

Hello all: I just wondering if anyone know if it's possible to mask data in a report? I have a report that contains a field for an ID number. Depending upon who is receiving the report only a partial ID number can be shown. Example: Instead of showing ID#: 123456 the report can only show...

Hello all, I've got a report which contains two subreports. When the report is open the user must provide a criteria, in this case the year, and the report will generate using two subreports that use the same criteria. The issue is this: When I go to print the report it will ask for the...

I have a report that is pulling data from a table. I decided that I wanted to group the report by a field that I had in the details of the report, so I moved it up to a head section and grouped on it. Now when I run the report the field is blank...move it back to the details section and...

This is probably so simple it's stupid, but I can't figure it out for the life of me. I have a command button on a form which when clicked I would like it to open a second form and pass the value in the "controlnumber" field on form A to "controlnumber" field on form B. The code I'm using...

Hi all, I have a date field in a report that I would like to populate with the date which is 5 business days from the current date (date report is generated + 5 business days). Anyone have any idea how I would do this? Thanks

Hi all, I'm using the following code to dump a report into an excel spreadsheet: DoCmd.OutputTo acOutputReport, "rptPBC Query", acFormatXLS, "I:\pbcdump.xls", True Since the report gets run multiple times I was wondering if there is a way to insert a time stamp as part fo the file name so...