<div>
HI Jim,<br />
That Me.provid = DMax(&quot;[id]&quot;,&quot;ser_faxes_fil<wbr />e&quot;) Worked perfect.<br />
I'm a newbie, but if I wanted to add 1 to the max, what would the syntax be? <br />
<br />
thanks,<br />
Vinnie
</div>


HI Jim,
That Me.provid = DMax("[id]","ser_faxes_file") Worked perfect.
I'm a newbie, but if I wanted to add 1 to the max, what would the syntax be?

thanks,
Vinnie

<div>
I tried the Me.provid = DMax(&quot;[id]&quot;,&quot;ser_faxes_fil<wbr />e&quot;) &nbsp;+1 but got a type mismatch
</div>


I tried the Me.provid = DMax("[id]","ser_faxes_file")  +1 but got a type mismatch

<div>
Actually, I got it to work. Thanks a ton.
</div>


Actually, I got it to work. Thanks a ton.

<div>
&lt;&lt;I tried the Me.provid = DMax(&quot;[id]&quot;,&quot;ser_faxes_fil<wbr />e&quot;) &nbsp;+1&gt;&gt;<br />
<br />
If your doing this to generate a sequential number, be aware that DMax() can fail in a multi-user situation (it's possible for two users to end up with the same value.<br />
<br />
Instead, you'd use a key generation procedure which locks a table allowing only one value to be generated at a time.<br />
<br />
Jim.
</div>


<<I tried the Me.provid = DMax("[id]","ser_faxes_file")  +1>>

If your doing this to generate a sequential number, be aware that DMax() can fail in a multi-user situation (it's possible for two users to end up with the same value.

Instead, you'd use a key generation procedure which locks a table allowing only one value to be generated at a time.

Jim.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I was hoping to get some help with the following code. I have a field that I need to populate with the result of a sql select statement. Cant seem to work<br />
<br />
So when I click a button I need the field to be populated with the max of a value<br />
<br />

<pre><code id="code-10-28539534-1">Me.provid = DoCmd.RunSQL &quot;select max(id) from ser_faxes_file&quot;</code></pre>
<br />
somehow it cant seem to work. I was reading a bit and noticed that docmd.runsql is not used for select statements. Not sure what to use.<br />
<br />
thanks,
</div>
</div>


Hi,
I was hoping to get some help with the following code. I have a field that I need to populate with the result of a sql select statement. Cant seem to work

So when I click a button I need the field to be populated with the max of a value

(CODE)

somehow it cant seem to work. I was reading a bit and noticed that docmd.runsql is not used for select statements. Not sure what to use.

thanks,

VBA Insert result from sql statement into a form of a field

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.