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

Make a copy of your existing subform that you do the review/data entry on. Change the properties on that form to data entry "yes". Place that new data entry subform above your other form. I have not seen another way to do this.

Create a table that has the following fields. EstimatorID and ProjectID you would have a dual PK that would allow multiple Estimators to a project.

I have done this before, All from scratch! Good luck...

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.

Replace that with this.... [Forms]![FRM_PAF_Main]![Combo80] [forms]![the name of your form]![the name of your listbox,cbo box or text field] That goes in your qry and it will look toward that for criteria. Good luck

Do you have an e mail that I could send an example to?

Yes, you can use an update query to take data from one table and update it to another table. You would need a common identifier between the two tables. If you don't can you add one?

That is slick... Thanks

Yes, Go to the query builder for the report, right click on the column named quotenumber and the row named criteria, select build. Expression builder will open up and you are basically going to tell the query where to look for the quote number. Since you said that the quote number is on the...

I have not seen anywhere that you can do this. However if the column widths are fixed, you could type it up and format the column headers in excel, take a print screen, edit in paint and paste the column headers graphic into the page header of the report. It will be static and will take a little...

Yes, I do have access to schedule functions. I think the help I need is creating the stored procedure. Any help is greatly appreciated. Thanks

Open a new DB and select table, new, files of type to exchange, select the table that you want. You may be able to update that link table from the ms access info that you are storing depending on your permissions. Hope this was helpful.

www.fms.com has a ms access database analyzer that is a pretty good tool. From what I remember it shows dependancies in the database. Take a look at the product.

Are you locked into having two tables? If not just have one table with an additional column yes/no indicating if this record in tblPlmkrsDbse is also a "contact". Hope this helps.

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?