|
Update field daily
I have a request date field and a reply due date field on my form with
the code listed below on the request date after update event i was
wondering if there is a way to update this daily because after five
days its over due the problem is the only way to change it from a date
to overdue is too reenter the date it also shows up on a report so any
help is cool thanks in advance
Dan
Privat...
|
4 |
12/27/2008 11:39:45 PM |
|
|
STARTUP OPTIONS
I've created a switchboard which comes up automatically when the database is
started up.
This works fine but here's the situation.
I'm giving the database to someone to use and in the startup options I've
removed the the following: Display/Forms/Page Unchecked Display Database
Window and Status Bar. In the Menu Bar section unchecked Allow Full Menus
and Allow Default Shortcut Menu...
|
3 |
12/27/2008 4:37:36 PM |
|
|
Duplicated values in subform
First off, I hope your holiday was wonderful & that 2009 will be both happy
and healthy. Thanks for all your help this past year, and thanks in advance
for all your help in years to come.
Now...
I have a subform based on a query. The query functions as expected without
duplicating values, but in the subform, some values repeat. How do I avoid
"seeing double" in the subform? (Actually...
|
7 |
12/27/2008 5:46:27 AM |
|
|
Display Query Information on a Form (Access 2007)
I have a form where a user enters contributions received from individuals.
The user chooses the individual from a combo box that lists all the
contributors (ContributorID, LastName, FirstName). When the user finds the
right contributor and selects it, I would like all the other information
about that contributor to be displayed down below on the same form ... only
showing their Address...
|
5 |
12/27/2008 3:21:02 AM |
|
|
Why does it keep changing back?
Hello-
Getting kinda frustrated with a form......
I have a main form & a subform. The subform I want to be an entry
form...but when I put it to "data entry" in the properties, it keeps changing
back to not a data entry form..........
WHY???? haha its making me crazy!
thanks!...
|
12 |
12/26/2008 2:56:05 PM |
|
|
Form Objects have disapeared
I have a 2003 DB used both in 2003 and 2007 Access "clients"
The "main" form has a list box control, three text boxes with buttons (for
filters), and two other buttons (one to close DB, other to open another form).
The form now appears blank, but the visability is on for ALL the objects.
I'm at a loss as to why my form that was working is now blank but the form
designer shows everythi...
|
3 |
12/26/2008 2:07:00 PM |
|
|
please i want some help in this problem by using code
i want to calculate the following using code in the form or by Ex builder:
I work in company that takes 2 days for weekend it's Friday and Saturday
and all the holidays that may be more than one day such as Eid El Adha
is more than 3 days continuously.
So i made a form for entering the vacation for each employee in the company
like the following :
the main form :
Emp name , Department , and...
|
3 |
12/26/2008 1:33:34 PM |
|
|
Sample form for setting query parameters
A while back i saw a sample form that created many different types of
parameters for a query. i cant seem to find it again. Does any one know
what i am referring to?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1
...
|
3 |
12/26/2008 1:14:06 PM |
|
|
tab control
How to determine the current tab page?...
|
2 |
12/25/2008 7:04:07 PM |
|
|
Split Froms vs. Subforms
Hi all,
I posted this question yesterday and received notification that someone
responded to it, but the message disappeared and is no longer there and I
could not read the response. So here I go again. what are the advantages and
disadvantages of using Split Forms vs. Subforms? I have a lot of questions on
both.
Thanks for the help,
Gary...
|
2 |
12/25/2008 3:46:44 PM |
|
|
Can't Format Text Box
I am computing a value using DSum in my SQL Statement.
When I select this value to display on my form as the Control Source
for my Text Box, the Format selections are not available for me to
choose "Currency". Even if I try to provide my own format for
currency, the text box does not display the values as currency.
Can someone explain?
...
|
3 |
12/25/2008 1:02:00 PM |
|
|
Access 07 conversion from 03: Switchboard form functions not conve
When I convert my 2003 Access application into the 07, switchboard form
functions from 03 are not available in the converted 07.
How can I make the conversion complete with enabling ALL the switchboard
form functions.
Thank you....
|
2 |
12/25/2008 11:12:36 AM |
|
|
Subform in Read only on Tab Control.
I am Creating Purchase Order Scheduling Form.
There are 3 tables 1) Po Master , 2) Po Details 3) Po Schedule.
Table 1 is linked to 2 with O2M relation, Table 2 is linked to 3 with O2M
relation.
I had put Po Part Subform (Data Sheet View) on Main Form with Tab Control.1
It works fine. I am trying to Put Delivery Shedule Subform on Tab Control.2
without creating Parent/Child link as...
|
3 |
12/25/2008 5:33:00 AM |
|
|
Spilt Form vs. using Subforms
I am new to this and am trying to decide between using a split form or a
subform to display my information. Can some one help me out with the
advantages and disadvantages of both?...
|
2 |
12/25/2008 4:14:19 AM |
|
|
Two Field Search Criteria
Experienced on Access, very newbie on code
Looking to put something on a form to allow search for a record which meets
criteria for two fields. For example:
Enter the first few letters of their CompanyName (requiring user to enter
wildcard is OK e.g. General*)
Enter their city
It could either find the first record which meets those criteria or filter
for all records which meet ...
|
2 |
12/24/2008 9:32:58 PM |
|
|
filtering tabbed control
Hi
I'd welcome advice on tabs please, I've never used them before but I can see
how they might be useful.
I have a finite database of 600 or so CurriculumStatements in 25
CurriculumAreas. FormStatements has all 600 expressed in datasheet view, but
I would like to subdivide this datasheet into separate tabs for each
CurriculumArea.
where or how do I go about the filtering process?
T...
|
2 |
12/24/2008 9:24:17 PM |
|
|
Converting currency value to text value for bank checks.
I fill and print Bank Checks using Access 2003. As you know Checks have two
fields for currency. One for number ($21.00) currency and another for text
currency (Twenty One Dollars). How can I Program the text field to look at
the currency number field and covert its value to text and fill the text
value field.
--
Bardia...
|
17 |
12/24/2008 7:39:01 PM |
|
|
Error "Object variable or With block variable not set"
I have a form I use for one button clicks for reports. I am getting this
pesky error above when I use the button wizard. The form does not point to
any table since it is used just for generating reports. My code is below. Can
someone help me? I am lost and the stuff I find on the net so far is of no
help to me.
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
Dim st...
|
3 |
12/24/2008 4:47:17 PM |
|
|
Simple help - Sendobject (false)
Hi,
I need your help.
It works for me to send the email and it got pop up Groupwise. Is
there a way to turn it false without seeing Groupwise.
DoCmd.SendObject objecttype:=acSendReport, _
ObjectName:=strDocName, outputformat:=acFormatHTML, _
To:=strEmail, Subject:=strMailSubject, MessageText:=strMsg
Above code, how to make this turns false without opening groupwise.
ex...
|
1 |
12/24/2008 4:25:29 PM |
|
|
filtering tabbed controls
Hi
(2nd posting, 1st appears to have disappeared!)
I'd welcome advice on tabs please, I've never used them before but I can see
how they might be useful.
I have a finite database of 600 or so CurriculumStatements in 25
CurriculumAreas. FormStatements has all 600 expressed in datasheet view, but
I would like to subdivide this datasheet into separate tabs for each
CurriculumArea.
wher...
|
2 |
12/24/2008 2:27:15 PM |
|
|
Sort search on combo box
I have a combo box that has the values 'i item' and 'internet' as items in
its list. I have Access running on several computers. On one computer, when I
type i followed by n the combo box locates 'internet'. On another computer,
when I type the n after the i, the combo box goes to the top of the list.
Any ideas. It appears to be a setting in Access, but I have no idea where to
look.
Than...
|
2 |
12/24/2008 5:13:00 AM |
|
|
2 tables 1 form with out a sub form
I am trying to create a form where I can look up the command and enter the
personnel. I don't know why this is so hard. I would apreciate any help. I
am using office 2003
TBLHSTPersonnel:
HSTNameID - Auto
HSTCommand - Number
Rank
Last Name
First Name
MI
Ect...
TBLCommand:
CommandID - Auto
Command Name
UIC
POC
POC#
Thank You!!!...
|
2 |
12/24/2008 4:46:01 AM |
|
|
Updating a field in a SubSubForm
I have a Main Form, SubFrm 1 and SubFrm 2. SubFrm 2 is imbedded in SubFrm 1.
In Sub1, I have a Yes/No Option box, with a corresponding Option box in Sub2.
When the user ticks the Option box in Sub1, I want it to automatically
update the Option box in Sub2.
The only way I have accomplished this, is by a Macro attached to the Option
Box in Sub1 which uses the SETVALUE action to update S...
|
6 |
12/24/2008 3:46:16 AM |
|
|
'invalid control property' and 'too many fields defined'
Almost had finished building a set simple data entry forms when everything
turned to custard! help!
brief structure description-
10 tables linked by a single key (Primary in one table only)
a series of tabbed forms linking to table fields.
what happened:
on last form page tried to place a table field in and Access said:
"No fields available to be added to the current view
The current ...
|
5 |
12/24/2008 3:46:11 AM |
|
|
women Air Max 95 360 man
( paypal payment )( www.king-trade.cn )Air Jordans Air Jordans 1 Air
Jordans 2 Air
Jordans 3 Air Jordans 3.5 Air Jordans 4 Air Jordans 4.5 Air Jordans 5
Air Jordans 6 (
paypal payment )( www.king-trade.cn )Air Jordans 7 Air Jordans 8 Air
Jordans 9 Air
Jordans 10 Air Jordans 11 Air Jordans 12 Air Jordans 13 Air Jordans
14
Air Jordans 16
( paypal payment )( www.king-trade.cn )...
|
1 |
12/24/2008 1:47:42 AM |