Search results

Thank you Mile, looks good enough.

Hello everybody! I’m sorry for asking non-access question here, but does anyone know MS FrontPage Forum as good as this forum? Thank you

Hello! Does any know how to kill a process? That’s how we start it: Dim ProcessID ProcessID = Shell (“ C:\Windows\Calc.exe”) So, what’s Shell command to kill the ProcessID Cheers

Hi everyone! I’ve got a nice question. When I press on a button it opens me Excel document, which has to refresh it’s data (it gets external data out of the database). What I want is to print the Excel document. Inside the document I created Auto_Open macro, which runs automatically when I open...

guys! This Forum is Access goldmine!

Thanks a lot The Mailman, you are the man!;)

Hi guys! I don’t get what’s wrong with my Ms Access 2000. I declare something like: Dim db as Database Or Dim db as DAO.Database and get compile error: User-defined type not defined. What wrong am I doing? Funny thing is list of types (which pops-up after Dim db as …) doesn’t contain...

That's the problem: NO. But theoretically, if Expression Builder allows me to choose a query and the field I want, then shouldn’t be a problem, should be?

I tried to use Dlookup but what it does is select for me just one value where as I need the whole list of values of the field. Thank you

I’ll try to make the question very simple: In Expression Builder for the Text Box first I click on Queries, and then select Query and required field of that Query, so it looks like: = [MyQuery]![RequiredFild] That line goes to Control Source of the Text Box. When I want to view the Report...

...continue Thank you Rich, Ok, I’ll try to rephrase my question: If Record Source of a Report doesn’t contain data for a Text Box, then can the data be obtained from a Query (which is not part of the Report)? Cheers

Hi guys! I’ve got bloody report. One Control Box should display list of data. Unfortunately, the list can’t be obtained from the Report’s Record Source. So, I created Query [qry1], and in a Control Source of the Control Box I write following expression: =[qry1].[theList] Where [theList] is a...

Found a "bug" Hi IMO! I’ve tried this method and it seems working fine, but in one of my forms I use DoCmd.Echo False and it doesn’t work anymore… it sounds like Echo is always True. Any ideas why? Thank you.

Excellent! Thank you. I was trying to find similar for Group but fruitless, maybe next time...

Hi! I’ve got some User-Level security set ups (tools..security). After user enters his/her name and password, what VB variable contains the Group name or a user name? Or are there any other ways to retrieve that values? Thanks

:D :D :D

Ok John, I have just found an answer: onopen event type DoCmd.RunCommand acCmdAppMinimize and on close event DoCmd.RunCommand acCmdAppMaximize Thank you for paticipating! But what did you mean by :rolleyes: ?

If you can't call it a winDow, what's that?

Thanks man, it's not a DB window, it's Access window, how to get rid of it? Thanks

Not exactly, by database window I meant all background which has menus on a top (File, Edit, View, Insert etc), Toolbox etc. Thank you