|
Testing Data Types
In BASIC there was a method of testing Data Types IsStr(String) would equal
True, IsNum(String) would equal False etc. I can not seem to find any
equivalent command in Access, there must be one. Any help please?
Thanks RayC...
|
5 |
03.09.2006 18:25:01 |
|
|
How do I get Micosoft office picture Manager onto my computer?
I am aunable to view attached pictures in my email. I need to have the
Microsoft office picture manager on my computer. How do I do that?...
|
1 |
03.09.2006 15:28:02 |
|
|
Command Button: compact data and quit application
Greetings to all participants.
I run an Access97 database.
I have created a command button on Form-A: clicking this button quits the
application.
Now, I would like to add a Compact-Data-Before-Quitting function to this
button. How could I do this?
Of course, I know there is a Compact Data Option in the Tools menu but this
database runs on a network and 3 office colleagues connect t...
|
2 |
03.09.2006 15:27:27 |
|
|
HOW CAN I DO THIS?
I HAVE AN Access projcet full with forms, i want a code that close all the
form that i opend
i tryed the End code & unload, but ithenk there is somthing missing
thanks for any help...
|
9 |
03.09.2006 14:03:39 |
|
|
Hiding / Displaying Text / Combo etc boxes
Help please
I have a form tha has quite a few Text/Combo Boxes on it and I use the same
form for different uses. This means I have to clear the form and re-populste
it with the right List / Combo Boxes for that particular use (done via
Openargs from a Menu Form). Currently, I clear the form by listing all the
boxes in the fofmat Listbox1.visible = False through to Listbox59.visible =
Fa...
|
9 |
03.09.2006 13:20:02 |
|
|
como criar uma pasta com senha ??
Como eu faco para criar uma pasta para guardar documentos , esta pasta
ficaria em minha area de trabalho...XP Home Edisao..... como faco para ter
esta pasta protegida com uma senha ???...
|
2 |
03.09.2006 12:40:32 |
|
|
Restrict query fields
hi there.
I want to know how to lock certain fields in form (which is based on a
query) so if the user tries to change them it wont affect my data tables?
--
Andres Moreno
Bogotá Colombia
Access 2003...
|
3 |
03.09.2006 11:46:28 |
|
|
quit access after a set time
is it possible to automatically quit access 97 after a given time - say one
hour after opening it?
...
|
3 |
03.09.2006 02:40:34 |
|
|
import email address from excel..
Trying to Import Excel sheet into existing table in Access 2003 with email
address as xxx@xxx.com as a column. The receiving Access table column is
defined as datatype hyperlink. After Import, clicking on field in Table view
does not open email (though one I had hard-coded in Access as
#http://xxx@xxx.com# did open).
I tried appending the #http://xx# in both Access and Excel, but still...
|
3 |
02.09.2006 19:51:01 |
|
|
Multiple Dates on a Table
I need to create a database to schedule patient appointments. I get
one piece of paper with a years worth of appointments (can be every
week or every month) and I want to be able to plug in all the dates,
then just pull each day one at a time to get my list of patients. Any
suggestions how to set that up? I tried creating differetn fields for
the weeks of the year, but then when I use a que...
|
4 |
02.09.2006 17:17:01 |
|
|
help with counting
Hey everyone, I have a small problem I've been trying to figure out how to
overcome. I'm an Incident Manager and have a few databases I use for
reporting purposes.
I work with call tracking systems and have to match up tickets from one
system to another - this is done. For a certain report I have, I need to
match up one tracking system's ticket(s) to events in another ticket (from
the...
|
7 |
02.09.2006 16:52:01 |
|
|
Setting up for use?
Hello,
I have just finished my very first Access project, a school database
which will have information entered by 2 or 3 people, but no more than 2 at
the same time. Is there a way I can "finish" it and set it up for use where
the users can pull up the main form but not have access to all the design
tools? I really have no idea about how to get it ready for the users except
that...
|
3 |
02.09.2006 16:41:31 |
|
|
What is the difference between open vs import
We have a file that is saved in DB IV format from another application.
I want to work on data in a field in this file in Access 2000 and
export it back but not change the structure or original compatibility.
Is there a difference between opening a file DB IV file and importing
(Get External Data, Import)?
Thanks,
Roger
...
|
9 |
01.09.2006 22:15:01 |
|
|
Excel formula
I need help with a formula. This is my problem:
customer penalties charged
abc 3
abc 5
abc 1
def 6
def 10
def 9
ghi 1
ghi 2
ghi 7
I am creating a new chart to figuring out the info below:
customer net $ gross $ penalty refunds
abc
...
|
2 |
01.09.2006 21:24:37 |
|
|
Data Entry Troubles
I have created a database in Access which has 8 tabs for our customer details
and those of additional applicants (mortgage). When I enter data into the
main applicant (set up on one table) the data is automatically entered into
the other applicants (set up in seperate tables). What have I done wrong?...
|
3 |
01.09.2006 21:04:22 |
|
|
Multiple Selection Options - table layout?
I want to put a sensitising field in my table (and form) that contains
various options.
However of about 10 different options any number can be selected.
For example
Item 1 can contain sensitising agent 1,4,7 and 8
Item 2 can contain sensiting agent 1,5,and 9
Item 3 can contain sensitising agent 1-10 inclusive
Can i put this into 1 field on my (product specification) table or will the
...
|
11 |
01.09.2006 16:38:45 |
|
|
a,im vont to have main on homside
eg klarer ikke å legga ut den siden eg har laga kan eg få hjelp til det...
|
1 |
01.09.2006 10:44:02 |
|
|
Question about condition in Macro Window
I'm reviewing a macro and it has a "run code" action based on the following
condition "1=2"
What does that condition mean?...
|
5 |
31.08.2006 20:36:01 |
|
|
How do I move mutiple objects from one Access project to another?
I have 13 separate Access projects, identical except for the (really
big) data sets.
I have 3 dozen obects (queries & reports) that I need t get into each
of the 13 projects.
Is there any way t di this besides moving each of them, one by ne, into
each of the 13 projects?
...
|
2 |
31.08.2006 19:29:06 |
|
|
Keeping Form Windows Maximized
I like to have my database displayed inside an application window that uses
maybe 1/3 of the space on my screen (I think this is called a "Restore"
window) and I like the forms themselves to maximized within the application
window. I've added code everywhere I could think of to keep the forms
maximized, but it seems awkward that everytime I switch from one form to
another, I see the for...
|
3 |
31.08.2006 18:50:48 |
|
|
Access reports or Word Document
I'm new to the database world and I could use some advice as to which is
better. Should I use Word mail merge to produce documents from data in
Access or produce reports directly from Access. There are a couple of things
I need to contend with first. I need to produce a report that uses multiple
data sources (two or more queries) and puts them on a single page. If I use
Access does i...
|
9 |
31.08.2006 18:39:20 |
|
|
i cant set up my email address so i can send emails. help
ive just started using outlook and frankly im having a nightmare. i cant send
emails and it keeps telling me to verify my email address, but it says for u
to go through the tools option to do this. the option it says to click is not
there :S what do i do to verify my email address so i can send emails?...
|
3 |
31.08.2006 18:12:45 |
|
|
How do you structure a database in access and use multiple word
Trying to create database with a filing system. wanting to use keywords to
describe the files...
|
2 |
31.08.2006 15:16:00 |
|
|
How to bound field to control during runtime?
Hi, all:
I have a subform, which RecordSource property is set by VBA. And
then, I want to bound one of recordset's field to a control, but It
sounds wrongly. Here is my code:
lngProblemID = Parent.GetProblemID
strSqlOptions = "SELECT Options.OptID, Options.ProbID,
Options.OptNote, Options.IsRight FROM Options"
strSqlOptions = strSqlOptions & " Where Options.ProbID = " &
lng...
|
1 |
31.08.2006 13:45:15 |
|
|
Always Losing Things
Hi,
I am always losing things so why should it be any different with the
computer? I have lost the majority of the headings on my menu. Normally
there is "File", "Edit", "View", "Insert", "Tools", "Window" and "Help."
Now all I have is File, Window and Help.
I have tried to restore, but all of the advice says "Click View". Since I
have no view to click I am stuck. How can I resto...
|
8 |
31.08.2006 13:25:02 |