Search results for query: *

I'm trying to set up a database for scheduling and tracking employees' training, vacations, sick days, etc. Two things I'd really like to get out of the database... 1. Report where Rows would be employees and columns would be days "1/1/06", "1/2/06", etc. The values would be Start and End...

I'm hoping someone can help me determine the best way to set up my tables and relationships for an Employee database (contact info, training, work schedules, etc.) I'm currently stuck on the set-up and proper relationship properties for the following two tables... tblEmployees EmpID -PK...

I'm using the following expression to trim text preceeding "TECH REC" in a Text field: Left([ALERTtxt]![Description],InStr([ALERTtxt]![Description],"TECH REC")-1) I'd like to use this field with Totals selected - Group By, First, etc. but I get errors with each. If I use Expression it says...

I'm creating a database to track aircraft maintenance employee training. One significant requirement for the db is to determine who is qualified to work particular fleet types. The basic layout so far is... tblEmployee EmpID (PK) LastName FirstName EmpType (Analyst, Controller, Superivsor...

I have a form 'frmEmpDataEntry' that's used to input and update employee information. On the form there are 6 command buttons that use the ApplyFilter macro to filter by employee type [EmpType] (5 employee types and ShowAll). I am also using an unbound combo box [EmpSelect] to select a...

If I have a [TextField] and a [DateField]... TextField can be "A", "B", "C", or "D". In my query I have a calculated date field [CertDate] that I want to equal DateField if "A" or "B", and equal to today's date if not. I've tried the following expressions with no luck: CertDate...

I have a table that stores employee training for aircraft mechanics. tblTraining has the following fields: TrainingID, EmployeeID, TrainingTitle, TrainingType, FleetType, Date. The value for FleetType can be 727, 747, 757, or 767. The value for TrainingType can be ENG, AVI, FAM, CAT, or ETOPS...

I've got 3 fields in a query: [FAE] has a 1 or 0 in it; [CertDate] contains a date if the employee is certified, otherwise it is null; [Qualified] is a calculated field that should return "1" IF [FAE] is "1" AND IF the last day of the month 12 months from [CertDate] is > the last day of...

I have a [NumberField] and [DateField]. I need an IIf statement that says: If [NumberField]=1 AND If the last day of the month 12 months after [DateField] is > the last day the current month, return 1, else return 0. I can write the expression for either the NumberField or the DateField, but I...

I've got Outlook 2003 and McAfee Anti-Virus. Many of my emails come in with (Warning AntiVirus Bypassed) in the subject and in the header. What is this about, and is this generated by Outlook or McAfee or ?? Thanks for any help!!!

If I open an Excel template, it opens as an .xls file. And when I click "Save", a "Save As" box appears and I can save the new .xls file. I would like the template to open the same way when opened via RunApp in Access. In Access, I've create a macro to open the template using RunApp with the...

If I open an Excel Template, it opens as an .xls file. And when I click "Save", a "Save As" box appears and I can save the new .xls file. In Access, I've create a macro to open the template using RunApp with the following in the command line: "C:\Program Files\Microsoft...

It's the little simple things that drive a person to madness... On a form, I have 3 text boxes: Date1, Days1, and ResultDate. I want to key a date into Date1; a number of days into Days1, and ResultDate will display will Date1+Days1 as a date. I've tried: DateAdd("d",[Days1],[Date1]) and I...

I have a text field [BOW] that contains either a Bill of Works number (I.e., "TS1483") or " 0" (two spaces and a zero) if there's no BOW #. This data is imported from a customer's .txt file. I make some updates to the data and then append to a table. I want to append "" (leave blank) if the...

I have a memo field [Description] that contains a problem description and a corrective action. The corrective action is always preceeded with "Tech Recommends:" I.e., "#1 HF inop. Tech Recommends: Replace #1 HF receiver." I'm running an append query and only want to capture the problem...

What is the expression I'd use in an update query to convert a text field that contains "yyyymmdd" to a date/time data type?

Each day I receive a text file that I want to import and append to tblHistory. tbl History has additional fields that will be updated using data from the import. I.e, my date comes in as yyyymmdd as text. I have a field in tblHistory to capture the date after it's been updated. I need to...

I import a text file (that can't be changed) and then append that data to a history table. The text file is deliminated by "|" (pipes). One field has two text areas always separated by 5 spaces. I want the text before the 5 spaces to append to one field, the text after the 5 spaces to append...

My databases were just relocated to a new server. Now I get the following message each time I open one: Microsoft Access can't change the working directy to 'G:\Data\....' Verify that the drive is valid and the path is 260 characters or less in length. Everything else seems to work fine...

I am working through "MS Access 2000 VBA Fundamentals" by Callahan and have hit a road block. So, I'm hoping someone can help me out. The database I've built to test this function has two tables: tblSubscribers: SubscriberID(PK), LastName tblPayments: PaymentID(PK), SubscriberID(FK)...