Search results

Hi everybody, I did a search on the error but non of the answers are solving it. Anyway, I've got a form and subform. A combo box cmbFrm on the form filters subform to a value it displays. A combo box cmbSub on the subform has onLostFocus event. Now if I do following: cmbSub looses focus...

Hi guys! This question isn’t great importance compare to others but more from tuning point of view. If I delete unnecessary fields (not calculated and not displayed) from a query would it make a difference in performance? Originally they played debugging purpose. Thank you

Hi guys! It's unknown for me why Access hasn't got MINUS implemented and Unmatched Query Wizard doesn't help me much. So I'm wondered if anyone had to confront the following task: Table1 Book Agent ---------- b1 a1 b2 a2 b3 a3 Table2 Book Agent ---------- b1 a1 b3 a3 The...

Hi everybody! I’m wondering if anyone had similar problem? I have a listbox with 4 columns, which is refreshed by a query. Every column has a corresponding button, which can change the order of that column. The problem is every time I change the order of any column I loose the rows I selected...

Hi everyone! I wrote not a small query and as my database growing it takes more and more time to get a result out of it. Right now it takes about 3 minutes, some people may say - it's cool...you've got a good reason for a coffee break, but I'm afraid that in a few month I'll be able to take a...

Hi guys! I have a continuous Form, which displays a few columns of numbers. All I’m trying to get is the sum of each column in the Form Footer. For example one of the columns Named: [Sold] and bound to [Sold] field of a table. So in the Form Footer I created control with Control Source: =...

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...

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...

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...

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

Hello everyone! Does anyone know how to get rid of Ms Access background window on a DB start up? So the only thing I would see is my MainForm. Cheers!

Hi guys! I’ve got a DB security question, and it sounds quite easy, but I stuck with it. The DB on start requests User Name and Password. What I want to do is if a visitor is not the admin, then Menues, Toolbars, Display Database Window, Display Status Bar should NOT appear on a screen. So, all...

Hi guys! I won’t believe it, but I’m having problem when I try to assign value to a Public variable for a Form. In “General Declaration” part I write: Public strSQL as String ‘ this part goes fine StrSQL = “ SELECT …blah, blah, blah…” ‘ this part goes wrong, I get errors How can I assign...

Hi guys! I’ve got a little task. I have ListBox with ControlSource = myQuery. At some point I need to change OrderBy property of myQuery, in other words I want the ListBox to be sorted by another column just by pressing a button. Is there a nice way of doing that by, let’s say, VBA. So, the...

Hello everybody! Have a nice question: How to create a field on a form, witch contains a row numbers, for example: RowNumbers Name 1 John 2 Michael 3 Simon etc I...

Hi everybody! I think many people had similar problem: once I maximise any one Form, then straight after that all other forms maximise automatically. How can I control size of every single Form? Thank you

Hi guys! It's funny, but I try to call Sub of another Form to do some things on that form, but I keep getting messages "Function of Sub is not defined". Does anyone know how to call Sub or Function of another Form? Thank you

Hi guys! Does anyone could explain me how should I use double quotes sings “” in a command lines, for example: If IsNull(DLookup("[WeekID]", "[tbl_Weeks]", "[WeekID] = " & Me![cmb_Week] & "")) Then … I know that was correct syntax, but I can’t get why at the end of DLOOKUP I had to use double...