Hi. I'm trying to distribute installers to upgrade a database, using Access 2007 Developer Extensions Package Deployment Wizard, and it doesn't let you install as an upgrade - you have to first uninstall the old version. My understanding is that this is not the expected behavior. Is there anything I can do to make it work?
Thanks.
NaftoliGug
Last Activity: Aug 27 '09, 04:59 PM
Joined: Aug 11 '08
Location:
-
I don't have an exact answer to your question, but maybe it would help to clarify to things:
1) What layout is panel2? If it's BorderLayout, the first item that you added to it without specifying a side should be in the center, and then the picture which you specify center for will replace it. That wouldn't explain why the remove button is not there, though - for that you specify south.
2) Just a side point - it's recommended to use... -
String has a function to to a find/replace. So replace every < with < and every > with > (actually once you replaced the <s it might be unnecessary to replace > - try it.)Leave a comment:
-
Hi. I didn't notice anything wrong right away, but I'll tell you how I usually debug these types of problems.
Set a breakpoint in the _Click event after the entire string is composed. The first thing I would do is when the breakpoint is hit, go to the immediate window and print out the contents of the string:
(or whatever the string is called.Code:[INDENT]? sqlString[/INDENT]
Examine the output and see if there's anything wrong with the sql statement....Leave a comment:
-
I guess that's what's necessary. That's what it sounds like...
As someone mentioned, Microsoft is stuck to whatever design decisions they made early on. They can't break compatibility, and the alternative -- to provide for both behaviors -- is not worth it for them.
I really wish there was an easy way to bind controls in Java to a database. If you could bind a control just by setting a property I would go with Java any day over Access....Leave a comment:
-
The IcoFX method is very good. It should be noted that in Access 2003 when you embed a bitmap it doesn't store the transparency but converts it to the button's background. Instead store it as a linked bitmap. You still need to reload the form (which reloads the picture) when the color settings change to update the the transparency.
If you need to specify a relative path, set it in VBA on Form Load relative to Application.Cur rentProject.Pat h....Leave a comment:
-
Thanks for responding...
That's exactly what I'm talking about the whole time! Of course I tried doing it from VBA, how else? (Sorry if I sound a little exasperated.) What I'm trying to say is that changing the visibility in VBA changes the visibility for _every_ row!
I definitely considered doing that. The problem with this approach is that if the price has been customized then changing the selection...Leave a comment:
-
I certainly appreciate the time everyone has taken to help me, and I'm not trying to be ungrateful. I'm just a little frustrated that no one seems to understand the points that I'm making, which I think I expressed quite clearly, and then insinuate that it's my lack of understanding of the subject matter. I understand that it's not anyone's fault. [Yes, I am quite aware of the concept of table relationships and how data can be split across two tables....Leave a comment:
-
I didn't say I wanted to persist the state! I think I understand databases quite well, thank you. There's no reason that Access can't remember transient state that would help to provide some functionality. Anyone who has programmed databases with a real programming language can understand that! Forms are more than table views with a different shape!
In other words, often it's necessary to remember something about a record temporarily, in...Leave a comment:
-
Now I tried having text boxes for each and toggling them visible/invisible (real price is visible, double-click sets it invisible and custom visible, afterupdate with null sets custom invisible and real price visible). Guess what? Again, settings apply for every record! Ideas, anyone??Leave a comment:
-
What a quick response!
I don't understand the question, "how could it be otherwise." It would make sense to remember state across different records. Events are always generated from a specific record, so any code modifying a control's state obviously means to modify that state for that record. And if the user directly modifies the control he certainly means to modify the one he interacted with! Checking a checkbox next to a field...Leave a comment:
-
Different unbound controls in continuous form view
Is there a way to have unbound, uncalculated controls (or a calculated control that is based on a function) that retains a different value for each record? -
I don't know for sure, but I think you could have a column in your query that is based on an expression, using the DSum function - DSum("contribut ion_amount", "contributions_ table", "year <= year_field") where year_field is the year of the current row. This will aggregate (the D... functions are called domain aggregate functions) the contributions to the account for all years up to the year of the current row. So...Leave a comment:
No activity results to display
Leave a comment: