ms-access
Access: Min function error on report page header
I am trying to get the min() and max() date of the current query to display on the Page Header section.[详细]
2023-04-10 12:28 分类:问答convert memo field in Access database from double byte to Unicode
I am using Access database for one system, a开发者_如何转开发nd SQL server for another system. The data gets synced between these two systems.[详细]
2023-04-10 09:37 分类:问答Intermittent "UDT not defined" error when compiling VBA but code runs without errors
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[详细]
2023-04-10 09:23 分类:问答Microsoft Access Database: How to Remove User & Password settings
I\'ve got a MS Access database here that I can open in Access 2007 using a modified shortcut like this:[详细]
2023-04-10 07:42 分类:问答Can I use MailMerge and MS Words as Report Generator instead of Access Report?
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[详细]
2023-04-10 04:07 分类:问答Layout hierarchical issue in an Access report
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.[详细]
2023-04-10 02:22 分类:问答Access the true buffer of a record in Unicode version of Delphi - ADO
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.[详细]
2023-04-10 00:58 分类:问答MS Access 2007 Append query trouble
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[详细]
2023-04-10 00:54 分类:问答Write conflict in very simple Access form with subform
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).[详细]
2023-04-09 22:30 分类:问答Access error creating linked Oracle table
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[详细]
2023-04-09 22:16 分类:问答