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: *

  • Users: sara82
  • Content: Threads
  • Order by date
  1. sara82

    Could not update; currently locked.

    I have a main form and a subform. The main form is bound to tblNumber and the subform is bound to the table tblItems. There is a one to many relationship between tblNumber and tblItems I have about 6 users who constantly need to add records into the form/subform. The users can enter data in the...
  2. sara82

    Form opens to records only for specific user?

    I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked...
  3. sara82

    Exclude Certain Times?

    I have a form which has a Start Time and End time and Log Hours. Log Hours is calculated as follows: [LogHours] = Round((DateDiff("n", [Starttime], [Endtime]) / 60), 3) There are two 15 minute breaks throughout the day. One at 9:45 AM to 10:00 AM and one at 2:45 PM to 3:00 PM. What can I...
  4. sara82

    Dates in a Query

    Below is a visual picture of what's going on: Two crosstab Queries one that calcuates the Sum of Total Hours employees worked for each Job Type and the other calculates Sum of the Total Pages worked for each Job Type Then I have a select query that includes both the Sum of Total Hours and Some...
  5. sara82

    Tracking a Person's Work?

    I'm undecided in what I should to to track what an employee does for the day. Currently employees have a 5X7 index card which printed out fields and they fill it it by hand and turn it in. Instead of the employees doing this I want to record all of this information in the database. These are...
  6. sara82

    CrossTab Query & Dates

    I have a crosstab query with the following columns which calculates the number of days an employee took to perform a task. Field: LogDate Table: tblWorkLog Total: Count Corsstab: Value Is there anyway to exclude weekends and holidays from the value? I have a table, tblHolidays, with the...
  7. sara82

    Database not opening

    Hello, I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs...
  8. sara82

    Custom Navigation Buttons

    I have disabled the navigation buttons that access provides to you. I want to create my own navigation buttons for: Next, Previous, and New. I also ant to emulate the Record 1 of 4 in a text box. Any help will be greatly appreciated. Thanks
  9. sara82

    Cannot find file name error message

    I had multiple frame files residing in a folder named Templates. Someone renamed the folder to FrameMaker Templates. Now whenever I try to open a frame file it tells me: Cannot find the file named P:\Templates (This is the old directory they resided in. These templates are on a server and I...
  10. sara82

    Using Access's User and Group Accounts or Using a Login Form to access

    Using Access's User and Group Accounts or Using a Login Form to access database? I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself. I also saw some sites where they give an...
  11. sara82

    Combo Box to make Other Text Fields Visible

    I have a combo box, Products, which lists: BASIC CHG CONV NAT OS REV SP SS SUP TP I have 5 text fieds which are: BasicThrough, ChgNo, SuppLetter, RevNo, TPNo. The Visible property of all of these text fields is set to No. If the combo value "Basic" is selected then I want the BasicThrough...
  12. sara82

    E-mail Attachments

    Is it possible to attach an email in a field of a form? We have a database that keeps track of technical orders. We get e-mails on what we are supposed to implement on a particular tech. order. Is there anyway I can attach or make a copy of this email or something to have it in a field of my...
  13. sara82

    Importing Data into Linked Tables?

    I'm trying to perform a massive data dump. I have about 1,000 records that need to be added into my database. This is coming off an Excel spreadsheet. I don't know if this is possible: I have a table, tblTorders, which is linked to the table, tblItems. When I open the tblTorders, I can click...
  14. sara82

    Unrecognized Database Format

    Hello, I had a database on a server. The server went down. Now when I attempt to open the database I get the following error: Unrecognized database format 'S:\6277_Database_Tracking_Log\6277_Database\Scann ing_Database.mdb. Is there anyway I can recovery this database? I do not have a...
  15. sara82

    Adding Media?

    Hello, We have Backup Exec 10.0 for Win 2000 Server. Yesterday we added about 5 tapes in the tape drive. Veritas doesn't seem to be recognizing the tapes that have been added. We tried importing them but that wouldn't work. We created an inventory job and it inventoried the 5 media tapes and...
  16. sara82

    Combo Box to List Box

    As you can see I have a form which filters reports according to what is input into the form. I have a combobox: Product Directorate. When the user selects a Product Directorate, the report will run showing the info for that particular Product Directorate. This all works fine. I wanted to...
  17. sara82

    Calculating Number of Work Dates From 2 Date Fields

    In my Query I have a Date Received field and a Date Approved field. I would like to calculate the number of work days, which excludes weekends, between Date Received and Data Approved fields. How would I go about doing this? I would need to add a new column to my query? What would I put for...
  18. sara82

    AutoText Entry not working?

    I have MS Word 2003. I want to create an autotext entry for (U) with the name unclassified. When the user starts typing the word unclassified I want it to return with (U) So when the user starts typing unclas... I should get a autocomplete tip that appears and when I press enter I will get...
  19. sara82

    Most efficient way of limiting data in fields.

    I have posted a question earlier about limiting date in a field. I have 3 date fields Date Delivered, Date Received, and Date Approved I began using (Between [Enter Date Delivered Start Date] And [Enter Date Delivered End Date]) Or [Enter Date Delivered Start Date] Is Null Or [Enter Date...
  20. sara82

    Using parameters to limit a date field in a Query

    I am limiting a report to a date range using parameters in a query. If the user, for instance, wanted to display all the dates.. when the parameter pops up asking for a start date, the user will not enter anything and just click OK, when the parameter pops up for end date, the user will not...

Part and Inventory Search

Back
Top