I have realized that my first question won't be answerable, since php can't deal with this format: http://stackoverflow.com/questions/1376103/how-to-convert-metafilepict-to-bitmapped-image-in-php, so I have a C# console application that will just load up the images, from either an MS SQL 2008 db, or Access 2007, and then save them to a d...
Hi all, I need to compact and repair an Access 2007 .accdb database file. I know that JRO.JetEngine can do this with .mdb files, but I need to repair the newer version 2007 format by code. Any suggestions? EDIT: Here is the thing: I found that I can use the COM object library "Microsoft Office 12 Access Database Engine Object Library...
Hello! Creating a mini-database with access, i came across this problem: For the background, i have two tables: Table: Items and Table: Actions ID(PK) Name ID(PK) Name ------------------ ---------------- 1 Thing1 1 Move 2 Thing2 2 Delete 3 ...
When you attach a SQL Server view as an MS Access linked table, you are asked for a unique identifier. During recent trials, I noticed that on several occasion, NOT defining the unique identifier has the effect that the linked table opens much more quickly (you don't need a stopwatch, you can really SEE it). So I am asking the experts...
It would be nice if there was a right-mouse-click menu on the edit panel to change the font size, but there isn't. Is there a system setting somewhere else that lets me increase the default font size? ...
I need to be able to read a combo box to determine to column to use for a where clause. Simple example would be SELECT * FROM TABLE WHERE [Forms]![frmNameWhatever]![ComboTime] BETWEEN [blah]![blah]![blah] AND [blah]![blah]![blah] blah blah blah works... The first part, right after the where, returns zero rows... Am i using the wrong syn...
I have the following query set up, in various incarcerations, to remind me of contract expirations 0, 7, 30, 60, and 90 days before the confirmed expiration date. My method of calculating the notification date doesn't give me any flexibility. For example, say I have 30 contracts expiring 12/5, a Saturday when my office isn't open. I w...
Every time I try to run a Wizard in Access 2007 a dialog box pops up saying the following: The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should bac...
I was wondering if there was any way to implement the date picker in Access 2007 as a control in the ribbon. I've already created a custom tab for the ribbon that replaced my main form, but since almost all of the application's functions depend on a start and end date, I still need the user to be able to input these somewhere convenient...
I have a table with multiple date columns per employee: Emp 1, Date1, Date2, Date3 Emp 2, Date1, Date2, Date3 etc. I would like to write a single query that returns to me the maximum date of the three dates available on a per-employee basis. I understand I need to write a UNION ALL query but I can't seem to get the syntax so t...
BACKGROUND: I have an Access 2007 application, with a form which builds a Filter string to pass to a Report, which uses a stored query. In Access Options, I have "SQL Server Compatible Syntax (ANSI 92)" checked for This database, and the Filter string includes a LIKE clause with % wildcard characters. ISSUE: Randomly when I save or...
I need to use rich text formatting for a field in a report in MS Access in order to use character spacing. In the report, attempting to change the Text Format in the field's properties from Plain Text to Rich Text Produces the error: "The setting you entered isn't valid for this property." I presume that is because the field is not a mem...
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by the way Access does it. Therefore I want to make my little piece of code to list the macros, their instructions list and parameters to the de...
I am trying to hide specific columns in an Access 2007 split form through code. I need the form to check certain conditions to see whether it needs to display a column or not. I have code in the form's 'Activate' event to hide the column like this: txtControl.ColumnHidden = True This code works in the "Open" event, but if I hide the c...
It didn't always do this, but ever since I split my database and made the front-end an ACCDE file, any time I try to compact and repair either file, a new file called "Database 1" is generated and my original file size doesn't change. Is this normal? My ACCDB is roughly 20MB, and my ACCDE is just over 1M after being used the first time...
I have inherited an Access 2007 database that has been split so the tables are on a SQL 2005 server. The database consists of 3 tables and 3 forms. The main form that is used reads and writes to all 3 tables. Data can be edited and deleted OK but trying to add a new record throws an error saying, "You can't go to the specified record"...
I'm using Visual Studio C# 2008 I've created (visually) a dataset that points to a mdb file (Access 2007) This DataSet is called "EstacionarDataSet" EstacionarDataSet ed = new EstacionarDataSet(); DataRow newRow = ed.Tables[0].NewRow(); newRow["patente"] = tb_Patente.Text; newRow["numerobox"] = tb_Box.Text; newRow["fechahora_ingreso"] =...
Setup: One table called documents with columns author_id and reviewer_id (among others). One table called users with column user_id. I need to create two referential integrity links: One-to-many between user_id and author_id. One-to-many between user_id and reviewer_id. In other words, these two columns in documents are independent of ...
I am currently "forced" to create a database in ms access 2007. Due to replication issues i have decided to use autonumber as ReplicationID for my Users table. On my venues table i would like to use this id as the user created. I have tried to use the userID in textboxes accross the main form, but it outputs {guid {BF40D0A0-A1F3-4C9...
I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can't figure out how tho show the dialog window. Do you? ...