June7's Profile User Rating: -----

Reputation: 104 Stalwart
Group:
Expert w/DIC++
Active Posts:
904 (0.41 per day)
Joined:
09-December 08
Profile Views:
9,997
Last Active:
User is offline Jan 24 2013 01:07 AM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Windows
Favorite Browser:
Internet Explorer
Favorite Processor:
Intel
Favorite Gaming Platform:
Who Cares
Your Car:
Dodge
Dream Kudos:
0
Expert In:
Databases

Latest Visitors

Icon   June7 has not set their status

Posts I've Made

  1. In Topic: Query Criteria Question: Need to insert if a record doesn't exist

    Posted 19 Dec 2012

    That does look like should work, although I would put the lower criteria before the higher.

    Provide the complete SQL statement.

    You don't want the results to be inclusive for the criteria?
  2. In Topic: Dsum based on a text value

    Posted 17 Dec 2012

    Concatenate variables. Reference to the current record ID is a variable:

    Ltotal = DSum("Donationpaid", "Donationinfo", "ClientID = " & [clientid])
  3. In Topic: Not allow Double Posting To Inventory Table

    Posted 29 Nov 2012

    This is why saving aggregate data is problemmatic. Ideally, save raw data and calculate aggregate data when needed.

    Use the BeforeUpdate event of the quantity textbox. Data controls have OldValue and Value properties. So something like:

    If Me.control.OldValue & "" <> Me.control.Value & "" Then
    'code to modify the inventory record
    End If

    Need more code in the BeforeUpdate event of Product.
    Need more code if record is deleted.

My Information

Member Title:
D.I.C Addict
Age:
60 years old
Birthday:
December 13, 1953
Gender:
Location:
Anchorage, Alaska
Interests:
snowboarding, baseball umpire
Years Programming:
5
Programming Languages:
VBA, VB, VB.Net, SQL, Fortran

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Friends

Comments

Page 1 of 1
  1. Photo

    amarbisht Icon

    18 Jun 2010 - 09:31
    hiiiiiiiiiiiiii
Page 1 of 1