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 strongm 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: ef61778
  • Order by date
  1. ef61778

    If Else in Crystal 8.5

    I have tried both of these but I get the same error message on both "The result of selection formula must be in boolean". Should I change the format of the field to text?
  2. ef61778

    If Else in Crystal 8.5

    I am working on a If Else where I check if the value is X I show X-Text Here is what I have If {VW_GMAC_CCASHFR_CHECK_STATUS.PMTNUM} = 0 then "0-Shared" This produces an error that a tell me a string is needed. When I place "" around the 0, the report shows no data. How do I check for a...
  3. ef61778

    Mouseover in Excel

    Can there be a mouse over caption for a command button on a woksheet?
  4. ef61778

    Response.Redirect error

    I am trying to retain the values of an input box after I check to see if all required fields have been filled. If they are not, I want to display the data that they have already typed, and let them finish the form. Here is the Code that I have: ... <html> ETC..... <% if Request("error") = "yes"...
  5. ef61778

    Retain values in text box when form is submitted incomplete

    How can I retain the values entered into a text field on a form that is submitted incomplete. The code I have below checks for an empty string and if any if the fields are emply, I Redirect back to the .asp?error=yes page. When there, the required filed that had been entered to are now cleared...
  6. ef61778

    Open Access DB on form load

    CClint- Thanks, it worked out. Thanks for the quick replys
  7. ef61778

    Open Access DB on form load

    Thanks CCLINT for the tip; however, this will not work with the form I currently have. I have a form with 3 buttons. To do a excel transfer to access, I need an opened database. I am using access 2000, which is showing as an unrecognized database. Any other ideas?
  8. ef61778

    Open Access DB on form load

    How would I open and make an Access database visible on form load?
  9. ef61778

    Execute a Make Table Quey in Access from VB

    How would I execute a make table query in Access from VB. I am trying to make a temp table in Access from VB
  10. ef61778

    Converting Date type?

    How would I convert the Date type to format yyyymmdd I have: Dim strCGID As String Dim yyyymmdd As Date strCGID = &quot;DA&quot; & yyyymmdd I would like strCGID to be DA20030926 However I am getting DA12:00AM
  11. ef61778

    How to export access query to .txt

    Here is what I have so far. I saw something like this in Thread709=492487. From that thread however, I don't see how I would create a .txt file form that. Dim intCounter As Integer Dim my_Connection As ADODB.Connection Dim my_Recordset As ADODB.Recordset Dim strConnection As String Dim strSql...
  12. ef61778

    How to export access query to .txt

    How do I export an access query to .txt using visual basic?
  13. ef61778

    open excel file for data import into an access database

    How do I open a specific excel file for data import into an access database using Visual Basic
  14. ef61778

    Open Excel file for import into Access database

    How do I open a specific excel file for data import into an access database

Part and Inventory Search

Back
Top