ringer
Last Activity: Jul 29 '09, 02:24 PM
Joined: May 31 '07
Location:
-
Thanks a lot for all the info and help, Jos. -
I was just rereading your post (again) and it brought a question to mind. Are the Java mappers necessary for using an RDB back-end or were you meaning they bridge the "gap" between Java and an OODB?
Thanks again....Leave a comment:
-
Very interesting. Thanks a lot for the info and the help.Leave a comment:
-
Thank you Jos.
I'm thinking now that I need to go with an RDB data store, especially since I have my checkbook mdb as a working model. If I used C++ or Python to program it and SQL Express as the data store, would that mean that I have C++ or Python "front-end" and a SQL Express "back-end"? Would that work?Leave a comment:
-
Thanks Jos.
I think I understand, but how do I choose an IDE? If I use Python, they give options to choose from (http://wiki.python.org/moin/Integrat...ntEnvironments) but they're categorized into these types:
"With introspection-based code completion and integrated debugger" or
"IDEs with introspection-based code completion /or/ integrated debugger" or
"IDEs with integrated...Leave a comment:
-
I ran across another one too. What is an IDE used for?
Thank you.Leave a comment:
-
Please help me understand the differences
Hi,
Can someone tell me what is the difference between languages, libraries, gui's, toolboxes, wrappers, etc., please? While I recently had a class in OOP Logic and Intro to C++, they didn't teach us these basics.
Thank you. -
OODB or RDB for checkbook/budget program?
Hi,
I wrote myself an Access db several years ago to do some things for my checkbook and budgeting and I've really enjoyed it ever since. Lately I've been thinking about writing it as a stand alone program so I could let my family and friends use too (I don't want it to be Access dependent because I don't want to have to troubleshoot and support it on different versions of Access or MDAC).
Anyway, recently I took a class on... -
Thanks very much for your help!Leave a comment:
-
One other quick question about this. How can I make this statement return 0.00 when nothing matches the criteria? Right now the text box is blank when nothing matches the criteria.Leave a comment:
-
Yes! That did it. I've never seen that before. Thanks very much everybody, especially Rabbit!Leave a comment:
-
I've seen that before too and have had to build logic in to intercept that situation when it comes up, but I don't think that's happening here.
I found that for some reason this works:
Me.Text127.Cont rolSource = and t=DSum('[CostPerPaycheck]','tblSavingsFu nds','[SavingsPeriodEn dDate] >= #" & nextpayday & "#')"
but it stops working when I add this criteria back into the string:
and [FundStatus]...Leave a comment:
-
Thanks for the suggestion Zepphead, but when I tried it errored saying "invalid syntax".
Then I tried removing the [ ] from around the date variable nextpayday like this:
and #" & nextpayday & "# <= #" & [SavingsPeriodEn dDate] & "#')"
and this
and #" & nextpayday & "# <= #" & CDate([SavingsPeriodEn dDate]) & "#')"...Leave a comment:
-
Any other thoughts? ThanksLeave a comment:
-
I tried your suggestion
and #" & [nextpayday] & "# <= [SavingsPeriodEn dDate])"
and
and #" & [nextpayday] & "# <= [SavingsPeriodEn dDate]')" -notice the single quote between ] and )
Both give error 2434, invalid syntax.
Then I tried
and #" & [nextpayday] & "# <= [SavingsPeriodEn dDate])" and removing the single quote...Leave a comment:
-
Sorry, I got mixed up and typed the wrong field name. SavingsPeriodEn dDate is also a field in the table tblSavingsFunds .Leave a comment:
-
Dsum as ControlSource for text box on report not working
Hi,
I have a text box on report where I need to have dsum return a total.
The records I need the total from are not in the table that is the report's recordsource, and to complicate things further, I need to use a variable that is derived from behind the report in the criteria for the dsum.
When I try to see print preview, this version of the statement errors before opening saying "Access cannot find the field... -
My thought was that it should run when the db opens. That way the changes to existing records, addition of new records, and changes to the new records are all done before I can launch any reports or forms.
The form where I manually create the records is in the Forms section of the db, but it wouldn't need to be opened if there were no records needing to be manually created. Automating record creation should mean I only manually create...Leave a comment:
-
Use form code on records created with append query
I need to run an append query when I open my db that will look at a date in
the records and copy the records when date() >= [PeriodEndDate] and some
other criteria.
I have the append query working perfectly. But the records still need to
have some code run on them to set up fields in the new records that should
not be copied from the old records. It is mostly math and date manipulation
using values in... -
Your suggestion seems to be working perfectly. Looks like my version was messing up because I didn't put each add and subtract inside its own DateAdd function. Is that right?
Thanks very much for your help....Leave a comment:
No activity results to display
Leave a comment: