Search results

That is too bad. Oh well, thank you for clarifying that for me.

So if I understand you correctly, I *have* to provide the complete path to the control, and shortcurts like "me.textbox" won't work?

Hello, Could somebody please tell me how to write my Where statement without specifically mentioning the exact name of the parent form? This is what I have right now: WHERE (((tblOptions.OptionsID)=Forms!frmBrowseApplications!sfrmOptions!OptionsID)); It works, but I'd like to get rid of...

Thank you. And yes, some things at least are not as easy as you'd expect them to be. Even seemingly simple stuff like this. :)

Alas, it isn't quite "solved". Although I am now certain that it's caused by the different versions of Access. For me running A2002 [XP], the button looks fine, with transparency intact. But on a machine with A2003, the background is visible again. So in order to get the icons to display...

I just reloaded my transparent icon images, and now the transparency is working. Very strange. I had briefly worked with my db files in A2003, but that shouldn't cause this kind of problem, should it? [I'm using A2002]

Or maybe this installation of Access is just lacking some filters - it also complained that it didn't understand the GIF file, and that I might want to try a GIF file instead. The file can't be too large at 914 byte [vs. 766 for the ICO file]; the 4 kB bitmap is loaded without problem.

Thank you. Strangely enough, Access XP complains that it doesn't understand the file format that is created by this tool.

Hello, I made some custom icons for use with command buttons, and I made them ICO files with transparency. However, after I assigned them to my buttons, there's a light grey background colour - which doesn't look all that great. Is there a way to import images with their transparency intact...

I found a solution - had to change the join type for these two relationships so that even records are shown that don't have a corresponding value in those two tables. Pretty simply solution, now that I know it. :)

Hello, In my database I had two tables that contained names which I used to look up and copy into the main table. There was no relationship between the two tables and the main table. Now I changed the setup so that the main table only stores a references to the name tables, ie. the IDs. This...

Great tool, and easy to use. No problems for me. Thanks for making it available here! Also thanks to oldsoftboss for his enhancement. Very nifty!

Thank you, Bob and Doc Man. And yes, Doc Man, you are right - I was hoping I didn't have to invest all that much effort to let multiple users work with the db. But you raised some interesting points, so I'll look into the security issue. Thanks again.

Hello, I have this database that I'm working on that wasn't designed specifically as a "multi-user" application. But it's now to be used by various people across a network, and I'm wondering what, if anything, I need to do to make this work. I don't really have any security concerns, I just...

I could, true, but I think that may not be necessary since I can - and did - already set them to auto-grow. Actually, my current setup is very similar to your suggestion - I have a manual page break before my two memo fields, and one after. That should work fine since I don't expect them to...

I have the same problem. Put your data in as subreports, they take up very little space on the main report design page. They almost work like placeholders - the eventual printout will look fine, but on the design page, you'll only have this little box for your subreport. :)

Yes, I have one manual page break so far, and I could use more in this case. I'm just trying to figure out if there's a way to do this that won't waste an entire page per memo field.

Maybe I can, I don't know, that's why I asked. :) I don't really have any groups at this point, although from your comment I gather that maybe I should look into that.

Hello, I was wondering if there was such a thing as a "dynamic [or conditional] page break". With that I mean the following: I have 2 memo fields in my table, and of course I cannot predict how much text will be in those. So what's the best way to put those on the report without wasting too...

Take a look at this, it may be helpful. http://allenbrowne.com/ser-52.html