Recent content by Alexander S.

Yep, I've also tried this, but there is no visible change in the report - at least it's not an error. I suspect it's not possible to dynamically change the visibility of an element from entry to entry. If that is the case, how could I solve this problem on the query level (as suggested by...

It returns an error if I do that: "You can't change the value of this property in OnPaint event"

Hello! I have a report in which I'm trying to hide some elements from view in case a specific value is Null. Access seems to do this automatically if the report is in print-preview-mode, but not in normal view-report-mode. I've tried something like this, but it's not really working: private...

Oh yeah, you're right. I don't need the entire record. And DLookup() is exactly what I was looking for. Thank you! DLookup("AbBrAdID", "tblAdFlgDaten", "[Schritt] = 2 And [AuftrID] = " & ABAuftrID) Sweet!

Hi Guys, Is there a possibility to use a shorter code for extracting one field from one record, than opening a recordset, getting the field, closing it and setting the recset to "Nothing" again? I'm doing this multiple times in my code and it seems a bit too much for what it's supposed to do...

Yes, there are other combinations. The ones you stated are correct, then there is transfers from address to address and sometimes but rather seldomly there are round trips. Most of the time it's really just addresses and airports. Here is how it works: "tblAuftrag" contains general assignment...

Didn't know about the cross-posting etiquette, just thought it would raise the probability of getting a good answer. I posted on german forums though. If you're interested, here are the links: www . ms-office-forum . net / forum / showthread.php?p=1624924 www . office-loesung . de / p /...

Other message boards were giving me similar advice. I didn't even notice how many similar fields I had in those 2 tables. A case of tunnel vision, i guess. Before (with english explanations - copy and paste the links, can't post URLs) abload.de / img / transeren40p1r.png After abload.de / img...

Hello Community! I'm trying to create a report with data from 7 different tables. It's supposed to be an assignment overview for a transfer company (driving people from A to B, dunno how to call it in English). I put assignment and customer details into the page header, which is working out...

Hi Guys! I'm rather new to Access, just started about a month ago with developing a database for our family business. I achieved quite a lot with googling and literature alone and am starting to feel confortable using the program and VBA. Still, i keep encountering problems with one of them...