Search results for query: *

I'm having a problem understanding structs. I've created a struct (see code below) and then when I compile using MS Visual Studio I recieve a stack overflow problem. When I lower the number of items of the array to around 500, it compiles fine. What am I missing here? Thanks in advance...

Hello, I have a SQL Server (MSSQL 2000) whose port is blocked by my IS department, but is accessible through a web server (Adv. Serv 2003). Is there a way to connect to the SQL server via my web server using an ODBC connection? Bacially I want to make ODBC calls from my desktop to the...

I run an SQL from a form that a user can enter 6 different value for 6 different groups. The problem is I have to code the SQL 6 different times, which seems like a waste. Is there a way to use an array that would allow me to cycle through the SQL using some type of counter for each different...

Has anyone ever seen a funnel graph add-on for Excel? The top of the graph would be the total inquiries (100%), then the graph would slim down to Total Apps (32% of inquires), then to completed aps (70% of Total Apps)...etc. Its something like a reversed pyramid, but the area of the pyramid...

Does anyone know how to convert a telephone number in the following format (314)785-1234 to 3147851234 in an SQL query? I tried the format function, but to know avail.

I'm trying to access a form with a space using the form_ method. I know I can do it with Forms!, but I need to know how to do it using the Form_ method. thanks!

Hello! How do I use the form_ method when a form has spaces. Form exmample, I'm writing a code that sets data to a form object. The form's name is Application Entry, and the data is first name. Using the Forms! method this is accomplished by the following syntax Forms![Application...

I currently have an access file (a front end to a SQL server database) on a server that I want 20 users to copy the file over to their machine, and then use their local copy. However, everytime they open the local file I want a script to run that checks the database properties of the local...

I hope that this is an easy question: I have two fields that need to equal each other, i.e. once the data changes in one, the other field needs to also change. (You may ask why not combine the fields; I have no answer.) Thanks for your help.

I'm using MS Access as a front end for SQL Server 2000. I've created a login form that authenticates against SQL Server permissions (created a connection string). When a user enters the wrong username and password I get this error message: Connection failed: SQLState: '01S00' SQL Server Error...

I've created a SQL Server Login form in MS Access. When a user enters the wrong username/paswword I want to be able to pop up a message stating thus instead of using SQL server's error message. Does anyone know how to do this?

As always I am learning VBA as quickly as I so I can fix an application... I'm trying to understand the syntax Currentdb.execute. I have a line of code that says , currentdb.execute "submitDEdata". My guess was that "submitDEdata" was a stored procedure. Unfortunately it...

I was wondering if it was possible to execute a macro right after a merge is executed in Word 2000. Something like a "onMerge" trigger would work. I would I go about doing this? Thanks!

Is there a way to make FM 6.0 a front end to an ODBC database? I can import data with ease, but I'd like to not only import data, but to query, update, and delete records via a FM form.

Is there a utility that converts unix e-mail logins into window's 2000 server logins?

I'm adding an extra processor to a single processor machine and I'm adding 512 MB to an existing 256MB machine. Do I need to make any major configurations on any of the informix files?

Is it possible to run an HP-UX binary on a Linux Intel machine? (I am assuming no, since I've tried.) Is there a way to do it? Will simply recompiling the source code in linux work?

I'm runnig 7.3 and am having some problems with syntax. Here is a foreach in a stored procedure: FOREACH temp_table FOR select... into.... from .. where .. END FOREACH How do I access values from the temp_table in another SQL statement in this stored procedure? I was going to use temporary...

Does anyone know of a way to remove dated e-mail from /var/mail? For example, let's say I want to remove any e-mail older than two months, but keep any newer e-mail. How would I do this?

Here is possibly a stupid question: Is Microsoft Telnet secure? Someone told me it might be possible for someone to find out my username and password unless I use encrypted software. If telnet isn't secure, what do most sysadmins do to access the servers remotely?