Search results for query: *

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

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

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

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

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

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

I have been trying to figure this out for hours. Can someone help. I have this SQL statment in Access, and it keeps giving me this error message: Run-time error '2342': A RunSQL action requires an argument consisting of an SQL statement. Private Sub Command2_Click() If cmbBargainUnit.Value...

I have a problem here. I need to compare two tables for related fields. If the fields match, then a field from table1 will copy to the correspondent field to table 2. Table 1 is an update table with changes only to the Update field. The update field has an asterisk "*" in it...

I have 2 questions: 1) I need the vb code or macro which will allow me to open the open dialog window from Access so I can open other documents from excels, words, and etc. The reason I need to do this is because I created a template from MS Word, which will retrive the data from Access table...

I wonder is there a way to delete all the data in the table and then import a text file into that same table without having to use the wizard. The reason I need to do this is because the records in the table always change, and I receive a new text file every week to import into that same table...

I am in serious trouble. Please help. I am working on a database that needs to compare two tables. Table 1 is a repository table that contains all the permanent records. Table 2 contains some records. The two tables should have virtually the same datatype, field width, and etc. Eg: Table...