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: *

  1. bonusmarch

    Retrieve Current Date

    Wow... awesome. The quickest replies I've gotten. Thanks guys. You guys are the best.
  2. bonusmarch

    Retrieve Current Date

    Is there a way I can retrieve the system date and save it in the SQL table? The user supposed to enter the customer info on a GUI form, after the user click submit, it saves the data to the SQL server table and one of the fields is CreateDate. Right now the date is saved as 1/1/1900. I want...
  3. bonusmarch

    Table names end with ;1

    Allow me to clarify the mistake I made. I was just informed that the names with the ;1 extension is not a tablename, but storage procedure names.
  4. bonusmarch

    Table names end with ;1

    Ok, that would explain the 1 at the end, but does it explains why it has the ;1 or semicolon and a 1 attached next to all the table names? But thanks for the prompt reply.
  5. bonusmarch

    Table names end with ;1

    A coworker of mine has an issue with some of the table names in Access 2000. When he opens the database on his own computer, all the table names are spelled out correctly. But when a user open the same database, all the table names end with ";1" without the quotes. Does anyone know...
  6. bonusmarch

    Why am I getting error messages when I visit certain web pages?

    Go to Tools -> Internet Options -> Advanced tab -> Disable script debugging.
  7. bonusmarch

    Object doesn't support this property or method

    I don't have Visual Studio installed, so I can't really utilize the break and step through utilities. I wonder would it fix it if I install Visual Studio on my computer. I figure there might be some additional components added when Visual Basic is installed. Check back with you later.
  8. bonusmarch

    Object doesn't support this property or method

    I checked for all the components and nothing appear to be missing. I tried uninstall and reinstall couple of times w/ eraser97, and still it gave me the same problems. I'm sure to install all the necessary SR1, SR2a, and SR2b. Here is the sample code that causes problems. I doubt it's the...
  9. bonusmarch

    Object doesn't support this property or method

    I checked the list already, but how would I know what is missing. And if something is missing, where do I download the missing components. There are a lot of components included on the list, but only 3 of the components are checked: Visual Basic for Application, Microsoft Access 8.0 Object...
  10. bonusmarch

    Object doesn't support this property or method

    I received this error message when I run a function on my computer. It was working fine before, until I tried to run the database with a different machine. I'm not sure am I missing any dll files or ActiveX controls. Did anyone experience a similar problem? If so how do you fix it. Oh, I...
  11. bonusmarch

    Date

    This works like a charm. Thank you for the prompt reply.
  12. bonusmarch

    Date

    I have a button and a textbox controls on a form. My question pertains to how do I program to make the textbox displays the current date whenever the button control is pressed. The textbox is a reference user used to determine the last update. I want the date to stay static until the button...
  13. bonusmarch

    Search Query

    Dim strSQL As String strSQL = "SELECT RepositoryTable.LastName, RepositoryTable.FirstName, RepositoryTable.MI, RepositoryTable.ReportCode, ReportCode.AreaTitle, RepositoryTable.ClassCode, ClassCode.Classification, ClassCode.CBID, RepositoryTable.Change, RepositoryTable.DateLastUpdate FROM...
  14. bonusmarch

    Search Query

    I would like to know how do I perform a search using query (qryserch). I have 3 fields in the query which I want to perform a search. I have 3 checkboxes correspond to each search field. I also have a textbox which allows the user to type in what to search for based on the selected checkbox...
  15. bonusmarch

    How do i open an existing word file??

    Another method would be to use a Call Shell method if you know the exact path of the application and the location of the file. Example: Call Shell("C:\program files\Microsoft Office\Office\winword.exe C:\classificationchanges.doc", 1)
  16. bonusmarch

    Data Comparison with certain criteria

    How do I come about comparing two tables using either VB coding or SQL. Both tables have the same field names, but the data is slightly different. Table 1 contains record with the full name. Table 2 contains table with the naming fields too, but only contain the first letter for each field...
  17. bonusmarch

    Make-Take

    I need more details in how to clone. Is it possible if you post up an example? I am a new beginner in Access.
  18. bonusmarch

    Make-Take

    I need to duplicate a table in the same database when a button is clicked. How do I code that? Also, is it possible to use the same default name so the query won't have to ask you for the table name everytime?
  19. bonusmarch

    Apply filter to a query

    Hello everyone. I would like to know how do I use the apply filter command or macro. I have a generic select query. I would like to be able to apply filter based on what is selected in the combobox. For example, if the user select 'CA' in the combo box, it will filter out all the records w/...
  20. bonusmarch

    Can someone tells me

    Thanks. That would explain why I keep getting that run-time error message. What I was planning to do was to be able to execute a query with certain criteria attach to it. For example, there is a combo box with numbers A-Z, if someone select A, it will change the Letter field in the query and...

Part and Inventory Search

Back
Top