|
Syntax Question
Hello! I have this for the rowsource of a dropdown box on my form.
Findname is my query:
SELECT FindName.[Student_ Last_ Name] FROM FindName ORDER BY [Student_ Last_
Name];
This may be a dumb question, but I have tried it over and over and I always
get a syntax error. How about if I want to include Student_First_Name so
that last name, first name are shown in the box? How should I...
|
4 |
11.09.2006 05:35:43 |
|
|
Pass by reference?
Is there a way to put a parameter in a function and let the caller see the
changed value? In another language I would do it by declaring the parameter
this way as_StringParam by reference.
If not, how do I get at more than one result in a function or sub? I have
a function which returns a value I want, but I'd also like to get at the
values in an array that it creates when it does ...
|
4 |
11.09.2006 00:23:57 |
|
|
Between If Statement
I can't quie get the synatax for a between statement.
Any help appreciated.
Thanks
DS
If Me.D34 is between 29 and 31 Then
Me.TxtDay = Me.D34
Me.TxtDate = Me.TxtMonth & "/" & Me.TxtDay & "/" & Me.TxtYear
Else:
Me.TxtDate = ""
End If...
|
6 |
11.09.2006 00:18:19 |
|
|
Pop up Forms
Hey all,
Have read through all the posts I could find about forms and pop-ups and all
seem to be a little advanced for me to understand what I should be doing.
What I am trying to do is have a primary form "Centre information" and want
anoter form "Council information" to pop up when the "council name" field is
clicked in the primary form.
Any help appreciated but please keep the la...
|
7 |
11.09.2006 00:10:02 |
|
|
how to fix error 0x800CCC3E
i have a roadrunner email account. When i try to set it up though it keeps
saying send/recieve error 0x800CCC3E. How do i fix this?...
|
2 |
10.09.2006 23:26:11 |
|
|
Please HELP!! beginners problem with the lookup table
Hi I have created a table to collect personal information such as name, age
of client etc, 1 of my fields is to find out the place they would most like
to visit abroad, i want to create a lookup table where by i can add submeunus
for example, when they come to fill in the information, the field reads ideal
holiday destination, the drop down menu lists USA & CANADA, CARIBBEAN, ASIA
etc a...
|
3 |
10.09.2006 17:55:02 |
|
|
Strange
Hi. I have a Form that looks up Customer information via a number of Combo
Boxes. The Text Boxes are Bound to the Customers Table and the "find" combo
Boxes arte unbound. I use the following External Function to locate the
record and set the bookmark to the record so the Text boxes show the
information held in the record. I then place the apropriate info into the
various "Find" Combo Box...
|
5 |
10.09.2006 16:32:01 |
|
|
Print Relationships Problem...
Good news is that I just finished completing my first big Access Program.
It even seems to be working okay.
Bad news is that I wanted to check the relationships with a printed copy,
but I got the follwing message: "Object variable or with block variable not
set" and it stopped me in my tracks. I couldn't print out the Relationships
Page.
However, the program seems to be worki...
|
2 |
10.09.2006 08:26:02 |
|
|
Tabledesign - Howto
Hi
Being new to Databases/Access I hope someone can help me with this:
I'm trying to build a database (Access 2003) to handle participants
evaluations of various courses. After completing the course participants are
requested to fill out a total of 20 predefined questions. I want to connect
these answers with a specific person (participant) on a specific course.
My problem is how to des...
|
6 |
09.09.2006 20:41:01 |
|
|
help with this simple query,,, im just too new with this
simple -----> this is what i can do----result of my query example:
IdContrato sequence wight
1 01 3000
1 02 2000
1 03 1000
2 01 500
2 02 200
3 01 3000
3 ...
|
4 |
09.09.2006 20:22:02 |
|
|
Access wizard will not appear, even with security level at "low"
I want to create a new Access database using the wizard. But I cannot get
the wizard to start. I checked my security settings, and lowered them to
"Low" but I still can't get the wizard to start. I've heard of "sandbox"
mode but don't know how to check to see if I'm running in that mode. I'm
running Access 2003 in XP SP2.
Thanks in advance!!
Vivian...
|
3 |
09.09.2006 18:08:01 |
|
|
opening acces
Hello
XP office Windows XP home Sp2
suddenly i can not open any of my access db. My computer require a
password to open a "session". I am the only user I have a password for
my computer as a whole , tired it but it does not work for access .
I never protected my databanks with a password and up to today had no
problem. Now I can't even open the examples DB
which come with office
I tri...
|
4 |
09.09.2006 15:23:15 |
|
|
Listbox selection. to another listbox of that selection...
How do you set-up a Listbox to make a selection, and then show another
Listbox that allows follow-up selections of the original choice? For
example: If I choose "Colors" as the original selection, I would like to
choose from the "Red", "White", and "Green" colors from another listbox.
I'm using Access 2000.
Thank you!...
|
5 |
09.09.2006 14:40:02 |
|
|
Keyboard shortcut...
Is there a keyboard shortcut that shows a complete line of text? For
example: When checking a SELECT, FROM, ORDER BY text that is too long to view
can you use a keyboard shortcut to view the total phrase? I know that Excel
has one, does Access have one?
Thanks!...
|
5 |
09.09.2006 14:35:01 |
|
|
can you display a table caption on 2 or 3 lines in Access?
My field name is too long to display nicely in the table. Can it be split
into 2 or 3 lines?
Thanks...
|
2 |
09.09.2006 12:40:34 |
|
|
Connecting two forms with the same table
Hi everyone,
I'm a beginner in access and I've been having some problems with it.
Here is my problem for now. I have two forms which are supposed to
store data in the same table. Not just the same table but the same row
and different colums.
For example: the data from the first form are stored in the first 5
colums of the table and I want the data from the next form to be stored
in the same...
|
5 |
09.09.2006 01:46:41 |
|
|
how do i do a reinstall forr every thing
please help my friend has wiped her comp and needs to reinstall and dose not
know how please help
...
|
2 |
09.09.2006 01:39:35 |
|
|
Passing value to string expression
Hi,
I am trying to pass a value to a string expression so that I can get a note
to display saying, for example, "The last form number used was 12." (with12
being an example of the value passed from a query qryMaxFormNumber, where the
Total of the FormNumber field is set to Max).
I have tried writing a query which concatenates "The last form number used
was"&" "&[qryMaxFormNumber]![MaxOfFor...
|
7 |
08.09.2006 22:33:27 |
|
|
filtering out a record in an access report
How do I filter out a particular record from a report? Completely lost on
this....
|
2 |
08.09.2006 22:23:01 |
|
|
Filter out a set of records in a report.
Working in an Accounts Payable department. Need to filter out a set of
records connected to a variable/number (Global Acct Number). Access report.
Have tried looking into setting a macro, however my programming skills are
elementary at best.
...
|
2 |
08.09.2006 20:17:19 |
|
|
ValidationRule Property
I need Validation Rules for Table's Design view.
Email Address's Validation Rules
Zip Code's Validation Rules
In addition do I need set input mask for Email Address's and zip codes.
Finally an example of error messages that will pop up if inputted with wrong
information.
...
|
2 |
08.09.2006 19:51:42 |
|
|
hide inactive forms
I have built a basic database that has several 'menu' forms that are reached
from a main menu. This is working well with one exception: it looks really
busy (and confusing to non-computer literate users) when you open a form and
the previous form is still there. Granted, the previous form is behind the
active form and unless it is accidentally clicked on there is no problem.
In orde...
|
6 |
08.09.2006 19:30:13 |
|
|
Form view and fields based on query
I've created all of my tables, fields and relationships for my database.
Now, I would like to create a form to enter the data. I created a query with
all of the fields I want to include in the form. This is going well! When I'm
in Design View form I can see the fields, however, when I go into Form View,
the fields do not appear.
I read two articles regarding this problem and it seems ...
|
3 |
08.09.2006 18:31:23 |
|
|
black out row of cells with one cell entry
I am using microsoft excel 2003. I have a range of cells and in that range I
want to enter data in one cell and by doing so have the rest of the cells in
that row blacked out or marked in some way to show that there is an entry in
that row of cells. Please help. Thank you...
|
3 |
08.09.2006 15:40:19 |
|
|
Enable Multiple Users on Access DB
Hi everybody,
my company has an issue and I have to solve it. I have to create a
multiple users application, its basically a form that stores data on
just one database table.
To make it faster i wanted to use MS Access because they need it really
fast.
How do I enable access 2003 to multiple user?
Thanks for any help.
...
|
5 |
08.09.2006 15:16:08 |