Thanks Dormilich I see now that #1 was kind of obvious lol. Sometime you have to step back for a while in order to see things clearer.
#2 For now I am going to stick to compile statements manually since the whole idea of this new application is to learn how to code better. I try to use as little libraries as I can until I can understand better what it is I am doing and how to better see and debug my codes.
jaad
Last Activity: Dec 6 '15, 10:28 PM
Joined: Oct 2 '09
Location:
-
Can you see why I am not uploading the right file name to MYSQL?
Hi,
I am an MS Access user trying to move an application on the web with php and mysql.
I have two questions:
#1
I have followed a tutorial and was able to establish a page. The problem I am having at this time is not being able to save the uploaded file with the correct file name(with time() function added to the filename.) to Mysql. it only save it as the name of the original file. Can you see why that... -
looking for literature about the implode and explode function
Hello All,
I have been struggling for over a week at trying to get a set of checkboxes saved into mysql and then call them back when a user wants to update their profile. I have spent over 40 hours corresponding in forums to try to get some help but nobody seems to be able to help me so I figure I should learn the classic way and read about it from the horse's mouth lol. Do you guys know a really good book, or a website that can... -
Thank you for your Time on answering my question neopa.
cheers
jaadLeave a comment:
-
i understand what you mean. but if you look above on my first post you will see that the HST control has a (iif) statement in the expression and access wont let me sum it because of that. i will try to figure out another way of showing the sum, maybe just create a button to open the related report where I can see the sum.
it's not a big deal and don't want to waste your time with this. thanks a bunch.
jaadLeave a comment:
-
control I supposue. the values in the control name [total] is an expression that calculate to cost of the item + HST Tax. is there a way to culculate on form the sum of all [total]. I can do it on a report, just asking if i can also do it on a form?Leave a comment:
-
referencing the subform is not my problem. the problem that I have is because the HST field is an aggregate function and access doesn't let me group it because of that. or am I'm not getting something?
[imgnothumb]http://bytes.com/attachments/attachment/5172d1306031960/pettycash.jpg[/imgnothumb]...Leave a comment:
-
calculating the sum of a calculated expression field from a subform
Hello all,
I have a petty cash main form: PettyCashTF
and a supporting sub form: PettyCashDetail sTF
to keep track of reimbursable expenses.
the main form keeps track of the date, vendor, invoice number and so on.
The subform keeps track of the details for the transaction:
Item purchased
Quantity
Unit price
tax exempt (check box)
note
... -
it has, thank you for taking the time to explain it to me. You see, this is the sort of information that I find valuable. I can grow with this and start creating instead of copying and pasting a quick fix for a code; I know what it is, and how to use it- and why. Examples are great for a quick way of getting the job done but as a musician who plays music by ear, you can't compare this musician with one that has learned about the structure of music....Leave a comment:
-
Subform References
I'm curious about the difference of these two as I had to come here and ask how to reference a subform from an OnClose event of a popup.
why is one with quotation marks and no Bang? (that's the one that worked with my popup by the way)Code:Forms![FormName]![SubFormName]![ControlName] Forms("FormName")![SubFormName]![ControlName]
** EDIT **
This question was posted within the article Referring to...Last edited by NeoPa; Feb 13 '11, 08:55 PM. Reason: Please don't ask questions in the Insights section or in other people's threads. -
thank you very much this is very helpfulLeave a comment:
-
What is the reference line for my subform control?
I have a main form called [LocationsTF] on this form I have a subform called[LocationSubTSF] this subform has a control called[Charges].
I have a combo box on the main for that has an afterUpdate Event which requery a bunch of controls on the main form. I would like to add a line in that AfterUpdate event to update the [Charges] control on the subform also but can't find how to write the reference to it -
Where can I find info on how to reference in vba?
I have been trying to build a database for the past year and time after time I always end up with the same problem. I can never write the right combination of reference for a control or a form or a subform and so forth. is there a link somewhere where it would teach me how to reference properly in VBA? thanks -
LOL it works! For some reason Which I don't know why it didn't want to work before when I used the line. THis is something that happens very often with my database codes. Sometime they work and sometime they don't. Sometime I will be using a function for a month and then suddenly it stops working for no reason. Is there some sort of bug in Access 2007 with this matter?
by the way thank you very much for your patience and for helping...Leave a comment:
-
It is a little bit more complicated than what it seems. If you open up the picture "Locations" you will see the form where it all start. When I click [repairs]for an item in the sub-location form, a a "popup repair form" pops up so I can write what I need to do with this {item} that is in a "sub2nd location" which in turn is in a "subLocatio n" which in turn is in a "unit" which in turn is in a "building....Leave a comment:
-
How to requery a subform at closing of a popup form?
I use a popup form to write the "ToDo" portion of a record. Once I close the popup form I would like
to be refreshed with the new information that I just wrote in the popup form that I just closed. I don't know why I always end up with this same problem every time; every time there is a different way of refreshing a subform. One day...Code:[Forms]![LocationsTF]![LocationSubTSF].[Form]![CurrentRepairs4LocQF].[Form]
-
YEEEE... it works perfectly. Thanks a million Stewart. you da man.....
cheers
jaadLeave a comment:
-
I've just tried the code line that you wrote and corrected the second "IFF" to "IIF" and it works in report preview like mine did but when I go to print preview I get an [Error]?Leave a comment:
-
I've tried that already and it didn't work for me
Code:IIF(Isnull([BackChargeProjectTimeSR].Report![AccessLabourTotal],0,[BackChargeProjectTimeSR].Report![AccessLabourTotal]) + IFF(Isnull([BackchargeInvTenantSR].Report![AccessInvTotal],0,[BackchargeInvTenantSR].Report![AccessInvTotal])
Leave a comment:
No activity results to display
Leave a comment: