Hi all, I have an access report that has two grouping levels, for the most part it works great, but occasionally the detail is too long and the final total prints on a page all by itself. The client would like to move the last detail record to the next page when that happens so the total is not by itself. I know in other reporting to...
Using Access 2003 Database Table EmpID Intime Outtime 001 090020 180000 002 060000 220000 003 030040 231020 So on…, InTime and Outime Column Data type is Text. 090000 - hhmmss Here I want to calculate the time like 090000 to 180000 is the office time, Remaining time is over duty time. Expected Output EmpID Intime O...
I'm trying to open a series of Excel spreadsheets using an instance of Excel created inside of a module in an Access database. I can get the files to open properly; however, the actual call to make Excel start takes quite a while, and to open the files takes even longer. The location of the files doesn't matter (same time to open on a ...
Right now I am working on a new database that will show changes to one of our manuals that people request. I have two tables and one form. The first table is were all the information will be stored from the reference or subchapter of the manual, the current text in that subchapter, and what the proposed changes are. The second table i...
My two tables are titled analyzed and analyzedCopy3. I'm trying to put information from analyzedCopy3 into multiple columns in analyzed. Sample data from analyzedCopy3: readings_miu_id OriginalCol ColRSSIz 110001366 Frederick Road -108 110001366 S...
I have to document an MS Access database with many many macros queries, etc. I wish to use code to extract each SQL query to a file which is named the same as the query, eg if a query is named q_warehouse_issues then i wish to extract the SQL to a file named q_warehouse_issues.sql I DO NOT WISH TO EXPORT THE QUERY RESULT SET, JUST THE S...
My Application (Vb.net, Access 2003/2007) is to scan Access Database files for activex controls and to generate report accordingly. Problem: Getting an error like: "Insufficient memory to continue the execution of the program." The above error occurs while scanning for older version of Access files like prior to office 2000. And th...
I have an MS Access database that has Full paths to files in a table. We are moving all the file to a different location. I need to update the database. I'm using C# to do this. When I search for the file path stored in access it searches for 'K:\PDFFiles\myPDF.pdf' instead of 'K:\PDFFiles\myPDF.pdf' and does not find a match. So, my que...
In MS Access, is there a reason to prefer conditional formatting over setting formatting options with VBA? Is one more effecient or generally considered easier to read? ...
I have developed an network application that is in use in my company for last few years. At start it was managing information about users, rights etc. Over the time it grew with other functionality. It grew to the point that I have tables with, let's say 10-20 columns and even 20,000 - 40,000 records. I keep hearing that Access in not g...
In MS Access 2007 (using Access 2000 format) I am attempting to get a boolean output from a query such that the result is displayed as a checkbox rather than 0 or -1. When the query is passing along a boolean input, this is working properly. When I attempt to make an evaluation, the result is 0 or -1, but not a TRUE/FALSE checkbox. I ...
I have a large complex multiple table in one database that customers use with a FE/BE link over some LAN networks which occasional corrupt the database I was wondering if grouping the tables into separate multiple databases and using separate links would help limit the damage? Note: I have no control over customers network quality and ...
I am trying to get the top 2 results per day, where the "top" results are the rows with the highest "MPR". My table looks like this: date symbol MPR 8/7/2008 AA 0.98 8/7/2008 AB 0.97 8/7/2008 AC 0.96 ... 8/7/2008 AZ 0.50 8/8/2008 AA 0.88 8/8/2008 AB 0.87 8/8/2008 AC 0.86 ... 8/8/20...
A friend asked for my help putting together an Access database for a small department at a university. It tracks medical info on some animals. The problem is that to make the application easy enough to use, we had to write some VBA code to glue different forms together. When we open the database (or a new, updated version of the database...
Using Access 2003 Table PersonID TotalHours 111 12.23.34 111 23.32.23 111 14.32.23 222 00:23:32 222 01:00:00 So on…, TotalHours Datatype is Datetime Query Used. Select Personid, sum (TotalHours) from table group by personid. It Showing Personid TotalHours 111 4.30842592592593 222 7.93241898148148 so on..., I...
i’m wondering if it’s possible to load code from an external file to be used in ms access. this is important to allow easy development using version control—.mdb files are impossible to version control. ...
I am trying to find the blank values and null values in a table. I am using Asc to assign the values of the table to a variable and then based on their ASCII values differentiating null and blank. But I am getting "runtime error 94: Invalid use of null" when the code tries to read the ASCII value of a null field. ...
Using Access 2003 Table ENO Time 001 020000 001 040000 001 220000 002 030000 002 050000 005 230000 So on…, Time Date type is Varchar in the Database. How to convert a Varchar into Datetime? Here I want to get a total of time for the ENO. Select eno, sum (time) from table group by eno It showing error like – data type mismatch c...
Using Access 2003 Table EmpID Value1 Value2 001 100 001 300 001 200 400 001 300 001 250 001 200 400 002 100 002 100 200 003 500 100 003 003 700 003 So on…, I want to count (value1) and Count (value2) is not equal to null. Expected Output. EmpID Value1 Value2 001 4 4 002 1 2 003 ...
I have a weird problem here. In short to the environment we have: There is a (newly set up) Win2003 Server with a SQL Server 2005 Express database. I connect to it via a MS Access application. Since I switched to the new server (restored a backup from the former server on it) all SPROCs (only in Access) have a ;1 after their name, he...