473,287 Members | 1,643 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

dcount, dsum, dlookup question (not syntax)

so i'm new to access but i've done a lot in the last 3 months since i looked
at it for the first time back then. so when i finished my first db for my
job, i cut it close to the end of the year trying to get it done in time for
january. now that i can take my time and add new reports to the existing db,
i'm left with a couple of general questions.

i got reasonably comfortable with dcount, dsum and dlookup so i used them
towards the end almost entirely. i'm pulling data directly from the tables,
w/o queries. is this a bad thing? i mean, is there anything wrong with just
using dcount and dsum to do all the calculations that i need? is it going to
harm my db in any way down the line?

secondly, and a little off the topic, what is the best way to integrate new
reports/forms that i create from today forward, for people who have the
existing version as it sits right now? how do i 'export' the report/form to
an email-able file so they can just insert it into their db?

thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1
Dec 19 '05 #1
1 2614
I believe I read an article a few years back indicating that the domain
aggregate functions (i.e. DSum, DLookup, DCount, etc) have very high
overhead when compared to a procedure using queries to perform the same
tasks. I've always been taught that calculations should always be done
inside the query if you can't store them in a table, and that
summations and counting should be done through Sum() and Count() inside
your form or report. My two cents only, not necessarily good advice.
There are others here with much more experience with Access who might
chime in.

As far as updates/patches, what my company usually does is send out a
new .mdb file and call it a patch. The new .mdb contains any objects
that have been updated or changed. The user navigates to a section of
the existing program and selects the file path to the new .mdb file.
Then our code imports all the objects in the 'patch' database,
replacing the originals with those in the 'patch' and updating a
revision table. Even modules can be updated with this technique, which
makes it pretty versatile. You have to make sure you have code in the
original program to do the import before you give it to your users,
though.

Personally, I'd like to hear what others are doing to take care of
patches, updates, and upgrades.

Dec 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alec | last post by:
Hi All, I am trying to use the DCount and DLookup functions with the WHERE expression set to: "DateToDo <= #" & Date & "#" to display all items with their DateToDo set to the current date or...
3
by: BerkshireGuy | last post by:
I am having difficulty with using the Dcount function. I am trying to return the number of records from qryIndividualFeedbackDetail where the TimelyManner field is set to 4. So, in the new...
1
by: Tony Ciconte | last post by:
I am using Acc97 and trying to get the following instruction to work in the OnOpen event of a report: DLookup("", "tblTempRevenueByFY", DatePart("m", ) = 1) The table tblTempRevenueByFY...
2
by: Diana | last post by:
I thought I had this process pretty well down pat, but I'm getting a syntax error on the following code: *****Code***** 'Check for users - can't get this to work... Dim strUser As String ...
2
by: shank | last post by:
I want to update multiple rows in an SQL table. Presently, it's populating all rows with the same data based on the first row. It's not looping through all records one at a time. Is this the...
4
by: andy143vivi | last post by:
hi, whats wrong with this code? If Me.txtPassword.Value = DLookup("", "User", "='" & Me.txtUsername.Value & "'") Then DoCmd.OpenForm "frmDetails" Else MsgBox "Wrong Log In details!",...
1
by: sahiliiit | last post by:
Can we use the dcount or dlookup function to compare a new record that we receive thru an RFID with an already existing table created as a look-up table ? What i want to do is to validate the new...
17
by: jasmineeyes | last post by:
i've beat my head on the table for this n spent hours searching the net but i cant find out whats wrong.. (btw, i'm pretty new to access..) i've got a Customers table with information on...
4
by: Bob Kraft | last post by:
I have an mdb that I am running in Vista/Access 2007 and it was working fine. I moved everything to Windows 7 and the database is working well except (so far) some DLookup commands that are coming...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.