Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nrugado

    Slow Front End Network Runtime Linked to SQL Server

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

    Understanding Indexing Process...

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

    Datasheet data entry line on top instead of bottom

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

    Subform, multiple selections...

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

    How to add speacial feature

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

    Combo Box / Option Visible if Record type is 1 or 0

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

    Query to provide data based on user access level.

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

    Password Field Data Type

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

    Help linking a report to a form

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

    linking two tables??

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

    linking two tables??

    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?
  12. nrugado

    Where table is used

    That is slick... Thanks
  13. nrugado

    Help linking a report to a form

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

    rotate text box

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

    Update a column every Monday automatically.

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

    connecting access to exchange server

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

    Where table is used

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

    linking two tables??

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

    Update a column every Monday automatically.

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

    Stored Proc in .mdb ms access file not project file

    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?

Part and Inventory Search

Back
Top