Recent content by Jimmy211

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...

I've got the same problem with (surprise!) a workbook from the State of Utah dealing with air emmissions. Tech84, did you ever find a solution? Thanks

It worked! Thank you very much RoyVidr! Star for you! Jimmy211

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...

Dwight1, The 1 is the same thing as saying adParamInput and the 4 is the same as saying the type of variable, adSingle in this case. Take a look at the following link. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcstdatatypeenum.asp Jimmy211

dwight1, You probably have it figured out by now but I was wondering about this line where you assign the parameter: Set prm1 = cmd1.CreateParameter(idofcust, adint, adParamInput, 4, Me.Combo8) Is it necessary to set the size of the parameter=4? Parameters I've gotten to work do fine if that...

For anyone who's curious I figured out the answer to this. It turned out to be a dumb mistake. I forgot to append the second to the last prm1 parameter to the proc, the one called LbogId1. The 'cmd1.Parameters.Append prm1' line is missing. Thanks for your help anyway Mr Denny. Jimmy211

mrdenny, Thanks for responding so fast. In my Access code I do add all the parameters in order. Heres the full access code I'm using: Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection Dim cmd1 As ADODB.Command Set cmd1 = CreateObject("ADODB.Command")...

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...

Never mind. I had a network share mapped on the pc to a server that was no longer there. It was taking a long time to try and find it but couldn't. I deleted the link and now the open dialog box works fine. Thanks. Jimmy211

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...