Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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