Determining Actual Running Time Of External Application In Access
May 3, 2014
I want to run an external application (a batch file) ... and want to run it by clicking on a command button on a form. That part is all fine, using the Shell command. I can determine the start time of the application (also fine with now() function) .. but want to find out how long the external application ran and log that "run time" into my database.
The part I don't know about is the .. really the ending time. How do I determine how long the application really ran for / ended ? I imagine I can use datepart to determine the difference in the start and end times. Or would I use a timer control. (but I cannot find the timer control in Access 2010).
I found the way to make my app absolutely (???) secure. But there is one problem I can't find a solution: how to prevent anyone to sneak in my app?Of course it is possible to hide the VBA but I found nothing about the Access objects.
I have an Access application which was written on Access 2.0. I need to run it (as is). I saw that it was possible to run it using some kind of Access 2.0 runtime environment - my client uses the following command to run the application:
Msarn200.exe application.mdb /ini application.ini
Where can I get this MSARN200? Do I have to find the Access 2.0 installation itself?
I have access 2003 and I package my application with Access runtime. Users do not have access installed in their computers.
The problem the users have is, they cannot Copy/Cut/Paste from the textbox controls in the application..The same application when I run using my full version of Access 2003, I can cut/paste...
Is there a way to fix it without having to get full version of access ? or I have to live with it because I use access runtime.
I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is running it didn't close the application ).
What i need is an option to not quit the application completely. As i am not expert in coding of try/catch statements I need a simple solution for time being .
I am having some kind of problem. A query in Acces that is used to find results in the DB is asking 2 time's te input.
And there is no way that the input boxes is asking to do this twice..
here is the Query,
SELECT tblHotlines.Hotlinenummer, tblHotlines.Vestigingsnummer, tblDealers.Postcode, tblHotlines.Datum_hotline, tblBestellingen.Chassisnummer, tblBestellingen.Onderdeelnummer, tblBestellingen.[Uitleverings datum], tblBestellingen.[Vervangende auto ingezet?] FROM (tblHotlines LEFT JOIN tblBestellingen ON tblHotlines.Hotlinenummer = tblBestellingen.Hotlinenummer) LEFT JOIN tblDealers ON tblHotlines.Vestigingsnummer = tblDealers.Vestigingsnummer WHERE (((tblHotlines.Vestigingsnummer) Like [Geef het vestigingsnummer op] & "*") AND ((tblDealers.Postcode) Like [geef evt een gedeelte van de postcode:] & "*") AND ((tblHotlines.Datum_hotline) Like [Geef de datum op:] & "*") AND ((tblBestellingen.Chassisnummer) Like [Geef het chassisnr op:] & "*") AND ((tblBestellingen.Onderdeelnummer) Like [geef evt het onderdeelnr op] & "*"));
Qhat could be the problem that Access is running a Query twice before getting results
hi there, I'd like to ask the solution for my problem. I made a new project using ms access 2003,crystal report 9, and visual studio 2005.
I just made a simple access dbase with 1 table(Table 1) and protected with password, o I forgot this table has 2 field(id and desc). After that I made simple report that using DAO connectivity(save data with report option is disabled).
At last I made simple program(windows app) using visual studio 2005. I put the CrystalReportViewer component, and these is the code :
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms;
namespace prj { public partial class Form1 : Form { public Form1() { InitializeComponent(); }
and the problem is when I move the access database file to other location, the viewer shows a box to be confirmed by my UserID and password, my question is how must I write in the program so that the box doesnt come out.
Something odd is happening here. After I open and close a recently installed .mde application, I open a previously working .mdb file. It now runs exactly like a .mde file with limited menu items, etc. The only way I can get the .mdb file working again properly is to reinstall office 2000. Could it be that the newly installed .mde application is a higher version and therefore, somehow corrupts the mdb application. I need help.
I have a small database application which is split in fe and be. Its running fine and i have been making changes to the front end regularly and replacing the file on server successfully with no problems, But today i edited some forms and reports and afterwards i ran it on a client in access runtime produced the on click event error ( which is on log in form which is a startup form ). Its working fine in full version of access even on the server but couldn't log in because the clicking on login button display the error. See attached image.
it is possible to Open access application like desk application done with java or vb, or install access application as exe or similar methods. My requirements is to giving a access application to customer with data base for printing an invoice. when he running the aplication he can see access open and tables, queries forms left hand. how to hide these thing ?
I am using a web browser control on one of my forms The problem is that when I close my application down, after using the form with the wbc, an access process keeps running in the background. More severe: every time I start my app again and close it, another access process is added to the processes that are already running.
We have an extensive reporting application in Access and would like it to be available through a web application. I've went down the road of migrating this application to SQL to use SQL Reporting Services; this is a good tool but I am wondering if MS Access has an easier solution for me other than migration to SQL.
I'm looking for a solution that will make these reports available over the web for many users. Price tag is a consideration...need to know if there is any.
Please help...thanks in advance for any thoughts!!!!
I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.
The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.
But I don't know why there is a difference in size?
Some of the tables in the database are linked from MS SQL Server.
I'm trying to calculate some running sum queries in preparation for some charts on a report.
I have: tbl: Spencerdaily fld1:datein fld2:milesdriven fld3:vehiclenumberdaily
I am trying to calculate the running sum of milesdriven for each year per vehicle. If I use the following I get the same set of sums repeated for each vehicle:
SELECT spencerdaily.VehicleNumberDaily, DatePart("yyyy",[datein]) AS [Year], DSum("milesdriven","spencerdaily","DatePart('yyyy', [datein])<=" & [Year]) AS Mileage FROM spencerdaily GROUP BY spencerdaily.VehicleNumberDaily, DatePart("yyyy",[datein]) HAVING (((DatePart("yyyy",[datein]))>2001)) ORDER BY spencerdaily.VehicleNumberDaily, DatePart("yyyy",[datein]);
I tried this but it didn't work:
SELECT spencerdaily.VehicleNumberDaily, spencerdaily.VehicleNumberDaily AS vehiclealias, DatePart("yyyy",[datein]) AS [Year], DSum("milesdriven","spencerdaily","DatePart('yyyy', [datein])<=" & [Year] & " AND [vehiclenumberdaily]<=" & [vehiclealias] & " ") AS Mileage FROM spencerdaily GROUP BY spencerdaily.VehicleNumberDaily, spencerdaily.VehicleNumberDaily, DatePart("yyyy",[datein]) HAVING (((DatePart("yyyy",[datein]))>2001)) ORDER BY spencerdaily.VehicleNumberDaily, spencerdaily.VehicleNumberDaily, DatePart("yyyy",[datein]);
I am trying to put together this report where I can see how many hours the printers were running in a month's time. The sum property for this is working up until it reaches 24 hours then it starts all over again. How can I get it to keep adding hours when it gets to 24?
How do you run a procedure that activates at a set time? I want to run a procedure that moves a log file to an archive directory at midnight (or at anytime after this when the PC is next turned on). Thanks for any help... Mat
hey all, I would very much appreciate any help or ideas on how to do this as I am stumped. I need to develop an access database to track documents but also link to them. I’ll explain what it needs to do;
Every day there is a numbered (and titled) Word format document that is sent. Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name. Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls The first would signify it is a Word document by D (being short for Document) and W for Word. The 2nd would be D for document and E for Excel, and then a number which is 101.1.
They are saved in a folder on the hard drive. Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc. There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields. So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content. That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.
All this so far I can do with no problem. It’s this part that’s making me crazy. What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database. That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.
The people that will be using this are not very computer literate to say the least. I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table. Any ideas would be very much appreciated……………..
I would like to link to an external data source (table) from MS Access 2003. I attempt to use the 'Import' feature to do this, and select 'ODBC Connection'. I am trying to connect to an application called 'Action Remedy'. I make the connection fine, but when Access attempts to import the table, it does not like one of the Action Remedy field names, and the Import aborts. The name is something like "Call Status-History.Closed.Time". Obviously, Access does not like this field name. And the chances of getting it changed (on the A/R backend are slim to none). Thus, my question: Is there away around this ?
I have a database that contains a series of tables & queries that feed a formatted Excel sheet(s). The problem is it is not very portable.
It works fine on my local computer, but if I give the database to someone else and when the open the Excel template and try to refresh the data from the database they get an error "could not find file C:documents and settingsusername...
If I make a file for them off of documents and settings with my username and put the database in it, it works fine.
So I guess the question is, how do I change the path in Excel to reference the users computer without re-doing all the external queries?
I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.
I have recently upgraded from Office XP to Office 2007. I had an Access database which worked fine in Access XP. In it I had a table linked to an Excel spreadsheet. When I entered data on an access form, it updated the Excel spreadsheet [source document] accordingly. This does not seem to work in Access 2007. The linked table option now does not permit data entry or amendement. The other "Get external data" options create a table in Access which also does not update my source Excel document. The idea is to enter data in Access using a form. This data is placed in an excel spreadsheet. Excel gets some lookup values, and then enters these in a Word mail merge. Without the functionality of a linked table and data entry, I cannot produce new reports.
I'm looking for a form system that will interface with Access.
At present, we collect information from clients and store it in an Access 2003 database. I have designed my form as an Excel spreadsheet. I use Excel as we are missing the reference files that will enable Access to work with Word and some other programs. The Excel form is emailed to the client, who fills it in & emails it back to us.
To restrict entry of certain fields to a list of values, I use lists in the Excel Workbook, which emulate the lookup tables in Access. I am expecting to add more values to the lookup tables, which would mean that I have to constantly update the lists on the Excel spreadsheet, with the lists eventually becoming quite large.
I have written an import program in Access which imports the Excel worksheet/s into the relevant Access tables. This all works, except the entire process is very manual.
What I would like is to use an external form program that would do the following:
1. Allow me to design something that looks nicer than a spreadsheet 2. Can be updated with my lookup tables so I don't have to manually edit the lists (as in Excel) 3. Can be imported into Access (export to an xls or csv file would be ok if not into Access) 4. Is portable, self-contained & can be emailed to the client so doesn't require them to log into any of our systems, including our web site. The user can fill it out with the data being validated at the same time & then return it to us.
code that will allow me to take data [All Fields] from a Table in my Database and Insert them into another identically structured Table in another MS Access accdb Database.I would also like to filter for records older than a month [MyDateField]
I have tried the following code I found on line. It doesn't throw an error . . . but it doesn't perform the Insert either.
Code: Dim ws As DAO.Workspace 'Current workspace (for transaction). Dim db As DAO.Database 'Inside the transaction. Dim bInTrans As Boolean 'Flag that transaction is active. Dim strSql As String 'Action query statements. Dim strMsg As String 'MsgBox message.
