Search results for query: *

Help... over the past few days my database has intermittently slowed down. Sometimes it is Fast… sometimes it is slow… I have a front end that is placed on the network and an icon that is linked to that front end that starts up the database. It links to a SQL server back end through an odbc...

I have set indexes on several columns/tables through out my database when I designed it. The one thing that I am not sure of is, as data is added does sql server keep track of the new data and reindex the data as it comes in or is this something that needs to be performed as a task later...

Hello all thanks for looking at this... I want to generate a list of questions that will be answered in a form and be given a value if the user selects from the combo box or the options box. However, I do not want both the combo and the options box to be *Visible*. I want the control to match...

I have a table that has attendance records in it. At this point managers can go in and modify a record from a year ago. We want to lock this down to absences within the last week for management and all records for HR. I have an existing form that uses a date listbox. I am thinking that I can put...

Working on Learning and Developing a website. I need to know what datatype to use for password. The front end will be php and I want the password to be encrypted. I will look into the encryption later, at this point, I just need the datatype.

I have an access front end tied to a sql back end db. I have the need to update a column on any row that equals 0 to the value of 1, and have sql server update this each Monday. Any help would be greatly appreciated. Thanks Table name: employees column: reportmarker

I know that you can run Stored Procedures from MS Access Project. Is there any way to call them from the standard MS Access MDB file?

Per a previous posting I was given this code to insert into the on current of a sub form. When I click on a record in the list with a value of 1 the buttons disappear, when I click on a record with the value of 4 the buttons appear. The problem is that the buttons are appearing for all of the...

I would like to have a command button that is visible only when the value in a list box is =1. When it is anything other than 1 I want the command button to be invisible. Is there an easy way to do this in VB? Anyone have any sample code? Any help would be greatly appreciated. Thanks Nick

Does anyone have any experience with some 3rd party software that will document a SQL server database? I am looking for a good and inexpensive tool. Any Suggestions. Thanks Nick

I have a form that reads all of the records in an employee information table. There is a combo box that selects the record of the employee that is selected. The Combo box also filters out via a qry what positions a user has access to. The problem with this is that all of the records are in the...

Hello, I am migrating an ms access db to SQL server. The fields that automatically stored the date in access have been changed to smalldatetime or datetime format. I have several instances where I am using a list box to select the date for criteria in a query or using a manual data entry for...

Hello, I am migrating an ms access db to SQL server. The fields that automatically stored the date in access have been changed to smalldatetime or datetime format. I have several instances where I am using a list box to select the date for criteria in a query or using a manual data entry for...

I have some field level default values that were in my MS Access Tables. I am now entering those into the field level default values in the SQL tables and I am getting errors for a few of them. They have to do with the smalldatetime field and me trying to use Date() and Now() as I had used...

I have an access database that I have converted the tables to SQL Server. I am now in the process of changing some field types and have noticed that the default value field that was populated in MS access is not Populated in the SQL server Tables/Fields. Does anyone know where to get this...

I have an access database that I have converted the tables to SQL Server. I am now in the process of changing some field types and have noticed that the default value field that was populated in MS access is not Populated in the SQL server Tables/Fields. Does anyone know where to get this...

Does anyone know specifically how linked tables communicate between the two .mdb files? Is this accomplished via ODBC or some other access specific protocal? Thanks Nick