Search results

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 am having trouble with the query producing the correct Dates. I have the Log Date Field and for the criteria I have: Between Nz([Forms]![frmDate]![txtStart],[LogDate]) And Nz([Forms]![frmDate]![txtEnd],[LogDate]) When I run the query it asks for Forms!FrmDate!txtStart I enter 10/1/05 It...

I have a report that once clicked a form comes up to choose the dates one would like to filter by. It has a Start Date and End Date. After the user picks the Start Date and End Date the report will be shown for those dates. The record source for this report is a query I wanted to use this...

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 is printed out fields and they fill it in by hand and turn it in. Instead of the employees doing this I want to record all of this information in the database. These...

ghudson: I am experiencing a problem with the mousetrap sample after I secured my database. When I save on my main form and I try to go to my subform I keep getting the "Please Save this Record! You can not advance to another record until you either 'Save' the changes made to this record or...

I have a query which shows employee Totals it has the following fields: Emp: [EmployeeLastName] & ", " & [EmployeeFirstName] LogHours Total: Sum TotalWorkedPgs Total: Sum WorkDays: Sum([LogHours])/8 AvgPgs: (Sum([TotalWorkedPgs]))/(Sum([LogHours])/8) JobType JobEffort ----- Job...

I searched the forum on custom navigation buttons and found great posts about it. I downloaded 3 samples and the one that fit what I needed was SJ McAbney's dbNavSubform.zip. sfrmNavigation I imported sfrmNavigation per SJ McAbney's on the post into my database. I didn't want to start a new...

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 ran the Find Duplicates Query Wizard and it found multiple duplicates. Now how do I go about deleting these duplicates?

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

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 serve 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\Scanning_Database.mdb. Is there anyway I can recovery this database? I do not have a...

I've been doing a lot of research and reading on databases and normalization and things of that sort because I need to create database from scratch. I've been maintaining a db that someone else made, but it turns out I will have to recreat the whole thing because it's not useful anymore and the...

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. It would be more desirable to calculate the number of work days, excluding weekends and governmnet...

I have a query with Product, Product Directorate, Date Received, Date Delivered, and Date approved fields. Product field criteria: "NAT CONV" Product Directorate criteria: ([forms]![frmWhatDates].[cboPD]) or ([forms]![frmWhatDates].[cboPD is null) Date Received criteria: (Between...