I'm developing an application in Access 2007. It uses an .accdb front end connecting to an SQL Server 2005 backend. I use forms that are bound to ADO recordsets at runtime. For the sake of efficiency, the recordsets usually contain only one record, and are queried out on the server: Public Sub SetUpFormRecordset(cn As ADODB.Connection...
I wrote a program that connected to a Microsoft Access 2000/2003 mdb file and accesses the data. It works fine, but I'm wondering if there is a way to connect to Access 2007? If I change my connection string, will my program work with access 2007 or is it more complicated then that? And if it will work, can someone provide an example of ...
I need to version control a Microsoft Access 2007 database and application. Currently everything is contained in a single mdb file. The application includes: Forms VBA code Actual database I would assume I need to separate the database from the forms/code. I would like to be able to version control the forms/code as text to support ...
I have an Access 2007 database that works asynchronously with a MAS200 database. Due to various office politics and red tape, I cannot get access to the MAS200 data, even though ODBC makes it easy, and must import data dumps from MAS200 to Access. Because of this and the way reports are run, I occasionally have duplicate data on a dump...
Hello, I have just finished importing an ACCESS db (back-end) to a SQL Server 2008 db. My front-end is still ACCESS 2007 and the back-end is SQL Server 2008. What I've realized is that if I open a form (on a certain record) and then do some calculation which is supposed to fill in some text fields automatically on that form (for that rec...
I have a query in VBA that Adds a few columns to a table. How can I change the format of the PercentSuccess column to Percent using SQL in VBA? Here is the code I'm using to add the columns. strSql5 = " Alter Table analyzedCopy3 " & _ "Add Column PercentSuccess Number, Success Number, prem_addr1 TEXT(50) " DoCmd.SetWarnings Fals...
I'm trying to split a database into two pieces -- a backend that updates automatically, and a front-end that allows searching and adding/editing comments. The data in the source database is pulled together from multiple tables into a pair of queries, and I want to use these queries as the source of the current database. Access 2007 s...
I am designing a small Access 2007 UI with SQL Server tables. I have a subform on my page, which is a datasheet. For every parent record selected (say table A, and table B has a foreign key of table A) in the form view, I want to write out every related record in the datasheet. There are 5 customers. Each has several orders. You can br...
Background info: I was handed a "Tool", which was made using MS-Access 2007, and asked to add some things... The tool is basically a collection of options for querying a database. On a form titled CreatedReport there is a listbox that is bound to a table called analyzed which has all of resulting data from the query/queries that ran. The...
I'm trying to input ColumnWidths for a listbox in MS-Access2007 VBA and I'm having a problem getting it to take decimal numbers. Code: ResultList.ColumnWidths = "1;0.65;0.7;0.7;0.8;0.4" Debug.Print ResultList.ColumnWidths What gets put in for the ColumnWidths: 1;1;1;1;1;0 The way I want to get it to look after entered (based on w...
We're using MS Access 2007 as our DB and should support users with limited access (power users): The DB should be common to all users (hence cannot be located on user's private folder) We are not allowed to grant permissions for all users for R/W for a certain directiry Yet we need all users be able to use this DB. Can anyone can thi...
There was a problem with DAO 3.6 in that it didn't support row-level locking. For details, see this Knowledge Base article. I learned from the Access team's blog: In Office Access 2007, new objects, properties, and methods will be added to DAO to support the new features in the Access database engine. From looking at this li...
I have multiple sets of code I need to run in Access 2007 and I have been trying to see if it would be acceptable to run them at the same time. Each set of data I need to have my Access VBA code run through takes about 5-8 hours to run. Would running them two at a time or all at once cause any problems? They are each self contained and...
I have made an Access 2007 db. I will be writing some basic vba for the appropriate event of a form so that a modal form is displayed when the original form is opened. This isn't difficult, but that form will have a drop down box of IDs from a particular table. The user will select an ID, but I want the selected ID from this form to go b...
I have an INSERT query that is pulling data from two tables and inserting that data into a third table. Everything appears to be working fine except that the COUNT part of the query isn't returning the results I would expect. The first set of tables this query runs is MIUsInGrid1000 (number of rows = 1) and Results1000 (number of rows ...
I have programmed an Access Database program using Access 2007. I have a button that points to the event: DoCmd.SendObject acSendReport to have it email a PDF report (acFormatPDF). Everything works fine in the normal Access 2007 program, but when a user opens the program with Access 2007 Runtime, when clicking on this button it goes thro...
Is this another MS Access 2000(2007)-ism? If I type the following: foo = blah + blah - bar the editor automatically reformats it as foo = blah + blah - bar But I type: Dim foobar as long the editor doesn't reformat it at all. Some how I expect it to reformat it to Dim foobar as long Did it always work this way (I ha...
Hi, Can anyone tell me how I can show the full screen on a Form in Access 2007 so that there are no Toolbars etc open, so no one can tamper with anything ? Cheers, Nick C ...
Problem: I originally had a query that was working great but I'm now having to change it to pull more fields. When I try run the new query it picks a field name and says that I haven't included it as part of the aggregate function. Each time I get this error I can add the field the error specifies to the Group By statement and the error ...
I'm trying to run code that will copy fields into a new table, moving them from a _New table to the original table. The VBA code that does this works as such: SQLStatement = CStr("INSERT INTO " & TName & " SELECT * FROM " & TName & "_New") Log.WriteLine "Running query with string """ & SQLStatement & """ " QueryTimer = Timer DoCmd.RunS...