Hi, I have a macro that outputs a report to print. I dont want it to output if there are no records, because I dont want to waste paper. Please advise. I am familiar with Access, but do not know VBA. thank you very much, Nathaniel ...
I have a form in MS Access 2007. To change from one inputfield to another the user can use tab or enter. The problem is when the user is in the last field and hit tab or enter she will jump to the next post. But I want to change this so the user jumps to the first filed in the same post or stays in the last field of the same post. Mayb...
Could you recommend a good resource on learning MS Access from the perspective of a developer with a good background in SQL Server. Also some best practice tips would be welcome, in areas such as multi-user access support security; both the database and the front end Access interface (Forms,Reports) deployment Basically if you have ...
One of the best practices as specified by Microsoft for Access Development is splitting Access application into 2 parts; Front End that hold all the object except tables and the Back End that holds the tables. The msdn page links there to the article Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainabilit...
I have some add-ins that are used with an MS Access 2007 .accdb application. When I open the .accdb file --the first time-- (after logging into the PC), the add-ins initialize/load successfully. If I then close MS Access 2007, the second (and subsequent) time(s) I open MS Access 2007, the add-ins do NOT initialize/load. They will in...
What are the strategies you employ to let multiple people work on an access database? Is it possible to host it online and have its features still functional without having to develop a custom frontend? MS Access as a software has a few nice features that don't require any programming to configure: Drop down lists - choose one Multi ...
I don't even know if I am doing this query the right way. There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread). So I made a query that combines all of the comboboxes values into one query, like this: SELECT TypesAndBreads.TBName, TypesAndBreads.Type FROM (SELECT [Sandwiches Types].[Sandwich T...
In an auto-generated chart based on a query (I dragged the chart object onto a blank form to start it), the chart itself is displaying and updating properly, datawise, but I want to change the Legend from reading "SumOfAvgOfield1" and "SumOfAvgOfield2" to regular words suitable for final presentations. But I can't find a way to change it...
Considering the set up: Ms Access Application split into Front End and Back End = both native MS Access Front End consists of forms only - it will be the only way to access data Front End copy distributed to each user machine (thanks for answers to this question) I need to implement the following scenario: Ms Access application wit...
Hi guys, I'm trying to use Access to help me summarize scientific data - temperature and humidity over the past 30 years or so. The databases are quite large - approximately 200 megabytes each. The ideal for me would be to use a pivot table to perform the summaries for me, but I'm encountering the problem that every time I try to modi...
I am really new to programming access. I converted an old 97 access db to access 2007 and it has been working fine for awhile. Today I go into it and was snooping around in design view and looking at the code. I didn't change anything. Just looked. When I went to run the code I kept getting the "Not a valid bookmark" error. Just to be ...
I have a program in access that is using some linked ODBC tables. I had originally had a query that contained the following INNER JOIN: FROM Neptune_FN_Analysis INNER JOIN Neptune_prem ON Neptune_FN_Analysis.PremID = Neptune_prem.premice_id This worked just fine until the column Neptune_prem.premice_id got changed from a number to a...
Warning: I am very new to Access coding. I am used to .NET and PHP I just converted an Access 95 program to Access 2007 and I got it all working now I am trying to make some updates. I have a form that updates a table in the database but I can't find an attached query or anywhere where it actually does a SQL statement. Please help. A...
I have a form which is submitted to a PHP page. The data from the form needs to be added to an Access database, however the website is hosted and the Access database is on a network drive. So for now, the form just emails the data to someone who enters it by hand. We're trying to improve this process. So there is no way for the PHP page...
I've got an Access 2007 database that I developed which connects to SQL Server for the actual data storage. I used the Package Solution Wizard to create a distributable installer which included access runtime (with an ACCDE file) which I went around and installed on 15 or so PCs. Anyway, my question is, what is the best way to distribu...
Objective: The intent of this query is to select all of the distinct values in one column that don't exist in a similar column in a different table. Current Query: SELECT DISTINCT Table1.Column1 FROM Table2, Table1 WHERE Table1.Column1 <> Table2.Column1 Results From Query: What happens when I try to run this query is the progress ...
I have a lightweight app that will use some data. I am trying to decide if I should use XML based or just include a mdb file. ...
Hi Everyone. I have a query in which I need to perform using three entities listed below: LU_AppName SDB_AppHistory SDB_Session LU_AppName has field APPNAM, SDB_AppHistory has the field STARTTIME which is date/time and also SDB_Session has field DURATION. I need to run an SQL query to show me Citrix APPLICATIONS which have not been...
I based my code on the answer to the question Access get all tables, but am getting the following error: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'. (SQL-42000) at direct.pl line 22. [Microsoft][ODBC Microsoft Access Driver] Reco...
I've used the Access 2007 upsizing wizard to move my files to a SQL server. A problem I'm experiencing now is that when I try to link the tables in either Excel or Access, it requires me to create a DSN or a machine data source connection. In either case, when I do this, it makes the connection only useful on the current PC. What I'...