I have a form with combo box and two subforms in it - combo box allows for selection of customers and is used as link field fo on first subform (in datasheet view) - ORDERS. Selected order se...
Hi,
we just migrated a sql server db on a 64 bit sql server machine and our openqueries to an oracle database return the error Invalid data for type "numeric"
The query is as simple as th...
I am developing a Microsoft Access 2007 "project" (.adp) as a front-end to a Microsoft SQL Server 2005 Express database.
I offer my users a "Filter Form" in Access with which they can choose ...
In an Access database project form I have this little piece of code
DoCmd.SetWarnings False
DoCmd.Close acForm, "View_Edit_Tree"
DoCmd.SetWarnings True...
I have developed many applications using Visual Basic 6 /SP6 running successfully using an Access 97 under Windows XP Professional SP2. I need to convert to at least Access 2003 now.
I real...
I have inherited this app -
Access adp file runs on the network, calling machines run either Access XP or 2003.
Form is bound to a table in sql 2005 express.
I have added a stored procedur...
I can“t open several of the SQL Server tables from my Access project. Trying to open these tables first results in the message: "The stored procedure has been executed but did not return
an...
I have a Access 2007/SQL 2007 ADP database. I have just written a stored procedure to execute a Pivot query which is working fine. I now want to save the results from the stored procedure pivo...
For starters, this is a relevant piece of the layout of the database (running on MS SQL 2000 server):
Tables:
Inventory: (Item ID, Type, IT_TAG, InUse, etc...)
HardwareType: (Type)
Prin...
I have a file that gets delivered to us every day in a text file that looks like this.
75734||Danny|123123|R|2, 34, 12|27/10/2007 15:16:42|errorsoccured
I need to import this file into a...
I have created a rather complex db with many forms and subforms. After splitting it and trying to use it over the network I noticed that a major slow down.
I run MS Access performance analy...