how to calculate days
Mon, 15 Dec 2008 11:35:02 -0800
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 , Departme ...
|
Access forms fill in
Mon, 15 Dec 2008 10:52:09 -0800
I am trying to create a form that will have fields such as customer name,
address, city, zip....I want the form to automatically populate the address,
city and zip fields when I choose the Customer name from the drop down box... ...
|
Auto fill existing record, allow new entry
Mon, 15 Dec 2008 10:16:27 -0800
I think this should be fairly simple to fix. I currently have a form with a
sub form (with another subform) and they are linked One-to-Many from the main
form down to the the third subform (three tables in total). In the main form
header, I created a combo box that allows me to type in a customer's phone
nu ...
|
How do I rotate a Text Box in access form
Mon, 15 Dec 2008 10:08:11 -0800
I tried downloading the API thats out there but I'm new to access and must be
missing something. Can someone help?? ...
|
How can I not save certain data?
Mon, 15 Dec 2008 12:23:48 -0500
Hello and thanks for any help you can provide. I'm new to Access
and I'm in the process of creating a very simple order form to take
phone orders with. Nothing too complicated.
One section is where we will input the customer's credit card information.
Question 1: Is there a way to have this information aut ...
|
Changing combobox lookups
Mon, 15 Dec 2008 06:36:04 -0800
I have a form with two combo-boxes, say MasterType and SubType.
MasterType has the values A and B. SubType has the values:
A 1
A 2
B X
B Y
I put code in the OnCurrent and in MasterType's OnChange event to Requery
the SubType. This works fine for data entry, but in a datasheet view, when
I'm on MasterTyp ...
|
A2007 - open the same form several times
Mon, 15 Dec 2008 01:28:23 -0800 (PST)
Hi NG,
has anybody experience with the issue that it's possible to have
the same form opened up more than 1 time in the same Access-Session.
Should this be prevented, means not beeing allowed?
Should it be the standard, that it is only possible to open it once?
What could be the impact of this possible ...
|
|
|
Creating a form tabs
Sun, 14 Dec 2008 20:41:00 -0800
First of all thanks for any assitance. I am a self trained Access user.
I created the database from scratch (no template) I have downloaded some
Templates and obviously they look great compared to mine. My skill level
is pretty much novice. The form I use is for making calls and tracking a
prospect d ...
|
Errors loading/opening forms using command buttons
Mon, 15 Dec 2008 14:15:25 +1100
Hi Guys and Gals
I have a database that was originally created in Access 2000, then modified
in 2003 before I got it. I have since upgraded it to a 2003 format file and
it has since been modified in both Access 2003 and 2007 depending on what I
was doing.
All of the original objects have been deleted aft ...
|
Cannot Open Recordset
Sun, 14 Dec 2008 18:31:01 -0800
Hi,
I have a form open that is using tblRiskAssess as its Record Source. On the
form is a command button that allows a user to initiate an 'archiving
process' that is intended to change the status of another record on
tblRiskAssess to 'Archived'. The code that is intended to complete this
process is as foll ...
|
