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'...
I'm having problems getting this to work and I do not understand why. As far as I can tell everythign is written correctly - it just doesn't seem to want to work!
In the report I am working on I list a set of work center test stations. The report itself works great and does exactly what I...
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...
I am not sure what is happening here. I am trying to query a table (DyessD23) to count up how many documents are in a certain status (cur). For the most part the query works - but returns numbers that are WAY off. If I go through the table and count myself I come up with numbers nearly 1/2 of...
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...
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 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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.