Recent content by bonusmarch

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

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

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.

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.

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

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

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.

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

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

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

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

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

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

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

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)