Search results for query: *

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)

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

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

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?

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

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