Search results

OnLoad, OnOpen, OnCurrent - they are all getting a run. The problem is that they run once when you first open subdatasheet. I cannot figure out what event happens when you expand subdatasheet second time.

Thanx, it works indeed. Just strugling now with how to add the title to the second as. All the best!

Thank you labolt for the reply. I found different ways to reference tables in another mdb (using linked tables and during runtime with code). The second part of your reply is interesting. Dim app As New Access.Application app.OpenCurrentDatabase "c:\SomeOtherMDBFile.mdb") app.DoCmd.OpenForm...

Thank you for the hint, this will do the work but I see at least two problems with this approach: 1- complexity of application is constantly growing 2- in multi user environment I simply want to distinguish between multiple front ends depending on the user roles. I can think of putting a form...

In MS Access we can open a form and dysplay specifiek information. I would like to do the same but if the form is in another MDB. I guess this is not possible to do with VBA...

Hallo Brian, thanks, it workst just fine. This is the final function Artikel_num: CDbl(Replace(Nz([artikelnummer];"0");".";"")) Cdbl is better because it can manage long number. Nz will manage missing values. Regards Maximnl http://4suc6.com

Yes, what I mean is how to convet text 600.000.055 into a number 600000055

I just stucked. It seems to be an excel weird feature but it should be well known. How to import numeric data from excel column if the column has the following format: 600.000.055 The problem is that although the data is numeric it comes into access as a text but then the dots can be...

I use Access 2003 for XP. When I scroll the continious form my mouse - it goes fine, but if I use recordselector then Access does unexpected refresh of some controls in the form footer. it happens after the selector causes the form to scroll. I have oncurrent() event for the form, but I...

I am looking for a vba function to forecast from the time serries. If you see any application or vba code please let me know. Excel has a function Forecast() , does any one know if I can call it from Access VBA? Thanks and success!

IIF function works fine IIF function does the same job as Nz() and queries with it can be used in Excel. BRT+If([EXP]<>0;[EXP];0)

Split database design and form design Database is made for efficiency of keeping the data , not for entering data. You need to use form for this. I was kind of busy with the same things . your original design is ok Table: TimesheetDetails Fields: Charge Code, Date, HoursWorked. Just add a...

Hallo guys, I am stuck with a simple fact. Nz() function works in Access queries. When I try to import data via these queries into Excel, it says : Nz is not recognized. So anyone knows a good replacement for Nz() that works in Excel as well? With kind regards Maxim P.S. I use office 2003.

Nz() does not help The problem field has value #Error for the missing values, and non of Access functions iserror(), isnull() can detect it. Very strange. Any function which I apply produces #Error again. Interesing insight: is there difference between missing records and missing values...

I use a left join to join table A with table B. Table B has less matching records , so in the resulting table the field [RESULT] which comes from the table B has empty values. If I use an expression for a new field PROCENT that involves [RESULT] I got #ERROR in all records with missing...

In a query I use the following expresion: AREA: Eval(DLookUp("[VALUE]";"VAR";"[NAME]='AREA' ")) The subexpression DLookUp("[VALUE]";"VAR";"[NAME]='AREA' ") results in string [BREDE] * [LENGTE] . In the current query table, [brede]=5 and [lengte]=4 So eval() should return 20...

I have a single record view form with a datasheetview subform. Both are connected to the same table and provide two different views of data. Is it possible to go on the main form to the select record in the subform? The problem is that onchange event in the subform results in a cyclic dependency.

Cdbl does define numeric format in queries Hi Dave, thanks for you reply. I did discovered the CDbl() :) It works, but it seems to me a weird way to control the format of a column. It could take extra CPU time to process exressions as well. Let's be happy that there is at least one method!

use update query Make first update query for your table B and have the full names good. Then you can join.

I was about to post a question yesterday, but I found a solution myself and would like to share it. When a new column is computed in the query, there is no way to prescribe the data format of the computed column (=field =variable). It is done automatically by access and it can go wrong. I tried...