Recent content by dmaranan

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?