Search results for query: *

Thanks it worked!!!

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 tried the appending idea but I'm not sure how to append a number to the form name/value. For example, I have objects tltrb1.value, tltrb2.value, tltrb3.value and so forth. Basically I'd have to append the somethign like tltrb(COUNTER).value which doesn't work. Can you show me how to do this?

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

Figured it out. SELECT (mid(DataStuComm.Number, 2,3) & mid(DataStuComm.Number, 7,3) & mid(DataStuComm.Number, 11,4) ) AS newphone FROM Comm

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.

Yes!!! thanks VBSlammer!

I found the form_ method in a program that I'm customizing. The following are equivalent: Form_ApplicationEntry.firstname Forms![ApplicationEntry.firstname]

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'm doing this through a form. I'm just not sure what to put in the field for event/ afterupdate.

I tried option 1, and it doesn't work. When I look at the table the field is blank for one of the fields. How do I do opption 2?

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 am using a connection string from an MDB file. The login capability is important because I'll have over 20-30 users using copies of the file. The connection string needs to have the server name, database, username and password. Any help is appreciated. Thanks!

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 still don't know how to resolve this. Can anyone help?

If its outlook XP, there is no way to get around it. However, Outlook express can be set so that the security message doesn't show up.