Save Not Available at this time
Thu, 8 Dec 2005 09:41:02 -0800
I have a form with a subform in it. The main form is the customer header
info and the subform is the line-items. After the user enters the
information on the subform, they click a save button on the main form. Which
triggers the command :
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acM ...
|
Can't Paste Record With SQL Server Backend
Wed, 7 Dec 2005 10:31:03 -0800
Anyone got any idea why i can't copy and paste a record either in a form or
datasheet when the table is in SQL Server? The Paste commands are also greyed
out on the Edit menu drop down. Thanks. ...
|
Windev *.fic
Wed, 7 Dec 2005 17:58:23 +0000 (UTC)
I have a client who uses the French La Poste service for parcels, this uses
a program written using Windev with *.fic tables.
I have written a sales/stock control program which requires entry of
customer names and addresses. It would be far more efficient if addresses
were only entered once.
Does any ...
|
SQLTables doesn't return data for an Access database???
Tue, 06 Dec 2005 15:40:25 -0600
I hope this is the right newsgroup. I have some ODBC code that I'm
testing against various underlying databases. The code was developed
against MySQL but now I'm getting other common options to work.
My setup: Windows 2000 running Access 2000. Using ODBC to read the local
Access db.
I'm using SQLTabl ...
|
Access Front End Form/Subform issues with SQL Tables
Tue, 6 Dec 2005 07:31:04 -0800
I recently completed a project in Access that uses Froms and Subforms without
any issues. My boss now wants the data to sit in a SQL dB and still use the
Access forms to add and view the data. I moved the data to SQL and set links
up through ODBC in the Access front end. I have an order entry form that
...
|
Create Table binary fields
Tue, 6 Dec 2005 01:00:26 -0000
I can create a Jet database with a table that has a binary field using
something like:
CREATE TABLE myTable(myBinaryField BINARY(255))
The call fails if a number larger that 255 is specified.
If I create a database with Access, I can specify an OLE field in the table
designer and insert and select that ...
|
2003Access, ODBC to SQL and "manipulate"...
Mon, 05 Dec 2005 09:41:00 -0800
Hello,
I confess a lack of SQL knowledge but I can read and learn.
I have a "production" database (currently using MS' old Solomon
interface to a SQL2000Srv) that I need to export data from (and
could use DTS I suppose, but we need to access the data over the
next few weeks "almost" daily and Solomon doesn't ...
|
|
|
Linked Tables in Access 97
1 Dec 2005 08:45:43 -0800
Hello -
I am trying to link tables in Access 97 and I have just installed
Oracle 9i. When I finish installing I attempt to link the tables and
am successful. Then, when I turn the computer off and then back on
again I try to re-link the tables and I get ODBC call failed error but
it won't tell me anything ...
|
Linked Tables to SQL-Server
Thu, 1 Dec 2005 17:27:22 +0100
I have a very strange special effect (I mean an error situation) on some
PCs. We have an Access 2003 project (a normal mdb-File, which is to be
understood as the main application), and as a backend we use SQL-Server
2000. The mdb created (with VBA) Links to Tables of SQL-Server, with the
following code (fragme ...
|
How to make attached SQL Server table read-only?
Wed, 30 Nov 2005 13:46:08 -0800
At the SQL Server database, the users have full add/delete/edit permissions,
but I need the tables, when attached to an Access database, to be read-only.
How do I do this?
I'm attaching the tables in code using DSN-less connect strings -- don't
know if that matters or not.
...
|
