Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dmaranan
  • Order by date
  1. dmaranan

    stack overflow problem

    Thanks it worked!!!
  2. dmaranan

    stack overflow problem

    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...
    • dmaranan
    • Thread
    • Replies: 6
    • Forum: C
  3. dmaranan

    Connecting to SQL server via another server using ODBC

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

    SQL Array question

    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?
  5. dmaranan

    SQL Array question

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

    Funnel Graph

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

    Phone number conversion

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

    Phone number conversion

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

    How do I use form_ ?

    Yes!!! thanks VBSlammer!
  10. dmaranan

    How do I use form_ ?

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

    How do I use form_ ?

    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!
  12. dmaranan

    Calling Forms with spaces Using the Form_ method in VBA

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

    Access database short-cut script

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

    To fields equal each other

    I'm doing this through a form. I'm just not sure what to put in the field for event/ afterupdate.
  15. dmaranan

    To fields equal each other

    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?
  16. dmaranan

    To fields equal each other

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

    SQL Server Login Form

    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!
  18. dmaranan

    I'm using MS Access as a front end

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

    SQL Server Login Form

    I still don't know how to resolve this. Can anyone help?
  20. dmaranan

    Sending emails via Outlook in my Access DB. Does Outlook have to open?

    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.

Part and Inventory Search

Back
Top