|
Command button to save record and generate new form
I have a form which is used for data entry. The form has a command button
which when clicked saves the record to a table. How would I set the command
button to not only save the record when clicked but to also re-generate the
same blank form or simply just clear all the fields?...
|
3 |
10/6/2008 2:31:02 PM |
|
|
Troble generating query in with its Dates in Chrnological order
I have to create a report by monday, and when I run a quary for monthly
expenses, the months come up in Alphabetical order insted of chrnological
order, and the report generated comes out the same way...
|
3 |
10/6/2008 12:25:00 PM |
|
|
School Database
Hello everybody,
I am creating a school database. I am new to MS Access. I need to create
database for monthly fee receiving. As you know that there is academic
session. I need to create dab for a particular session say 2008-2009. How do
I create table and make their relations. Do I create a seperate table for
months and seperate tabel for sessions. Do I have to keep on adding sessions ...
|
5 |
10/5/2008 11:27:47 PM |
|
|
Relationships, forms and command buttons
I am building my first database. It has two main tables linked in many to
many relationship - tblIndividuals and tblOrganisations - and a number of
linked tables. I am trying to normalise the database, and reduce the number
of fields in the main tables. However, I'm hitting up against a couple of
problems. Many to many relationships are working fine.
However, the individuals main table ...
|
9 |
10/5/2008 10:03:00 PM |
|
|
Outlook Office 2003 Moving Sent Files to other Folders changes dat
After moving Sent folders to Personal Folders for each year (for organizing
and archiving purposes) each new folder no longer has a column for date sent.
Only date received appears at column head and all dates are date and time
moved. Suggestions appreciated...
|
2 |
10/5/2008 1:47:20 AM |
|
|
exporting outlook express messages to Vista outlook
Can import my email messages to windows mail? If so, how do I do it?
Please provide specific instructions as to how I can do it. I want to give
my old computer away, but am unwillingly to do so until I can get my xp
outlook express email messages moved to my new vista computer.
Thank you.
...
|
2 |
10/5/2008 1:46:31 AM |
|
|
Relating fields to other fields
Problem Setup:
I have a Wildflower database that I have created, with each wildflower
having a unique ID (as well as unique common and latin name). Each
wildflower belongs to a family, which I want to be able to select based on
either the common or latin family name. Families names are stored in a
different table with a unique ID for each family.
Question:
How do I add both the comm...
|
4 |
10/5/2008 1:01:01 AM |
|
|
full listbox
my users have discovered a limitation to the listbox control. i believe the
listbox can only store around 33000 characters when using a value list as
the rowsource. if i use a query i can get everything they want in there,
but i can't add a selected item to an adjacent listbox and remove the item
from the orinal listbox.
how do i solve this problem?
tia,
mcnewsxp
...
|
2 |
10/4/2008 5:05:55 AM |
|
|
reformatting text??
I've created an access query & report. When i run the report i get small non
printable squares separating the text. i'd like to replace thses squares
with a carraige return but i've go no idea how to do this. Can anyone help??...
|
4 |
10/3/2008 5:11:02 PM |
|
|
Enter and Edit Data in a Query (or form based on the query)
I remember reading an article somewhere on the Web that reviewed the
circumstances under which it was not possible to update data in a query.
I can not find it.
I would be grateful if a kind soul to direct me to information that would be
pertinent.
Thank you,
Pepper...
|
3 |
10/3/2008 11:20:11 AM |
|
|
Creating Expression (Formula)
Hi,
I have created forms by using the Wizard from table.
In form there are two comboboxes named"Biceps" and "Elbow" and one textbox
"Total" . Now for example, if score of "Biceps" is 2 and score of "Elbow" is
3 then "Total" of values should be 5.
How can I creat a formula (Expression) that automatically adds value from
field "Biceps" and "Elbow"?
Please help....
|
2 |
10/2/2008 7:33:20 PM |
|
|
Eat Cookies and Loss Weight. See How
Hi Cookers,
Welcome to our new website, cookersworld.com. We
have expanded the content links to ad Summer Weight
Loss Recipes. Lose weight eating cookies and more! Get
into shape for the summer! We have easy to make recipes
for all weight watchers!
The website is full of great links from our partners. Please
stop by and support us. Visit all our links and choose the
best websites ...
|
1 |
6/30/2007 8:31:06 AM |
|
|
Lookup Box
I have a Lookup Box on a Form that looks up specific numbers (No Duplicates
allowed) and an After Update Event Procedure to alert the user if they try to
duplicate the number.
This number can be deleted as required. The problem is if someone
accidentally deletes the number and tries to re-enter the number straight
away, the Message appears that duplicates are not allowed. If the user
...
|
1 |
6/30/2007 7:28:01 AM |
|
|
Calculating numbers, part 2
To Ken and others who can help...
I tried to follow Ken's instructions (reprinted below) very carefully but I
did not get them to work for me.
Here's what I did:
First, I created the DocumentsIssued table with the following
fields: Form_Number (which I tried to link to my Forms#_Title table), the
StartNumber, EndNumber and NumberIssued. Then I created a DocumentsIssued
Form and ...
|
19 |
6/30/2007 12:54:00 AM |
|
|
Locked out for no reason
I didn't even set up my security protocols, and some how I have a dialog box
prompting me for my password. It has a name and password box, but I never
set up a login with my name on it, but there it is? How does this happen?
I'm locked out of Access all together. What the heck am I supposed to do?
...
|
3 |
6/30/2007 12:33:49 AM |
|
|
Calculating numbers, part 3
Although someone (ken?) responded to this question, I am unable to find the
reply...
Hi, Ken,
I should have mentioned that I went with your suggestion of using the
date/time value with the following as the Control Source:
a=Nz(DSum("Number_Issued","DocumentsIssued","Form_Number =""" &
[Form_Number] & """ And DateTimeIssued < #" &
Format([DateTimeIssued],"mm/dd/yyyy hh:nn:ss") & ...
|
1 |
6/29/2007 11:08:04 PM |
|
|
Linking to Excel, getting #Num!
I need to be able to keep a database in Excel, but link it to Access. I have
done this, and everything is fine except in the zip code field and some phone
numbers. In my Excel spreadsheet the zip code field is formatted as
special/zip code+4. Most of these show up on the Access table as #Num! If
at all possible I would like to keep the information in Excel instead of
importing it. T...
|
15 |
6/29/2007 8:20:01 PM |
|
|
Scrolling through records in a form (cannot fast scroll using mouse)
I now have Access 2007, and cannot scroll fast through records in a form
like I could in Access 2000. Is there a way to turn something on, so I don't
go one record at a time? I have to scan one record at a time to get from
record 1 say to 350. DB has over 500 records. Why did they turn off the fast
scroll?
I asked this question in the Forms group, but didn't get an answer.
Thanks in adva...
|
3 |
6/29/2007 8:07:12 PM |
|
|
After Update Event Procedure
I have an After update Event procedure as follows:
Private Sub Envelope_Number_AfterUpdate()
If DCount("*", "[Main Table]", "[Envelope Number]=" & Me.Envelope_Number) >
0 Then
MsgBox "SORRY, THIS NUMBER IS ALREADY IN USE. IF YOU WISH TO ALLOCATE
THIS NUMBER, YOU MUST REMOVE THE NUMBER FROM THE MEMBER TO WHOM IT IS
CURRENTLY ALLOCATED. PLEASE NOTE THAT YOU MUST NOT RE-ALLOCATE ENV...
|
8 |
6/29/2007 4:26:22 PM |
|
|
I want to add multiple names to a field from a list box, how?
I need to be able to add multiple names to a field on a form from a list box.
I have a form that records training sessions, and I need to be able to add
multiple names of people at a session to the name field, this is selected
from a list box.
Any help would be greatly appreciated.
Thanks...
|
6 |
6/29/2007 3:30:02 PM |
|
|
New to functions in Access
Hi I am fairly new to Access. I see code posted for various functions but
have no idea how to use this. Does anyone know of any simple guidance which
would explain the procedure for me?...
|
2 |
6/29/2007 2:27:43 PM |
|
|
Open two access databases simultaneoulsy
Access newbie. Win Xp. Access 2003.
I need to open two tables side by side to compare them but the tables
reside in two different access databases. Is it possible to do it
without linking or importing one table into the other db.
TIA
- samah
...
|
3 |
6/29/2007 1:37:04 PM |
|
|
Required field ... but only with certain information
I have a boolean command to enable some fields based on the result of an
option in a combo box.
Although the "required" property is set to "no", how can I ensure these
fields have been filled in (or changed) before the record is saved.
Cheers!...
|
3 |
6/29/2007 1:04:03 PM |
|
|
date field
I need to enter a date but it will be year,month,day ex: 07/06/26. How do I
put this in the input mask? Thanks in advance....
|
5 |
6/29/2007 12:50:01 PM |
|
|
Ribbon
Does anyone have a list of the default idMso values for the default Ribbon
tabs? All of the examples I've seen reference "TabHome" and "TabCreate", but
I haven't been able to find the idMso names for the other tabs, ie. "External
Data", "Database Tools", and "Datasheet".
--
Best Regards,...
|
4 |
6/29/2007 12:06:49 PM |