If a table has a concatenated primary key (Col_A, Col_B) and is a clustered index where each column is a foreign key from another parent table, would it be necessary to create nonclustered indexes on each individual key (one on Col_A and another on Col_B)? Or, would SQL Server use the clustered...
I am trying to insert a Word 97 document into an Access 97 Bound Object frame. I have an Access table into which I can successfully insert the Word doc (OLE field). The frame is bound to the table which contains the doc. When I run the form and then go to view the Bound Object Frame, the Word...
I have this VBA Code to run and script SQL Server jobs on my local machine. How can I modify it to connect to a network SQL Server from my workstation and script the jobs on the network SQL server? I do have Administrative permissions. I know I need a connection string, but I dont have much...
I recently made use of code that uses a Word Application to check the spelling of the labels on each of my Access forms. I open an instance of Word to run
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = False
I then cycle through the forms and label controls and use...
Access 2000 Reports can include Excel charts. Open the report in design view, select Objects from the Insert menu and choose Microsoft Excel Chart. Edit this chart like you would in Excel.
I would like to capture Processor information on each PC in the local network into a database for reference. This is part of a script to output information in the cmd window (for now it is fine) but only for the local machine that the script is run. Is there a way to access the network PC's...
Question:
If I have a stored procedure that runs behind a spreadsheet, how can I enter values into specified cells and the stored procedure will use those values as its parameters. I would like to do this to avoid having users edit the parameters in Microsoft Query directly.
bbitzer@computer.org
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.