Interesting Question
Mar 18, 2007I have a little question
is't possible, to made record Update without Promt "Your are about to update 1 row. Are you sure to update these records?"
ADVERTISEMENT
An Interesting Access Bug.
Dec 20, 2005I have hit an odd bug with Access. I am creating a query that gathers several pieces of information across several tables linked by a key value (called OrderNo, in this case). This would be a relatively simple query, but each piece of data is an aggregate of some kind, and each aggregate is on different WHERE conditions.
This left me with two options, either two create a bunch of stored queries and join them together, or use inline subqueries. I went the inline subquery route.
I entered into Access a query of the form
Code:SELECT <Fields> FROM WorkOrders, (<Subquery1>) AS <Subquery1Name>, (<Subquery2>) AS <Subquery2Name>, (<Subquery3>) AS <Subquery3Name>, <etc> WHERE <Conditions that select which lines out of WorkOrders are being looked at> ORDER BY OrderNo
Then I switched to design view and left joined WorkOrders to each of the remaining tables. Access modified the code as would be expected. The query runs at this point.
However, and here is the interesting bug, if I go to the SQL statement it created, and do anything Access registers as a change (even adding and deleting a single space of whitespace), Access decides that the result of it's own SQL generator is invalid code. It gives the error "Syntax Error in FROM clause".
I can provide the source query (in all it's overcomplicated massiveness) and the result after using Access to join the subqueries to the WorkOrders table if anyone cares enough to see/wants to try reproducing it.
Getting Interesting Error Message
Oct 25, 2005I have an Access project that when it starts, lets you pick a folder and a file to open as input (done with VBA code), and that works beautifully. My project then processes the opened file and that works fine also. However, when I run the project a second time, pick another file (with the same format), my project then dies on me. If I get completely out of my project and thenre-enter it, it runs fine. I've enclosed a screenshot of the error I'm getting.
Any help is greatly appreciated. And yes, I did a search on this and several other forums as well as on Microsoft's site and could not find anything related to the error I'm getting.
Interesting Query Challenge
Aug 14, 2006Hello all. Hope someone can help.
I want to know which of my customers received a particular service (service id: #199) during the last month. It gets complicated (I think) because of those customers that received service 199 last month, I want to know which ones did not receive any other services in the 90 days prior to receiving it. Any thoughts on how this can be done? I can find who received the service during the last month, but how do you check to make sure they have not received any others during the last 90 days?
Any help is much appreciated.
Thanks,
S.J.
Interesting Question Asked Of Me...
Jul 28, 2005I'm not looking for your expertise in "how to" do this (not yet, anyway) but a friend asked me if Access could do certain functions. Like "automatically fill-in some of the
more routine letters/forms such as basic letters of
representation, medical bill/record requests"
(routine for his biz) and "basic calendaring
functions, such as keeping track of monthly deadlines, reminders, and other
important dates."
I figured that if so, the app would have to be running in order track deadlines and such.
So, are these things that are Access able functions?
Tx
-Jim
Sum Total Giving Interesting Result?
Oct 10, 2007Ok baisically im doing a quick db for my company that is organising every file stored within the server and monitoring their last access'd, modified etc... I have a query which collates all the files which can be deleted on a server and file count is something alond the lines of 300K+ however i have also Sum'd the file sizes and instead of giving me some mental file size it has given me this result: 1.29659732507E+11
I mean i am no mathematician.. cant even spell it :S anyways im guessing that the number: 1.29659732507E+11 is actually 1.29659732507 to the power of 11?
Is there anyway i can get access to show the actual number i dnt care how long it is i just want a reliable, definitive result i can show my boss!
Cheers
Interesting Time Calculation Problem
Jan 13, 2004i need to calculate time, the problem i have is that we are trying measure production over the day, however our days run from
22:00 through to 22:00 the following evening
i have tried to calculate it by taking the end time from away the start time, but when i tried to do this it gives the wrong figure
eg
DayCode - 3111 (This is just the code we use to represent each day)
Line - C3 ( Machine identification)
Start Time - 22:00 ( Time the Machine started)
End Time - 18:00 (time the machine ends)
Duration - 04:00 (the figure that is display when calculated in access)
the duration figure should be 20:00 hours
i have managed to get it to work upto a point with the following code
runtime: IIf([starttime]=[endtime] And [starttime]=#22:00:00#,#23:59:59#,IIf([starttime]>[endtime],(#23:59:59#-[starttime])+[endtime],[endtime]-[starttime]))
but
if the the two times are the same for example 22:00 on the first evening through til 22:00 the following evening, i should get a result of 24 hours but instead i get zero, so i was wondering if there is a work around to this problem, i also need the time to be displayed in full hours whereas the above code only dislpays it to the correct hour minus 1 second.
i have attached a sample for you to look at:
i hope this makes a little sense.
thanks
Andy