I am trying to get the min() and max() date of the current query to display on the Page Header section.
I am using Access database for one system, a开发者_如何转开发nd SQL server for another system. The data gets synced between these two systems.
I\'m building an Access database and I\'m getting a \"User-defined type not defined\" error when I compile the project using Debug > Compile, but the database opens and runs without any runtime errors
I\'ve got a MS Access database here that I can open in Access 2007 using a modified shortcut like this:
This is not about coding question. It\'s about Software (Database) Design. Background: My office has a ADP database as front and SQL Server is a backend. There are a dozen of basic standard reports
I\'ve been struggling the last 开发者_运维知识库hours on the following problem, I hope somebody will have an idea... This is a problem of report layout in Access.
Prior to upgrading to Delphi 2010 we were able to extract data stored in a access database string field which actually contains an array of bytes.
I have an append query that is trying to append some records to one of my tables. However, I am getting an error that says “didn’t add 1200 records due to key violations.” 1200 is the total number
This one is stumping me because what I\'m doing seems so straightforward. I have an unbound form (frmAdmin) with a listbox (lstUsers) and a subform that also contains a listbox (lstUsergroups).
I try to create a linked table pointing to开发者_JS百科 Oracle. To make it simple, I \"stole\" the connection string from a manually created linked table that is working well. The code breaks in the A