|
Field Names too long?
Hi Everybody,
I am using Access 2000.
Starting to draw out a new database and in the past I have had problems in
certain areas of the database seeing the whole field name. I can see this
may be a problem with the names I have below since they would all look the
same if cut off but I tried to make them short but descriptive. Perhaps
it's in the expression builder section and or other pl...
|
8 |
08.08.2006 20:47:04 |
|
|
newbie with a giant task to complete
Hi, I am an office manager for a non-profit organization, and part of that is
our campground and rental cabins. Right now everything is being done by
hand, and I would like to try to create a database program in Access that
would act as a campground/cabin reservation system.
I am great in every microsoft office program, BUT Access. Is there anyone
out there who has the time and the no...
|
10 |
08.08.2006 19:35:02 |
|
|
How to set up a "Go to" menu with an Access combo or List menu?
In Access. how do you select from a group of records from a list and
automatically go to another screen with options to apply something to that
group of records?
Currently, I'm loading a bunch of command buttons on screens to go to the
forms and then loading a bunch of command buttons to act on those selected
records.
I'm sure there is a better way...
Thanks!...
|
11 |
08.08.2006 19:16:02 |
|
|
Create macro to change field type
I would like to create a macro to automatically go into design mode of a
table (which I can go) and change the field type in a field automatically
(which I cannot figure out how to do)..
...
|
4 |
08.08.2006 18:56:01 |
|
|
Complications on my Report!
Hi, thanks for the previous kind-hearted person who helped me. I have
yet another problem to overcome...
I'm trying to print a report with a lot of data...
Here is where my problem lies... There are a few fields (about 4) that
need to have specific values on them based on something...
For example - i have a phone number field.
if there is a phone number provided in my table - i want ...
|
3 |
08.08.2006 17:15:53 |
|
|
Date text to Date/time
I have imported a file into Access2003. All fields have come across
except for the date.Whilst it shows visually as "25Jan1991" it is in
text format.
Can somebody advise me please how to convert it to a Date / Tme field.
...
|
3 |
08.08.2006 16:46:02 |
|
|
Query
I am trying to put to different table into the query. But when I go and look
at the query in the view I don't have any records. Can someone tell me what I
am doing wrong. Thank you....
|
2 |
08.08.2006 16:35:01 |
|
|
Dropdown List
I would like to have a dropdown list in a field. Can You guide me through?...
|
2 |
08.08.2006 15:47:02 |
|
|
Hello folks !
I am trying to solve what *seems* a simple problem and my Access skills
(such as they were !) are very rusty; I'd be grateful for any help or
pointers to web resources.
Slimmed down, imagine a database that has the following record type :-
First Name
Last Name
Invoice details (date, amounts, usual stuff !)
Each record is written to a MS Word file in an invoice type layout, which
has ...
|
2 |
08.08.2006 14:50:02 |
|
|
how to clear a blurry picture
can u make a blurry picture clear...
|
3 |
08.08.2006 13:29:02 |
|
|
query before date
hi i have a query that gets fields from different tables. one of the tables
is tblPaychanges. where if and employee gets pay changes it is recorded. it
records the date of the change and the change itself.
Now in the query io want to have a column [PayRate].
how do i make a query so that the payRate before a certain date is 100 but
not after that date
Table Paychanges
PayID ...
|
2 |
08.08.2006 10:17:02 |
|
|
Can I import and Access database into Outlook Calendar?
I would like to import an Access database that pulls information from queries
based on dates and schedulesI would like it to distribute the information
into an Outlook Calendar, providing an easier read format. I was also hoping
it would automatically update the calendar by changing dates when it changes
in the Access schedule....
|
4 |
08.08.2006 05:04:02 |
|
|
Understanding "Null"
Hi Group
Access 2000 winxppro
Why is "Null" not "Less than 1"?
My field [QtyLabel] is number data type.
When the form opens on a new record the field has a zero in it. Normal
right?
My command button to preview the report has this
If [QtyLabel] < 1 then
msgbox etc...
Me.QtyLabel.setfocus
Else
DoCmd.OpenReport etc...
End If
As long as the field has a zero in it this works....
|
5 |
08.08.2006 01:30:10 |
|
|
Navigation on a form
Hello! I have a menu form on which you can either choose to add or edit a
record. If you choose edit, you pick the one you want from a combobox.
This is done via a macro.
Action = OpenForm
View = Form
Where Condition = [Forms]![Menu]![Edit_Student]=[Students]![Student_ Last_
Name]
Data Mode = Edit
Window Mode = Normal
It then takes you to that record on the next form. This all w...
|
2 |
08.08.2006 01:12:07 |
|
|
Formatting check boxes in a report
I am trying to format the check box in my report. I would like to remove the
border that is around the check box. Is there a way to do this?
Leslie...
|
3 |
07.08.2006 21:44:05 |
|
|
Display a total in a report
I’ve built a multi-table query called qryRetreatFees which selects out all
the retreat fees recorded for one individual retreat participant from all
participants. Additionally it shows the pricing factors (family type,
duration of stay) that determine each fee. The query works accurately on my
test data, producing the following results:
Registrant FeeID RegistrantType...
|
13 |
07.08.2006 19:43:03 |
|
|
sending a link via email
How do I send a link to my database via Outlook? ...
|
4 |
07.08.2006 19:42:16 |
|
|
CASE statement keeps blowing up.....
Hello All,
I created a table in Access based upon some Oracle tables. I now want
to do some more complex querying against the Access table using SQL.
One of the statements I would like to use in this is the CASE
statement, yet I keep getting Syntax Errors when I try to run the query
that contains the CASE statement. Is the statement not recognized by
Access? When I run a similar query a...
|
4 |
07.08.2006 19:31:10 |
|
|
How do i remove text effects (blinking text) from my signature?
When I open up a new email message, my signature is blinking. I never
changed any of my settings and now I can't figure out how to remove it. I
was working with a Word document earlier today and used the blinking text
effect in a portion of the font. How did this carry over into my Outlook
settings?...
|
2 |
07.08.2006 19:09:52 |
|
|
Image Link in Forms
Hi!
I'm trying to figure out how to create a field so that a screen shot can be
entered on a form. Each record would have its own screen shot. I want the
people to be able to add the image without any real trouble, such as having
to go into the design window.
The biggest problem I think I have right now is that I don't have the actual
images. I just have to make the field so other p...
|
3 |
07.08.2006 18:01:45 |
|
|
Can I refresh a combo box list?
I have 3 combo boxes, and the row source for the 3rd is dependent on the
values of the first two. The row source for the second is dependent on the
value in the first. How can I get the 2nd combo box to refresh when the
value in the first changes? And, similarly, how can I get the values in the
3rd list to refresh when the data in either the 1st or 2nd changes?
...
|
4 |
07.08.2006 17:59:22 |
|
|
Synchronizing a form with a table
Hi, I'm trying to synchronize a data entry form to work together with a
table that has a lot of entries. Here's my problem: I have a field
called First mailing date, and another field called Next mailing date.
I enter the First mailing date and want access to calculate next
mailing date by adding 3 years to first mailing date. I tried and tried
to do this in the TABLE. It didn't work successf...
|
3 |
07.08.2006 17:26:56 |
|
|
The Name Game
Could anyone help me out with this? I am building a database for my
office but I would like to make sure that my name is found on it
somewhere......and can't be changed. I've seen it in the past where
people worked hard on a database or form and then someone else takes
their work and claims it as their own. I don't want it to be visible to
everyone, just so that it is known who did this orig...
|
8 |
07.08.2006 17:06:47 |
|
|
Strategy for a databse
Hi group,
I have seen several suggestions in this forum that one should take
enough time to make a good plan for the database, rather than jumping
straight in building tables. But I have not been able to find good
texts on a strategy for the planning.
I have some experience with building a database of people, their
adresses and some other parameters. I constucted queries and reports
and...
|
6 |
07.08.2006 16:44:02 |
|
|
Database for logging telephone calls
Hi there
I work in a customer services department and we would like to set up a
system for logging and resolving telephone calls within our department.
I wondered if anyone knew of any on-line sites that may have some examples
or tutorials that may help me.
Many thanks
Carol...
|
2 |
07.08.2006 16:20:06 |