Search results for query: *

Hi, This will probably seem like a newbie question to the pros around here, but its stumping me. How do you use a variable in place of a field or table name in Select and Update statements? In my example I want to create a Stored Procedure and pass a field name to it and have it run an update...

Hi, I'm wondering if its possible to use a variable when setting the focus to a particular form and field. I have a table with the name of the forms and fields. Based on the current form that's open and what other forms are open, I want the code to lookup in the table which form and field it...

Hi, I'm having difficulty passing a varchar parameter to a stored procedure in Access. Using VB, I pass the values of a record to a stored procedure in MS SQL Server 2k, which then adds or updates the record in the database. I can get date and integer values to pass to the recordset, but not...

Hi. We are using Peachtree 2003 over a network. I recently upgraded the server to Windows 2003 Server. After doing so some of my users have noticed that when printing multiple checks in Peachtree, the check form no longer remembers the date between checks. That is the check date field...

When I use any MS Office program and open the navigation window to open a file, the 'Open' dialog box comes up but doesn't allow me to use the 'Look In' drop down box to search for a directory. The box freezes up the program which then crashes. I tried repairing XP Office, but I suspect the...

I have a workstation on my network that keeps running some strange startup command I want to track down. When any user logs on, some script runs that opens a folder window that points to c:\documents. If that folder is deleted then an error message comes up. I've looked in the 'All...

Does anyone know if MySql has some sort of agent program similar to MS SQL? Meaning a program that can be set to run code at automatic intervals? Thanks Jimmy211

I'm trying to install the DB2 run-time client tools for DB2 version 6.1 on my new windows 2003 server so as to access a DB2 installation on a NT box. The installation seems to work fine, but when I start the Client Configuration Assistant, it gives me error SQL5001N and tells me the logon for...

My question is about installing Symantec CE 8.1 on a new server. My old server is being retired and I have about 30 clients attached to it. What I want to know is how to transfer the clients from the old server to the new without having to reinstall on the clients. I've done the following: 1...

I have what is probably a very newbie question. I’m using php to query a mysql database and having problems with apostrophes ‘. On my table I have a manufacturer name and a product name, with a given manufacturer having multiple products. I first run a select statement to get the distinct...

Hi, I'm trying to use the "SELECT TOP nn" statement in a DTS transform data task and getting an error. The code I'm using is: SELECT TOP 50 "TMS"."XACSTAT"."XACNUM" FROM "TMS"."XACSTAT" The error message I get is: SQL0104N An unexpected token "50" was found following "SELECT TOP". Expected...

I’m getting a little frustrated with DTS. After 4 days of trying to solve what I think should be a simple problem, I’m ready to show my ignorance and see if someone here can help me. The problem: I have 2 servers, MS SQL Server and DB2. I’ve set up a DTS package that will update tables in my...

In MS Access is it possible to have two forms open at the same time, one maximized and one not maximized (ie restored)? What I'm trying to do is have a main form that will be my background, and other forms that will sit on top of that one. If I use the docmd.maximize command when opening the...

I have a quick question about Access forms. Is it possible to add a menu to an Access form? So that you can have drop down menus like "File", "Edit", "Help", etc? Visual basic has a great tool to do this but I can't find the equivalent in Access. Thanks in...

I'm wondering if anyone has had this problem before and what the cause might be. I'm using MS Access as the front end for an SQL database. When I open a table up in design mode and delete a column, save the table, then try to open it in datasheet mode I get an error telling me that Access...

Hi. I’m fairly new to using SQL server with Access and have a question about opening forms. I have two forms, one that is used to set criteria for opening the second form which views the data. The startup form is called frmGaugeStartup, and the main form is called frmGaugeLog. I want to use...

I have two forms (Form1 & Form2) linked to two separate tables (Table1 & Table2), respectively. The tables are linked in a one-to-one relationship based on Table1's primary key. My intent is to have a record be required for Table1 and optional in Table2. I have on Form1 a button that opens...

I'm having a strange problem with Access 2002 and was wondering if anyone else has run into this. I have two tables linked with a one-to-many relationship that I need to import data into. One is a Bill of Ladings header table and the other is the BOL detail table. I've used 2 append queries to...

In a Purchase Order database I have 2 forms, one is my menu and one is a data entry form. On the Menu I have a button that uses the openform method to open the data entry form. I would like the button to prompt the user for the PO number to look up that PO. The following code seems to work...

Hi, I'm trying to get an access query to return records based on either one field or another field but not both. I've set up a form for the user to enter data with an option box with 2 values: if the user clicks the first option then a combo box with the values is enabled, if they choose the...