Search results for query: *

I've got a DB I manage - built long before my time. One of its daily function is to import supply reports that are in TXT format. Unfortunatly, the format of the TXT files have changed on me and I now have to get this import to work again. What has me stumped is the 'Specification Name'...

PH Thanks! Your help fixed this right up.. :D Makes me wonder though why the DATE(),"ddd"="Thu" didn't work... Wierd...

...reminder to pop up on the report so it is not forgotten. Inside the report I put this line: =IIf((Date(),"ddd")="Thu" And [Station Type]="ADTS","*** ADTS 7 Day Inspections Due ***","") So, I should get the line "*** ADTS 7 Day Inspection Due ***" on every ADTS test station on Thursdays...

Okay - So I went to the original query and tried to do the same thing. When I do I get an error saying 'You tried to exicute a query where "Element" is not part of an aggregate function' ???

What the?!?!??!?!?!??! Okay - removed the GroupBy on the second query. (Didn't think I could do that with the 'Totals' enabled... At any rate, when I do that I get 474 records!!! When I look at the query results - most lines are listed 3 times! Some twice. wierd..... I'm totally out of...

...Or [DyessD23]![CUR]="AWM" Or [DyessD23]![CUR]="FWP" Or [DyessD23]![CUR]="MTM",1,0)) AS [Dys AWM], Sum(IIf([dyessd23]![cur]="0*P" Or [DyessD23]![CUR]="AWP",1,0)) AS [Dys AWP], Sum(IIf(DyessD23!CUR="DWP",1,0)) AS [Dys DWP] FROM Area INNER JOIN (lru INNER JOIN DyessD23 ON lru.NSN = DyessD23.NSN)...

The DB is not SUPPOSE to be secured. At least no password requred to open it. As far as the MDW file ... how can I find out if I am using the correct one? I had the owning shop search the directory to where the MDB file is stored and they found a "secured.mdw.mdw" file. They sent that to...

No one, not even me can open it right now - regardless of the location. I have put the DB on my desktop to work on it so I definatly have access to the folder.

I have a DB problem that I'm hoping someone can help me with. For some reason - out of the blue - our DB has appeared to lock everyone out! When anyone tries to open the DB (mdb file) you will get the error "You do not have the necessary permissions to use C:\..... .mdb object. Have your...

IT WORKS!!! Thank You

Will give this a shot when I get back to work on Monday... Thank You

Sorry... PremerePro2.0 I cannot find where to set the output settings (new user using a work computer w/this program). Every output settings that I have found either does not have the frame size or if it does it is dimmed out and I cannot change it.

I'm sorry... I should have started that post with "HAPPY THANKSGIVING ALL!" :D

I created some animated text the other day to use as a Avitar in the forums. However, the output animated GIF file is a 640x480 size and about 15.5mg. I cannot find a way to reduce the output size on the GIF file to a smaller size. Is that possible to do with Premere? Would another program...

Update: Worked this a while this morning and was able to get everything to work as required!! THANKS TONS EVERYONE!! Quick question though: Golom posted something about area.name being a 0 or -1. Not sure where that came from. One of the things that tripped me up was the ANQ161 field is a...

Here is the code that works for selecting "DAV", "REW", or "ALL" INSERT INTO [Enterprise Report Card] ( LRU, NSN, Repaired ) SELECT lru.Abbr, lru.NSN, Sum(IIf(work!status=4 And work!code=11 And work![tin date] Between DateSerial(Year(forms![enterprise report...

Now; thanks to all for getting that portion to work. :) However, I have to add one more step to the process. I didn't bring it up earlier because I think I needed to get over this one hurdle before tackling the next. I have a 4th selection on the combo41 box: 161Boxes In this selection I...

Golam I am trying to be professional here but this post of yours is making it quite tough.. :) (Any 'inappropriate' thoughts were directed at myself here!! :) ) That's IT????? You've got to be kidding me! Just replace the true portion of the IIF statement w/Area.Name? Worked like a CHAMP...

What I am trying to achieve: I am using the combo box (combo41) for the user to select the data contained in a report. The user can select shop "DAV", shop "REW", or "ALL" for both shops. I am using the IIF statement in the WHERE clause to choose what is displayed on the report. If I put just...

Leslie If I am reading your post correctly, yes... that's what I would like to do. I'm not sure if this is a suggested fix though. Do I want to put that 'where' statement as the "true" value of the IIF statement?