Search results

I put my DB on a thumb drive to take on a deployment. It was working when I checked some data the other night but now I can only open one report out of apx 20 reports. It will not open in preview and I also can not create a new report. Any ideas?????? Thanks, Tim

G'day, I'm trying to replace a date on a table using an update query. I have the criteria set to [enter date] but it won't put it in the update to block. I know this has to be one of those easy one but after a search and using help I can't nail it down. Much appriciated, Tim Guess I should add...

G'day. This is a tough one and I could use some help. I work for the military and day to day there are people on orders. My finance folks are providing me with an Excel spreadsheet with all the names and start/finish dates of people on orders and I import that into a table. What I need to do...

Good day, I've been through pages and pages of searchs on count, sum etc. All I want to do is count the number of "check marks" ie yes on a report. I've tried =count([10kforklift]) I've also been in the help file with no luck at all. Thanks for any help, Tim

Good morning. I'm trying to build an expression that will give a date to retest on fitness using four criteria Excellent, Good, Marginal, and Poor. I've got a start but it is getting very deep for me. If I could just get a a little help I think I'm close. Here is what I have so far...

Good day all. A bit of back ground, I've built a data base (with much help from the folks here) to track the training of my people. Someone way higher then me has decided to completely revamp our field training. There are now two "tiers" based on rank and training level. My first thought is to...

Hi All, I'm just kind of goofing around and I thought it would be fun to build a milage calculator. I'm going to make a table with all the trip details ie gallons used, miles driven, time between fills etc. So looking at making a form for entering all this info, how can I put multiple...

Okay, this is gonna be weird :o What I'm looking to do is count the dates a preticular training task was accomplished. However, I do not want the dates that are expired to be counted. I will be running this off of a quiry that shows the "due date" of each task. I really have no idea where to...

Double post, sorry

When I print individual lables I would like to be able to position them on the lable sheet so I don't have to waste lable sheets. Is there a way I can choose the position of the lables I want to print??? Thanks In Advance, Tim

Hi All, I'm looking for a simple way to clear a all of a specific field in a table (check box). I've put a control on the form but I'm not sure what/how to make it work. Any ideas/suggestions welcome. Thanks, Tim

Hi All, can some one show me the proper expression to make capital letters. I'll be using it on form controls. I'll just be using the control properties, format..... I think. The UCase I put in there is getting broke up with front slashes (/) Thanks, Tim

I'm starting over on my data base. What I am tracking is personnel and training tasks. I have apx 35 people and apx 75 training tasks, everything from weapons training to drivers training to carrer progression. My first question is with tables and their relationships. Do I even need...

I'm stuck again. Here's the deal............ I have a data base to track training. I use three sets of forms to enter data Personnel info, training tasks, and carrer progression. I start out buy putting a new hire into the personnel info then update training through the other two forms. The...

I'm not sure where this should actually go, so in to general. Here's the problem. I have three forms, they they are all based on queries. when I add a person into my "Personnel Info" form, it puts the info into the table that holds that info. However, the other two forms that draw information...

Hello, At the end of a report I would like to count all the people who are trained(as a date) and divide that by the total number of people. =([countoffieldhygiene]/30) and then formate that to percent. The problem I'm having is that I have a conditional format that turns the date red if their...

This is more a general question for my own piece of mind. I've combined three tables into one query so I can use all the information on a tabbed form (I just discvered tabbed forms and I love them!!). I'm just concerned that the query is too big?? Am I just worrying over nothing??? There is...

Good morning, I'll start out simple. I'm experimenting with creating a report in design veiw and have already encountered a problem. I put a text box control on it and have been trying to get it to show the "LASTNAME" field from the "PERSONNELINFO" table. I used the expression builder and I'm...

Good morning, I'm working on a weapons qualification report. We have 3 catagories ABC which shot at different intervals. I've got group A figured out =IIf([ARMING GROUP]="GROUP A",[M16QUAL]+365) I need to know how to add two more expressions just like that but adding two and three years...

Conditional format NEW QUESTION ADDED. I have just done a search, and read through 6 pages of info on this but didn't get just what I was looking for. Sorry to have to add to the list. I would like to format a text control that shows a date 9years and 6monthes from the last time a check was...