|
Printing multiple pages
I am creating a database that will eliminate a current form. The form is a
three part carbon form where we need to turn in each of the different color
pages to different departments. Is there a way to print a form in access
where it prints 3 pages each time with a different text box on each
indicating the department?...
|
7 |
12/26/2008 6:16:04 PM |
|
|
Opening files from within access
I would like to create a button which will open a windows browser to a
specific folder and allow the user to select a text file and to be able to
view the file. I know I can link to a specific text file but need for the
user to be able to select the specific file they need. Is this possible?
Thanks....
|
3 |
12/26/2008 6:07:54 PM |
|
|
query question
hi, i have 2 tables contract and payment under payment i have field
pay_for(date).
i want to see all contracts that dont pay for example 10/08.
--
golani...
|
2 |
12/26/2008 6:05:18 PM |
|
|
Question response
I posted a question in the Access forum a few days ago and got an email that
there was a response. But the link in the email doesn't work, I can't find my
question (let alone any response) by searching, and the Contact Us at the
bottom of the forum page points to a non-exisiting page.
What's going on out there?...
|
3 |
12/26/2008 5:57:39 PM |
|
|
Tabbed datasheet
Hi
2nd Question of the day for me, very grateful for any help.
I'm using Access 2007 and discovered tabbed controls but Access Help doesn't
answer my question on using them.
I have a datasheet (formStatements) showing CurriculumStatements with
associated supporting Documents . There are 600 CurriculumStatements in 25
CurriculumAreas. For ease of viewing, I would like to have each
C...
|
8 |
12/26/2008 5:27:45 PM |
|
|
Parameter value?
When I open one of my forms, each parameter box comes up for the fields.
It's more of a nuisance than anything but it takes time to go through all of
these boxes before the form opens up. The other forms don't do this. Can
anyone help me on this? Thanks!
--
SDW...
|
2 |
12/26/2008 5:18:16 PM |
|
|
Trapping #Error on Query
Hi,
I have a text field in a query.
I want to separate this field to two different fields by using CDbl()
function. (Double and Text separated).
I get #Error when I run CDbl() on text field.
I tried to use iif(IsError(Cdbl(textfield)), "Text Value", CDbl(textfield))
but the result is still #Error instead of "Text Value".
Can the #Error be trapped somehow ?
Thank you in advance.
S
...
|
3 |
12/26/2008 5:09:32 PM |
|
|
AutoNumbers in Access
I have created two tables that each generate a different PO number for us.
One starts with a letter followed by number, ie, A001 the other starts with a
56-A001. After these numbers are generated, I try to append them into another
table so I can have all the PO's in one table to create a report. Each time I
do this, I loose my prefix, ie the "A" or the "56-A" and all I get are just
the n...
|
4 |
12/26/2008 5:09:00 PM |
|
|
Place DB on a Web Site
How can I place my Access 2007 Data Base on my Web Site so others can update
and add data?
--
Bill...
|
3 |
12/26/2008 5:06:01 PM |
|
|
Please Help
Hello,
I am trying to figure out how i can make a form and enter info without it
being displayed when i go back to enter more info....
|
5 |
12/26/2008 4:47:43 PM |
|
|
Parameter Value ?
--
SDW...
|
1 |
12/26/2008 3:48:02 PM |
|
|
Access Import - Strange Behavior
I've been successfully using Access 2007 to import sheets from Excel 2007 for
several months. Last week, without any changes to my computer (that I'm
aware of, other than MS automatice updates), when importing I get a message
that the Excel file is in an Office 2007 beta format and cannot be used. I
never had Office 2007 beta on my machine. After a systematic set of
diagnostics, I fou...
|
5 |
12/26/2008 2:43:01 PM |
|
|
Microsoft Vista
I have had an new computer since mid November running Vista. About 2 weeks
ago I lost the ability to access the demo version of an Accounting package I
was using. I've lived with that for the time being.
About 4 evenings ago I sent some e-mail, and using Office Outlook, which I
was not overly familiar with, having used Outlook Express for a number of
years. After sending e-mails I ...
|
3 |
12/26/2008 1:12:19 PM |
|
|
Limit to List Solution
In the past, I posted (although I can't seem to find it - perhaps in a
different newsgroup?) a request for help on a "Limit to List" problem,
where I wanted to set it to "No", but because my bound column (an auto
number) was not visible (and therefore, the actual value of the
unbound field), Access would not allow me to do so. No one was able to
recommend a solution. However, I have since sol...
|
1 |
12/26/2008 10:40:40 AM |
|
|
Stripping characters
Hi
How can I strip all non-digits from a string?
Many Thanks
Regards
...
|
3 |
12/26/2008 10:10:42 AM |
|
|
Security
How can i secure a form / query / table with password, or have logins? if the
solution is logins, will there be a variable of who logged in? ty in advance...
|
7 |
12/26/2008 7:29:25 AM |
|
|
take part in the new group
I first take part in the new group,I feel very happy.
...
|
4 |
12/26/2008 7:21:41 AM |
|
|
question on dlookup
If I have a table filled with records of days, say
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
and I have a query that has a select that it only include records
where the day entered exists in the table, i.e. by doing DLOOKUP, is
that a valid way to validate data entered?
For instance, so someone doesn't inadvertently enter "Sunderday", or
Thuesday".
Does that make...
|
4 |
12/26/2008 6:59:37 AM |
|
|
incorrect office product key after xp downgrade
I just bought a Sony Vaio laptop that came with Windows Vista Business. The
first thing I did when I got the laptop was downgrade it to xp using the
downgrade discs.
It seems like the downgrade to xp was successful. I didn't encounter any
problems. However, I just opened microsoft word and entered the product key
that is on the bottom of the laptop. It keeps saying the key in inco...
|
3 |
12/26/2008 4:26:02 AM |
|
|
how do i access my computor files whilst away
i will need to access my pc files whilst travelling and understand there are
several reputable programmes that all ow me to do this. would be gratefull if
you could let me know there names. thank you....
|
2 |
12/25/2008 10:11:09 PM |
|
|
Test
Ffg
...
|
2 |
12/25/2008 9:59:33 PM |
|
|
parlez vous francais
De: "David W. Fenton" <XXXusenet@dfenton.com.invalid>
Objet: Re: Seek method after split database
Date: mardi 23 décembre 2008 04:07
=?Utf-8?B?ZGhzdGVpbg==?= <dhstein@discussions.microsoft.com> wrote
in news:44D9017C-A55B-4F5C-8AD6-765500837013@microsoft.com:
> I know there's a way to use the seek method after splitting the
> database.
Don't.
Really.
It is n...
|
2 |
12/25/2008 8:45:29 PM |
|
|
Custom Buttons
I have been playing around with using rectangles and labels as
buttons. However, I was curious what others have come up with to
create their own buttons. As my visual designs are changing, I'm
hoping for something a little more up-to-date and jazzy - and being
more able to control what the buttons look like, in spite of the users
OS.
Also, in playing with the rectangles and labels, there i...
|
7 |
12/25/2008 7:42:34 PM |
|
|
Property information
I want to look up owners of properties using MD property search. the link I
am trying to automatically enter the address is below. Can anyone help?
http://sdatcert3.resiusa.org/rp_rewrite/searchtype.aspx?County=03&SearchType=street
...
|
7 |
12/25/2008 7:13:01 PM |
|
|
Syncronize - Remove old Paths from Options
I syncronize my databases from my laptop to my main PC. I recently moved my
files from my main PC to a server. Now when I syncronize, the menu for
syncronization shows the old location of the file first (they are in
alphabetical order) and I have to click the drop-down menu and select the new
location. Is there a way to remove the old locations from the drop-down
menu? It is a minor t...
|
6 |
12/25/2008 7:06:45 PM |