|
|
Linking forms field and table field . by
aligahk06
Dear All,
I have a form but i could not move to the next record and even i could n't
save the records to the table.
How can a table and a form fields can be...
|
|
3 |
977 |
|
|
Error message when adding a new record by
forest8
Hi
This is the situation:
In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:
“The...
|
|
2 |
975 |
|
|
Report Totals by
Georgethefence
Can anyone help me please. I'm totally new to Access 2007 but have started to
design a database for my husbands shed business.
I have an Orders Table and a...
|
|
4 |
975 |
|
|
Beginner with ComboBox by
Mort
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table tblStats.
I want a combo box and will type...
|
|
7 |
972 |
|
|
Autoincrement by
Bre-x
How do I create my autoincrement number?
My Table
main_index (AutoNumber),
payee_id (Number),
main_amount (Currency),
main_receipt (Number)
if my Last...
|
May 10th, 2010 03:14 PM
by Bre-x
|
5 |
972 |
|
|
Printing in Landscape via an Embedded Macro by
Summing multiple fields on a form
I created a form and added a button with the embedded Macro that prints the
current record only. The macro arguments a select record, print record.
My...
|
|
1 |
969 |
|
|
Column Name by
Bre-x
Hi
I am using this code to send data into excel
Set rst = CurrentDb.OpenRecordset("SELECT Temp.* FROM Temp;")
rst.MoveFirst
Do While Not...
|
May 13th, 2010 07:17 PM
by Bre-x
|
5 |
966 |
|
|
Lookup fields - what's wrong with them? by
NATHAN SANDERS
Hi,
I found the following commandment on the www.mvps.org/access site.
Thou shalt never allow thy users to see or edit tables directly, but only
through...
|
|
2 |
965 |
|
|
change the value of a combo box by
Bre-x
I would like to change the value on a combo box
I am using:
Form_fmain!fmainp.pstatus.Value = "Design/Rev"
The "Deisgn/Rev" is one of the choices.
What I am...
|
April 28th, 2010 09:21 PM
by Ray C
|
2 |
959 |
|
|
|
|
3 |
959 |
|
|
|
|
6 |
959 |
|
|
Creating a Monthly Report by
SLA
I need to report data for each month from an Access database. I would like to
set up the report so that I do not have to change the query each month. I
would...
|
|
7 |
957 |
|
|
Gathering information by
kmr
I have an end result in mind, but I just cannot figure out the best way to
get to this result. I have a database on staff and drills performed. One
table...
|
March 26th, 2010 08:25 PM
by kmr
|
7 |
954 |
|
|
|
|
5 |
954 |
|
|
Saving animations in ppt slides by
PG2
I have copied an excel graph in ppt. After creating custom animations by
series, I edited some of the excel graph series so they do not animate. In
other...
|
|
1 |
952 |
|
|
Help with Function: date range by
Bre-x
Public Function my_dates(the_date As Date) As Integer
Select Case the_date
Case Between "07/31/2005" And "08/01/2006"
my_dates = 2006
case Between...
|
|
7 |
951 |
|
|
"stretch-to-fit" text box for Report by
Kathryn
I have created a query that lists what our guests had for lunches. Some have
simple two course meals - others have buffets with up to 10 items. At the...
|
March 30th, 2010 03:27 PM
by Kathryn
|
2 |
949 |
|
|
Function to add up total time taken? by
Tails
Ok I'm posting this here as you guys have been so helpful in the past.
I've been asked to do a query to work out the total working hours taken to
do a job. ...
|
|
1 |
947 |
|
|
Searching Records Using a (Global?) Module by
Lucky Man Cree
I have designed a database with three tables. The corresponding forms each
have a search function. The search function works as follows:
I click on the...
|
|
0 |
943 |
|
|
|
|
3 |
943 |