Rounding
Tue, 26 Aug 2008 17:24:03 -0700
If I remember correctly when rounding to the nearest, the number 5 is the
cutoff for rounding up.
When I use the ROUND function in VBA for ACCESS or EXCEL that does not happen.
If I run the function: ROUND(4.25, 1) I get 4.2 as the result.
If I run the function: ROUND(4.26, 1) I get 4.3 as the result.
Now ...
|
How to change January 2008 to 1/1/2008
Tue, 26 Aug 2008 17:00:07 -0700
Hi - I'm a bit of a VBA novice. I need to take the result of a combobox
selection of month and year and convert it to mm/dd/yyyy format where dd is
always the first day of the month. Can anyone help?
--
TIA
Chuck M. ...
|
FTP Access DB to Web Server
Tue, 26 Aug 2008 22:32:19 GMT
Firstly, I apologize if this is the wrong place to ask this question and if
this question has been asked before - I have looked, but nothing I found
seems to answer my question, or either I don't know enough to realize that
they are.... Secondly, I am new to coding for FTP transactions so forgive me
if my quest ...
|
Expected End Statement
Tue, 26 Aug 2008 14:51:01 -0700
Hello,
My vb code is giving me an error after I enter and underscore to seperate my
lines...
Any ideas why? I receive the Error: Expected End Statement...
Function
Dim strSQL As String
strSQL = "Select [mast].acct_nbr, [mast].bank, _
INTO portfolio FROM mast WHERE balance > 0"
...
|
Microsoft 11.0 vs. 12.0 Object Library
Tue, 26 Aug 2008 14:00:00 -0700
I developed an application using Access 2003 SP3. I then tried to deploy it
over a network (split + MDE-FE) when began to experiece a Reference Issue.
On my computer, I only have the MS 12.0 Object Lib available. On at least
one of the user PC's, the MS 11.0 Object Lib is available.
Since the 12.0 was us ...
|
If NotInList-Change Source
Tue, 26 Aug 2008 13:33:01 -0700
I have simple cboFind that works on current data. I have an optData that
allows manual viewing of archival data. The same form then changes data
source for the forms and subforms and of course cboFind. That works fine. I
would like to automate this change. Ex: enter custnumb into cboFind >
NotInList > ...
|
Function Using Select Case for Query
Tue, 26 Aug 2008 13:15:02 -0700
Using the function as shown below, I'm trying to create a field in my query
that will give me the correct title for the rows of data. I'm calling it in
my query using: Expr1: SetInvBrkdwn(). When I run the query, the function
just loops around opening the recordset.
Can someone please help me put this fun ...
|
|
|
Function codes in Expression Builder
Tue, 26 Aug 2008 19:06:11 GMT
I am new to Access 2003 and need some guidance as to how to setup something
I have more than one customer, for example:
Redneck Springfield Index # D35 Options: NOB, STF
$3.00 discount
Redneck Sikeston Index # D20 Options: NOB, BRK, ELEC,
HYRDR, STE $2. ...
|
Date Range for Report
Tue, 26 Aug 2008 11:32:07 -0700
Hello,
I am trying to program a range of dates to determine which version of the
report that should be pulled. Here is the criteria:
rptINITIALLETTER2 = 6/1/08 and newer based from when First Letter was sent
rptINITIALLETTER1 = 5/31/08 through 12/5/06
rptINITIALLETTER = Any others before 12/5/06 or by recor ...
|
appointment database
Tue, 26 Aug 2008 11:08:18 -0700
I have a database for Oncology Research appointments. This may take some
explaining.
Let's assume I have 5 different clinical trials (protocols) opened. Each
protocol has a set criteria for when a patient needs to give blood, needs
treatment, needs an appointment, etc. (Whatever the reason.) Patient John ...
|
