Looking for Dmax function in Expression Builder

[jrbor76]

Hello all,
I am trying to set up a table for use in a form where the primary key will
be a number that increments from a certain base, say 5000 or so. I've read
that one of the ways you can accomplish this is to set the default value in
design view to (Dmax+1) using Expression Builder, something to that extent.
All very well and good, I'm willing to try that, except I'm looking in the
built-in functions in Expression Builder, and Dmax isn't there. Nothing
remotely like Dmax is there. Do I need to import a new set of functions from
somewhere? Or do I need to use something else completely?
Thanks in advance.

 

[jrbor76]

Additionally, (and I'm sure most of you already figured this out), the
Expression Builder screen does not have Domain Aggregate functions included
as an option in the middle list. That's what I guess I'm really trying to
add. Excuse my ignorance.

 

[Bob Quintal]

Additionally, (and I'm sure most of you already figured this out),
the Expression Builder screen does not have Domain Aggregate
functions included as an option in the middle list. That's what I
guess I'm really trying to add. Excuse my ignorance.

I have Domain Aggregate listed in the middle pane of the expression
builder in Access 2003 (work), Access 2002 (home) and 97(work again)

What version are you using?

 

[Bob Quintal]

I have Domain Aggregate listed in the middle pane of the expression
builder in Access 2003 (work), Access 2002 (home) and 97(work again)

What version are you using?

Also, the Expression Builder has an <all> category, that should show
the domain functions.

If all else fails, just enter the function manually, use the VBA help
to get the syntax, and type it in.

 

[jrbor76]

Using Access 2002 here at work. When I clicked the <All> option it only gives
me five sets of functions (Conversion, date/time, general, math, text). No
domain aggregate and no DMax either, at least in the tables I'm working on.
The weird thing is, when I'm working on my forms, I have the extended list of
all the sets of functions, including the domain aggregates. Is there
something I have to do in table view to activate some more of the built-in
functions somehow?

Otherwise, I suppose I could go into VBA and do a bunch of code (not looking
forward to it, I haven't done a lot of coding for a while before this
month... oh well, that's the price we pay)
Thanks in advance.
jrb

 

[jrbor76]

Never mind, I just found out that I couldn't set the default value for one
field based on an autonumber field in the same table if I wanted to. Thanks
for helping though.

 

[Bob Quintal]

Using Access 2002 here at work. When I clicked the <All> option it
only gives me five sets of functions (Conversion, date/time,
general, math, text). No domain aggregate and no DMax either, at
least in the tables I'm working on. The weird thing is, when I'm
working on my forms, I have the extended list of all the sets of
functions, including the domain aggregates. Is there something I
have to do in table view to activate some more of the built-in
functions somehow?

in table view? I cannot imagine why there would be any functions in
table view. But looking I see a few. Obviously, the onesdomain
aggregate functions won't work in a table.

What are you trying to do? Set up a table that adds your current
entry to the existing entry insetad of creating a new entry and
building a query to sum them?

Bob

 

[jrbor76]

I'm trying to set up a table (and subtable), one will correspond to incident
main information (client, part, etc.) and one to incident details. Those will
link to a form and subform, data can hopefully be entered either in tables or
forms. The only thing they have in common will be incident number and close
date. And we have a number of previous incidents so I'm trying to start off
at a base number (say 5000) and autonumber from there. Which I did figure out
how to do with the query. I just have to figure out how to synchronize them
so I start out at the first form which will display the first subform, then
go to the next form which will display the next subform, etc, if that makes
sense. (I think most of these will be a one-to-one relationship but I'm not
100% certain - this is a temp assignment and I'm not completely familiar with
their previous incidents.) It's been tough going but it's getting there.
Thanks for the reply