Search results

I have what looks like a simple thing to do, but I've discovered that I sure don't know how to make it happen. The method that "Modest" showed me how to do wouldn't work because of a problem with the data I was using. Using the data in the attached db, I need to forcast future dates based on a...

I have what looks like a simple thing to do, but I've discovered that I sure don't know how to make it happen. I've attached a small db to explain the data I have and what I'm trying to do. If anyone can show me how to do this, I would greatly appriciate it. I'm down to just a few days before...

I’m using MS Access 2000, SR-1. The Data I have to use is in a linked, SQL7 database that I can only read from. In my Access Database, I've created a query that pulls the following data from the SQL Database: Query [Forcast_1] contains four fields. [Jobnum] [Planum] [Interval] [Counter]...

I have a table that contains work order numbers and the dates that the work orders were written. I need to create a report that shows this information seperated by these groupings: 0-15 days old 16-30 days old 31-45 days old 45 days and older Can someone give me an idea as how to make a...

Somehow, every db on my PC and Lan now will not allow me to use the "New" option for tables or queries. Even when I enter in the "Exclusive" mode. What in the world can cause this? To make changes, I had to create a new db and import everything from the db I was making changes to. That worked...

I have to import a field from Excell that contains more than 50 characters in the field. I need the line to stop at the last complete word prior to 50 characters and start the next record in that field automaticly and continue to fill and wrap at the last complete word prior to 50 characters...

The [wostatus].[changedate] field is formatted as a Date/Time field. In the below query, I need to put [What Date?] as criteria in the [changedate] field. I want the user to type in only the date in mm/dd/yy format. Can this be done? ----Start SQL---- SELECT dbo_wostatus.status...

I have a table with the following fields. Record Number (Autonumber and Primary Key) Work Order Number (Text) Work Date (short date) EmpNum (text) RegTime (number-single) OT (number-single) VacHrs (number-single) SickHrs (number-single) A record CAN have a duplicate work order number. I want...

I use a timer form, With timer set to 1800000 (30 minutes), to open a form every 30 minutes to check for new work orders. I need the form to open on top of any application that is currently open on my screen. If I remember correctly, the form has to be set as "Model", but I don't remember how...

[Permissions List for Work Orders].[EmpID] is where I have the email addresses for everyone I need to include in a Bcc address block. The table name is [Permissions List for Work Orders], and the field name is [EmpID]. The data in the field is text and looks like one of two types: Doe, John...

Currently, I have a query where the criteria is like: "1a1" Or "1ab" Or "2a1" Or "3f6" Each of these are pieces of equipment that are listed in the EQUIP table. The criteria changes often, and the only way I know how to do it is to take out and/or replace/add whatever the change is. There has...

;) In the attached dB, in the Log Entries form, I'm trying to get the passengers and crew counts on the left side of the form to be the total of the entries of the related Subforms on the right side of the form. Can someone help me with this? P.S. The counts that are there now are user...

My printer was printing my reports perfectly. Now none of the reports have the lines on them. Just the text. Now what did I do?

Yikes! I feel like a puppy chasing my tail. I have an Intra-net site that contains a MS Word Doc that users fill out. Now, I have to import what the users put into the Doc fields into A2k as they close and save the doc. I don't even know where to start. Can someone please tell me what I need...

I have a textbox, [Due Date] on a form. If the date in the field is greater than todays date, I need the text in the field to be bold red. If the date is less than or equal to todays date, then I need the text to remain as it is set in the properties, (bold black). I've tried the below code...

Hi everyone, I've run into a problem I've never tried before. I have a table that has a text field like: Bldg2-1st_Flr-Column_10B What I have to end up with is: Bldg2 1st 10B Each in their own fields named Bldg, Floor and Column Number. I have never even tried anything like this. I bet it...

My supervisor is giving me a text file that he wants to put all of the information into a database from. When I looked it up in my books, I couldn't figure out how do even start! If someone could please help me, I'll owe you forever! Please, M