|
|
#Error Textbox by
Alan
=DSum("","Billings Analysis"," = '" &
& "' AND = '" & & "'")
Right i used this code in the source code of my textbox and the textbox
keeps flashing, i...
|
|
3 |
141 |
|
|
#ERROR in textbox by
Alan
I have this code in a text box
= dsum("", "",
" = " & & " AND Format(, ""yyyymm"") = '" & Format(, "yyyymm") & "'")
i keep getting #error in my text...
( 1 2 3)
|
|
28 |
279 |
|
|
combo box look up text box error by
Alan
I used this code
=DSum("Amount",
"",
" = " & cboCustomerNumber &
" AND Format(, ""yyyymm"") = '" &
Format(cboPostingDate,...
|
March 24th, 2010 06:17 PM
by Dorian
|
1 |
119 |
|
|
|
|
10 |
187 |
|
|
|
|
1 |
122 |
|
|
sum combo box based on other combo box by
Alan
Hi can anyone help
i have two combo box which are Customer Number and Period Posting Date
coming from the same table,
what i'm after is after combo box...
|
March 23rd, 2010 11:00 AM
by Alan
|
2 |
133 |
|
|
WebBrowser.Object BackColor ?? by
Alan
Hello All
HAve put an animated gif into a form using the following code
Private Sub Form_Load()
Me.ocxWebBrowser.Object.Navigate CurrentProject.Path &...
|
|
1 |
80 |
|
|
Continuous Forms - Sum of Values by
Alan
I have a continuous sub form that uses a query that totals various aspects of
the business against departments.
I can present each field(cloumn) individually...
|
July 12th, 2008 08:10 AM
by Alan
|
5 |
102 |
|
|
date controls by
Alan
Hello,
I have a date field ona form that I'm trying to prevent the user from
entering dates in the past.
On the AfterUpdate event I wrote the following code...
|
October 11th, 2007 05:40 PM
by Alan
|
2 |
73 |
|
|
hiding button by
Alan
Hi folks,
I thought what I was trying to do was simple but it doesn't seem to be
working. I have a form where there's a date field (saveDate) of when the...
|
September 26th, 2007 09:01 PM
by Alan
|
2 |
48 |
|
|
Module to Service Multiple Forms by
Alan
This is hopefully a simple question.
I have a Sub Routine that I was given a bit of help with previously that
updates a number of captions on any form,...
|
|
2 |
58 |
|
|
|
July 20th, 2004 11:06 AM
by Alan
|
4 |
381 |
|
|
Conditional formatting in continuous form by
Alan
I read an earlier post regarding conditional formatting of rows of a
form in continuous mode. The post contained a link to Leban's site
which had an example...
|
|
1 |
135 |
|
|
query result as button label by
Alan
Is it possible to have the result of a query as a caption on a buttion.
Ie. I have a query which returns a numeric value and would like this number
presented...
( 1 2)
|
December 8th, 2008 03:24 AM
by IT-1957
|
11 |
112 |
|
|
sub total screen by screen by
Alan
does anyone know how - using a tabular form - i can display sub totals at the
bottom of a screen - eg after 20 records. then have the user press a button
to...
|
September 3rd, 2006 03:08 PM
by Alan
|
2 |
109 |
|
|
Text Button Colour on Value by
Alan
Hello All
Looking for a quick bit of advice ... I have a Form which currently contains
numerous buttons. I change the colour of the Font on each button using...
|
September 8th, 2006 06:57 PM
by Alan
|
4 |
115 |
|
|
Calling Control Info from Table by
Alan
Not sure I have the title right here, but here goes
Thanks to an earlier post I now have my Form with many buttons beautifully
coloured etc. However as I...
|
|
1 |
75 |
|
|
Fields from multiple Tables on 1 Form by
Alan Armitage
I have 5 tables with various filds.
Using the Form Wizard I can select fields from up to 3
tables and create and display a single form with the
selected fields...
|
|
2 |
523 |
|
|
form selector by
alan at work
I want Access to open a form from an open one and the key
in both cases is the date. For some reason Access ALWAYS
uses the American date format when...
|
|
2 |
126 |
|
|
Data Validation in a Form by
Alan B
I have created a data input form and want to validate a dat efield so that it
on;y accepts dates which are saturdays. I tried to use :
=weekday()=7
But it...
|
June 19th, 2008 01:22 PM
by Alan B
|
2 |
105 |