Access 2000 Slowdown
My client's database is set up with a split database, using frontend and
backend .mdb files. I did not set it up and I'm still trying to familiarize
myself with the it. I've had Access 2007 training, but I'm still basically a
newbie.
Client's description of problem:
"Generally we only have one person inputting data to the database at any
given time, however we are noticing that the program seems to be getting
slower at accepting data. What happens is during transaction entering, a
little note at the bottom of the screen says "Calculating" and we are not
able to move to the
|
3/10/2010 6:37:02 PM
|
2
|
=?Utf-8?B?UGF0MjAwMA==?= <Pat2...@discussions.microsoft.com>
|
|
Access 2003 - Report Problems
I hope someone can help, I am at my wits end on this. I am doing my taxes and
made a database to make retrieving and totaling my information easier. I
finally figured out how to retrieve a report from a table but when I did, a
field I had hidden on the table portion came up on the report as well. My
question: How do I hide the field on the report that is hidden on the table?
Question 2: How in the world do you get a field to add and have the total
come up at the end? It seems so easy but I cannot make it happen. Ideally I'd
like to get it to calculate it at the bottom of the tabl
|
3/10/2010 4:51:01 PM
|
3
|
=?Utf-8?B?bWFyaW5lZ3Js?= <marine...@discussions.microsoft.com>
|
Populate a text box after update
I am relatively new to Access programming. I have a database with a combo
box in which a user can select a task. The selection of the task in the
combo box runs code that populates a benchmark text box with a number
(example: the user chooses "Phone Call" in the task combo box, the benchmark
text box populates with "7"). I want to add another entered text box that
will look at the benchmark text box and it there is something in it, then it
populates with text, if the benchmark text box is blank then it leaves the
entered text box blank also. Please help. Thanks!
|
3/9/2010 8:05:01 PM
|
1
|
=?Utf-8?B?bGF1cmE=?= <la...@discussions.microsoft.com>
|
Continued frustration with relationships and queries
So I thought I figured out how to create relationships and run queries but
now I am running into a new problem. I will do my best to describe it.
I have a table that I am using from prior months with all the Regions,
Sub-regions, cities, and zipcodes. It has multiple months of data. After I
create a relationship between two tables at the zipcode level I then create a
query to fill in the Region, sub region etc, I end up getting 1000's of
duplicates. The table that I am mapping from has many months of data while
the table i'm mapping to has 1 month. How do i tell access to on
|
3/9/2010 5:44:03 PM
|
3
|
=?Utf-8?B?RGFu?= <...@discussions.microsoft.com>
|
Can I save application as .exe file
I have created several successful Access applications in the past. I need an
application that can be maintained on several different computers which may
not all have MS Office installed. Can I put the complete database on a CD so
different people can update the data? I guess that this means the application
would have to be a .exe file and maybe use CD-RW CDs so it can be written to
on different computers.
Really Gone
|
3/9/2010 5:26:02 PM
|
2
|
=?Utf-8?B?Q2xhdWRlIE1hcnNo?= <ClaudeMa...@discussions.microsoft.com>
|
Grouping Form
I am would like to create a form that displays data based on what the
user selects.
Ex...I have a table the has customers and their orders. Each customer
can have more than on order.
I would like to set up a form that a user can select/lookup a customer
and all their orders appear in a list format. I would also like the
user to be able to add in new orders from the form.
Is this possible?
|
3/9/2010 4:24:58 PM
|
1
|
H <hendrix.p...@gmail.com>
|
Snakeing Sub Report
I have a members database with people divided into groups or categories etc.
The report I am trying to do is have many columns at the group header level
with only one field - the fullname of all those members in the detail
section for that group. What I would like to have is this information
is snaked through about 3 columns in this detail section. Is there any
way of doing it? Could it be a macro? Except I cannot think how to go
about it!
|
3/9/2010 10:23:02 AM
|
4
|
"Mervyn Thomas" <mervyn-tho...@ntlworld.com>
|
Which Version of Office 2007 to Buy?
Hello, I get academic pricing for office, and for me Office Standard 2007 and
Office Professional Plus 2007 are both being offered to me at a cheapter rate
than the Home and Student Edition 2007. But it seems that Standard and
Professional have more to offer than Student? Are the basic programs (word,
excel, and power point) the same in all three software versions? Why get one
over another?
Thank You for your help.
|
3/8/2010 8:51:01 PM
|
2
|
=?Utf-8?B?RmF1eEFzaWFu?= <FauxAs...@discussions.microsoft.com>
|
Extra pages in report -- elements too wide?
I have a report that I started editing and after changing things around a
bit, found that on opening it I got a message, "The section width is greater
than the page width, and there are no items in the additional space, so some
pages may be blank.
For example, the report width may be wider than the page width."
And that in fact happened. But I can see no elements that are wider than the
printed elements, and on printout I am getting multiple extra pages.
I'm tearing my heir trying to find where something is too wide. I have only
Report Header, Details and a blank footer. Th
|
3/8/2010 5:12:01 PM
|
3
|
=?Utf-8?B?UGxhcmZ5U29vYmVy?= <PlarfySoo...@discussions.microsoft.com>
|
Pass field value selected in Combo Box to SQL Query
Hello,
My form displays a combo box populated by a SQL SELECT statement. The user
will select a row from the combo box. I then want the value in a field of the
row selected in the combo box to be used as the selection criteria in a SQL
statement.
The SQL statement is a nested SELECT and the value selected in the combo box
is the selection criteria in the inner select statement.
The problem is how to pass the value selected in the combo box to the SQL
query.
Also, I have the following problem . When I call the SQL query by clicking a
button, a window popups asking me to ente
|
3/8/2010 12:40:54 PM
|
7
|
"hamsa" <u58...@uwe>
|
Help with Database Setup
Hi all
Following the "Linked Tables Twice" thread, I would appreciate some input
into construction of a database.
An existing database manages the control and delivery of drawings in our
design office and I would like to add a feature (Access2000 existing
back-end with Access2003 front-end).
Rather than make changes to the original application, the intention is to
link to the existing back-end with a new task-specific front-end and write
data into tables in a new separate back-end.
In the existing back-end there are two of the exisiting tables which contain
relevant informa
|
3/8/2010 10:35:41 AM
|
0
|
"TheScullster" <p...@dropthespam.com>
|
Updating Date with Update Query
I have inherited an Access 2003 database that has a table that stores Invoice
Number, Invoice Month, Quantities, etc. A user in my team has pointed out
that while each record has the Invoice Number filled (because it is part of
the primary key), many records are missing the Invoice Month (an optional
field.) This user wants the Invoice Month filled. I created an update query
to fill in the blanks in the Invoice Month field. In the design of this
query, in the "Update to" field I am using an expression like this: IIf([Inv
Number]=2,1/1/2010,[Inv Month]) I was planning to run this
|
3/8/2010 6:22:01 AM
|
1
|
=?Utf-8?B?aWFsdmk=?= <ia...@discussions.microsoft.com>
|
Create a button to edit and save new record
Hi there
I would like to create a button for a form that would allow me to edit a
record, make changes, and save it as a new record.
I don't want to save a record and have it overwrite earlier information.
How will I create this button?
Thank you in advance
|
3/6/2010 9:18:01 PM
|
2
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Opening a database with a new form
Hi
I am creating a database in which when users open it, it defaults to a
single form. At the moment, when they open it, it opens on a record.
Is it possible to open it so that it's a new form (i.e. record) instead of a
previously created record>
Thank you in advance for your help.
|
3/6/2010 4:40:01 PM
|
4
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Anchoring a form to the top of the form when moving from page to p
Hi there
In my database, I have a main form and a subforms which consists of a tab
control.
When I navigate from page to page, my position on the page varies.
Is there anyway to anchor it so that the form remains at the top instead of
jumping all around the place?
Thank you in advance.
|
3/6/2010 4:36:04 PM
|
0
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
multiple column lookup
My multiple lookup column displays
97203 15 12
when I want it to display
97203 C025 Portland
The data for the lookup column is stored in another table in these columns
primary key (autonumber) value 1 value 2
Thanks! I have tried everything I can think up----twice.
|
3/6/2010 2:57:01 PM
|
1
|
=?Utf-8?B?Q2xlbw==?= <C...@discussions.microsoft.com>
|
Vista Security and Access 2007
I have Windows Vista Home Premium 64-bit running on my HP Pavilion dv-1183cl
Notebook PC. I also am using MS 2007 Office.
I have been looking for a Membership Database to keep track of a Shriners
Club. In doing so, I have down-loaded MANY Access Databases. Each and
everyone, when I install them have a "Table" error. The other problem is I
know Vista (when you use an Administrator's account) does not always allow me
to have Administrator access, so I have to right-click and "run as
administrator".
I am sure it is a security and "Trust" problem, but I can not find how to
chan
|
3/5/2010 10:35:01 PM
|
1
|
=?Utf-8?B?R1NDIFNocmluZXIgU2VjcmV0YXJ5?= <GSC Shriner Secret...@discussions.microsoft.com>
|
HELP!
OK I admit that I am a beginner and know next to nothing about Access. My
boss is asking for me to create a database and include some relational,
indexing, and sorting options that seem pretty basic to me. However, I am
quandried as to how to accomplish this. Let me break down the project here: I
am creating a customer database. This database needs to include the customer
ID set as the primary key. Then I need to include the year the customer was
active, for example 2010. Then I need to include all the customer data, such
as first name, last name, address, city, state, zip code,
|
3/5/2010 10:03:42 PM
|
2
|
=?Utf-8?B?YWNjZXNzbmV3YmllNzk5MTU=?= <accessnewbie79...@discussions.microsoft.com>
|
Macro Setting
I am setting up a macro and in it the is a "make a table" query that
would require the user to click on "yes". Is there a way that popups
don't appear and yes is the default?
|
3/5/2010 6:54:14 PM
|
1
|
H <hendrix.p...@gmail.com>
|
Reports
Can I use Access to create multiple reports for printout? I have a table
with many records. At any time people need to be able to printout a report
for each record based a date or range of dates. When quried based on the
query range I could have anywhere from 0 to say 100 reports to print. Is
this possible?
|
3/5/2010 6:11:01 PM
|
2
|
=?Utf-8?B?VGhlV2l6YXJk?= <allb...@allbeit.com>
|
Linked Tables Twice?
Hi all
Currently we have an access 2000 backend database with front ends on access
2003 and 2007.
I am looking at creating a database which references some of the tables in
the original backend.
Rather than risk disturbing this database I was considering creating another
backend database with the original tables linked to the new backend.
Then the front ends would link to the new back end and by association, the
linked tables in the old back end.
Will this work or is it just plain nuts/bad practice?
TIA
Phil
|
3/5/2010 4:02:57 PM
|
5
|
"TheScullster" <p...@dropthespam.com>
|
Search My Report Help
I made a report from a table that is a list of files with their hyperlink, a
description column, etc. I want to make a report that has a search button at
the top, and can be searched by All columns or the few columns I have. I
have tried to search for answers and am new to Access. Can someone give me a
good resource, give me some code help, or tell me if this is possible?
|
3/4/2010 8:35:01 PM
|
2
|
=?Utf-8?B?UmFuZ2VybXJ5?= <Ranger...@discussions.microsoft.com>
|
DAO Recordset Issue
The overall objective is to sort a recordset by clicking a command
button at the top of the column. The following code is my coding
effort and I can't even get past the basics.
The strSQL creates the correct recordset (30 records) when I plug it
into the SQL query window but it returns 30 identical copies of the
first record once it gets to the rst object. Can anyone shed some
light as to what is going on. Thanks
Private Sub cmdSortYOB_Click()
Dim X As Integer
Dim strSQL As String
Dim intCount As Integer
Dim rst As DAO.Recordset
Dim rss As DAO.Recordset
strSQL = "select * from tbl
|
3/4/2010 6:22:39 PM
|
1
|
TeeSee <bkea...@glasscellisofab.com>
|
Still confused on relationship queries and similating a vlookup
Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the ci
|
3/4/2010 5:16:03 PM
|
3
|
=?Utf-8?B?RGFu?= <...@discussions.microsoft.com>
|
Still confused about queries to similate vlookup
Normally I would just dump this into excel, but the file that I am dealing
with has over 1.5 million rows so excel can't stomach it. Here is what I
have done. I have one table (MAIN) that is my main table. It contains all
the raw data. I need to convert a city code to a city name. I have another
table (CITY) with the conversions from city code to city name. Both tables
contain all the city codes. All I want to do is put the city names into my
MAIN table next to their corresponding city code (there are about 4000
different cities). I have related the tables relating the ci
|
3/4/2010 5:11:02 PM
|
2
|
=?Utf-8?B?RGFu?= <...@discussions.microsoft.com>
|
Create a query to merge records with two fields as criteria
I've got 2 tables, one with company locations/addresses and another with
contacts for the company. Table 1 has an ID field for the company name and
and ID field for the location (for that specific company). Table 2 has each
contact's name with the ID fields for company name and location. For
instance, Ajax Co has ID of 1; it's NY location has ID of 3. Joe Smith works
for Ajax in NY. How do i create the query to pull on ID field first and then
on the location field?
|
3/4/2010 4:26:01 AM
|
2
|
=?Utf-8?B?Y2hpbGlkb2c=?= <chili...@discussions.microsoft.com>
|
Split Form with need to Provide Selection List
We have an Access 2007 application that has a split form (built on Table-1).
We now need to add some type of facility that will allow our users to view
data from Table-2 (while working on the Split form based on Table-1).
They will then select one row from Table-2 which will contain 6 fields which
we need to plug into Table-1. We are still fairly new to Access and we are
not sure of the best way to accomplish this task.
Thank You,
Brad
|
3/4/2010 2:51:01 AM
|
0
|
=?Utf-8?B?QnJhZA==?= <B...@discussions.microsoft.com>
|
Information retrieval based on non-unique fields across separate tables
I am pretty new with Microsoft Access database trying to retrieve information
from a very user-unfriendly database build by some genius who never uses the
database himself. Most people have trouble retrieving data and just did
manual copy and paste from Access to Excel (imagine the pain not mentioning
the amount of potential errors). That should give you some idea how
unfriendly it is. However, before I start wasting my time doing manual copy
and paste, I would like to see if there is another way out (which I believe
there always should be). The situation should not be difficult but I l
|
3/3/2010 5:05:57 AM
|
6
|
"dyt811" <u58...@uwe>
|
Subform help for a case management database
Hi
I have a case management database where there is one main form and a subform.
The subform is a tab control (with 5 tabs).
Within each tab control is a subform which also consists of a tab control.
The key for the database is the StudentID.
What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.
The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are
|
3/3/2010 4:51:01 AM
|
8
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Can access work with multiple FX rates?
I have to produce a monthly report that uses employees data. The yearly
salary will be in local currency and I will need to create a query (and a
report) to divide the salary by 12 so I get the monthly gross salary and each
month I will need that monthly figure to be calculated in USD. But the FX
will change on a monthly basis (but the past months will stay the same). can
access do that if I have a table with the FX rates by market and month? Every
month I will update the FX rates and will need the monthly figures to
re-calculate. THANK YOU!
|
3/2/2010 4:08:10 PM
|
2
|
=?Utf-8?B?c3RlbGxhZGltYXJl?= <stelladim...@discussions.microsoft.com>
|
Table field names to appear alphabetically
Hi,
I have just started doing queries in access on our accounting database and I
would like to know is there a way I can get the tables in the query to list
all the fields alphabetically. It does it automatically when I do a query
using excel
Thanks
|
3/2/2010 1:36:01 AM
|
5
|
=?Utf-8?B?U2ltb24gUw==?= <Sim...@discussions.microsoft.com>
|
Uppercase 1st Letter
How do I format a field so that the first letter is always capitilized. I
know to use the greater then sign to display text as all caps, but I just
want to make sure the first letter in a customers first/last name is
capitilized.
|
3/1/2010 11:23:02 PM
|
3
|
=?Utf-8?B?RGFu?= <...@discussions.microsoft.com>
|
Thanks To all MVPs.. and John
Thanks you very much appreciate..
khalak
|
3/1/2010 6:11:56 PM
|
0
|
"Ahmed" <mukha...@hotmail.com>
|
How many tables .. in Access 2007 .. are there limits ?
Hi,
Is there restriction for number of table in Access 2007... what are
maximum number of tables
can be used..?
thanks in advance...
Dr. Khalak
|
3/1/2010 4:30:44 PM
|
6
|
"Ahmed" <mukha...@hotmail.com>
|
Replace Date
Hi,
I have a list of Customer IDs and delivery dates as
Cust_ID Deliv_Date
1000 2/24/2010
1001 2/25/2010
1002 1/1/1998
1003 1/1/1998
1004 3/1/2010
1005 3/15/2010
Here, I am trying to query this table so that if Deliv_Date = 1/1/1998
then Deliv_Date = Null.
My result should be something like this
Cust_ID Deliv_Date
1000 2/24/2010
1001 2/25/2010
1002
1003
1004 3/1/2010
1005 3/15/2010
Can you please help me to query this result using Access query?
Thank you,
Sajan
|
3/1/2010 4:03:09 PM
|
3
|
Saz <sajan.sa...@gmail.com>
|
Contact Record Sort
I have a database with over 200 records and the primary key is an auto number
for each contact. When the information was exported to the database, it was
exported with last name sort and each individual has a unique auto number.
When I add new contacts to the database, it generates a new auto number
which is fine, but the new contact with last name starting with "A" is the
last record, can the database sort itself with last name before closing?
Deeds37
|
3/1/2010 2:25:01 PM
|
2
|
=?Utf-8?B?RGVlZHMzNw==?= <Deed...@discussions.microsoft.com>
|
Combo box to fill text boxes..
A form has one combo box and 3 text boxes. This form has the Record
Source set to a table containing employee scoring information. The
combo box contains employee ID numbers. Based on the selection from the
combo box the three text boxes will display the employee name, employee
area, and an evaluation score.
Currently the combo box has a Row Source:
SELECT ScoresTbl.EmpNum, ScoresTbl.EmpName, ScoresTbl.EmpArea,
ScoresTbl.OverAllEval FROM ScoresTbl ORDER BY ScoresTbl.EmpNum;
Once the EmpNum is selected or an AfterUpdate event on the combo box,
then the appropriate text box
|
2/26/2010 9:27:47 AM
|
4
|
George <MyEm...@FakeEmailAddress.com>
|
Auto Fill
I'm trying to enter employee training information. I want to be able to type
in an identifier (last name or employee number) and it will bring up
information showing what training they received, and the date they received
it. I know I have to make a table with all the information I need, but that's
where I'm stuck. I dont' know what to use (form, query, etc.) and I don't
know how to set any of that up. Basically, I'm totally lost :(
Any help is GREATLY appreciated!
|
2/25/2010 9:46:06 PM
|
6
|
=?Utf-8?B?QW15?= <...@discussions.microsoft.com>
|
how do I add data from one table to another table?
I have created a database in Access 2007 that contains two main tables along
with several look-up tables. Both tables for the most part have common
fields. I want to add data to Table 1 and have it added to Table 2 without
having to manually add the same data. I also would like to add data to Table
2, but not have the same data going to Table 1. I plan on using a Form to
add the data. I am sure that the answer is staring me right in the face, but
for now I am not seeing it. Any help would be appreciated. Thanks.
|
2/25/2010 3:24:01 PM
|
4
|
=?Utf-8?B?cnBoZW4=?= <rp...@discussions.microsoft.com>
|
microsoftin.com as a google organization
none
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=2a52b5ed-b0a2-450e-a610-5b131cccbadb&dg=microsoft.public.access.gettingstarted
|
2/25/2010 11:18:02 AM
|
0
|
=?Utf-8?B?d29lYnNlam9oYW5uZXM=?= <woebsejohan...@discussions.microsoft.com>
|
Calculating Age in Access
Hi
In my database I have 2 dates in my form: Current Date and Date of
Emplaoyment. I would like to calculate how many years my employees have been
working for me so that I can send the appropriate congratulatory messages.
How do I do this? I looked at DateDiff but couldn't figure out how to
change it for my purposes.
Thank you in advance for your help.
|
2/25/2010 6:26:01 AM
|
6
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
Tab control within a tab control
Hi
I have created a Case Management Database which has 5 themed sections:
Personal Information, Personal Assessment, Personal Plans, Case Notes, and
Other.
I also have created almost 30 forms dealing with different information that
must be collected on each participant.
Withing the Personal Information themed section, there are at least 8 forms.
In Personal Assessment, there are 8 forms, and etc.
Is it possible to create a tab control within a tab control or should I
create a subform which includes all the forms for each section and then put
these subforms into the tab
|
2/25/2010 6:21:01 AM
|
0
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
application help
I am a new Access 2007 user. 15 years in auto repair and another 20 in fleet
management. I am developing a fairly extenisve fleet management program. My
question is how do I put the information useful to mechanic's in a file which
can be accessed by F1 (helP)
|
2/25/2010 3:04:03 AM
|
2
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
Conditional Formatting
In my data base I am asking to color code field "A" in green if the amount
is less than filed "B". I have also asked for field "A" to highlight blank
records in purple. Can you ask for different colors and different criteria of
the same field? I tried doing this and it worked for only the purple
expression and highlighted in green the oppposite field of my expression? I
hope this make sense?
--
Merlin
|
2/24/2010 9:10:01 PM
|
4
|
=?Utf-8?B?R3JhaWw=?= <Gr...@discussions.microsoft.com>
|
Setting Record Order in Report
I have a report, with a page per record. As the data get bigger, I need a
more efficient way to center on one record at a time.
Ideally, using the date of <ReceivedDate> (a field) would work best, as
generally only current data are of note.
I have an index on the <ReceivedDate> field, which I was hoping would help,
but no joy.
1. What is the conventional way to do this?
2. More complex, and alternatively, is there a way to select a record (even
a text one) by beginning typing to get the correct record to display? Or, use
some kind of input window?
Thanks very much
|
2/24/2010 6:40:01 PM
|
2
|
=?Utf-8?B?UGxhcmZ5U29vYmVy?= <PlarfySoo...@discussions.microsoft.com>
|
Query will not sort
I have made a query and it will not sort one of my fields. I thought it was a
simple query but maybe not.
Field: Area, Sort Ascending
Field: OrderNumber, Sort Ascending
Field: Status, Criteria Like "*Y*"
Field: Week 1, Criteria Is Null
It will do everything except sort on the order number.
--
Lenee
|
2/24/2010 5:20:01 PM
|
6
|
=?Utf-8?B?TGVuZWU=?= <Le...@discussions.microsoft.com>
|
Font Colour
Can I change just one row in a query depending on a check box.
If the check box for a record is true Is it possible to change the font
colour to red just for that one row/record
Access 97
|
2/24/2010 5:06:37 PM
|
1
|
"Steve Goodrich" <stevegoodr...@btinternet.com>
|
Date, Time location Stamp
Sometimes when proposing a meeting the Date time location get put in the
message box. How do I initiate this to happen for all meetings? see below
example
When: Wednesday, February 24, 2010 9:00 AM-10:00 AM (GMT-05:00) Eastern Time
(US & Canada).
Where: Lupine - 8 - SR
*~*~*~*~*~*~*~*~*~*
--
CharleneN
|
2/24/2010 2:03:03 PM
|
2
|
=?Utf-8?B?Q2hhcmxlbmUgTg==?= <Charle...@discussions.microsoft.com>
|
Importing from Excel
When importing from excel into downloaded assets template from
Microsoftgetting error message F16 doesn't exist in table assets - F16 in
excel is a blank field - I've tried clearing the field and deleting the row
but still get the same message.
|
2/24/2010 11:01:01 AM
|
1
|
=?Utf-8?B?RGVlbmE=?= <De...@discussions.microsoft.com>
|
Problem with report
I have built a query that is sorted by last name and when I hit run it works.
When I put it in the control source of a report it doesn't sort it correctly.
What am I missing or doing wrong?
--
Lenee
|
2/23/2010 11:47:01 PM
|
6
|
=?Utf-8?B?TGVuZWU=?= <Le...@discussions.microsoft.com>
|
Calculating Fields
I'm trying to populate a field based upon values is 2 other fields. I have a
field DEGREES and I want to add it to the sum of the field MINUTES/60 to
create a new field DECIMAL DEGREES. I keep getting an error "database engine
does not recognize the field 'MINUTES' in a validation expression". I would
like this field to populate when the data in the other fields is entered.
I'm not very proficient with access, so I'm trying to learn as I go. Thanks.
|
2/23/2010 5:37:02 PM
|
4
|
=?Utf-8?B?Z3A=?= <...@discussions.microsoft.com>
|
Update UnitsInStock
I have a problem with my UnitsInStock value.
1- Req4 form contains an entry field for QuantityIssued
2- Products2 table that contains the UnitsInStock value.
3- Req4 table contains Request detail data
The forms record source is a query that joins the 2 tables using a product
number.
As it is now the user must manualy change the UnitsInStock on the form by
substracting the QuantityIssued from the current UnitsInStock. I want the
UnitsInStock to update itself after the QuantityIssued is entered. I have
tried AfterUpdate code and expressions with no luck.
|
2/23/2010 12:12:04 AM
|
9
|
=?Utf-8?B?SHViYnlNYXg=?= <Hubby...@discussions.microsoft.com>
|
Need help sending mail!
This is a multi-part message in MIME format.
------=_NextPart_000_002E_01CAB3B0.0A37DE50
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002F_01CAB3B0.0A37DE50"
------=_NextPart_001_002F_01CAB3B0.0A37DE50
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Can't send or receive mail due 'POP3' is not working for me.
Glen
------=_NextPart_001_002F_01CAB3B0.0A37DE50
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitio
|
2/22/2010 7:13:20 PM
|
1
|
"glenda houston" <glenda hous...@yahoo.com>
|
Query Problem
Hi,
I have this query but is not working.
SELECT
BKAR_INV_NUM,
BKAR_INV_SONUM,
BKAR_INV_INVCD,
BKAR_INV_INVDTE,
BKAR_INV_CUSCOD
FROM BKARINV
WHERE (((BKAR_INV_INVCD)=' ') AND ((BKAR_INV_CUSCOD)="SCOENE0100")) OR
((BKAR_INV_INVCD)="X"));
I need it to show all records for SCOENE0100 that the BKAR_INV_INVCD are
either "X" or " "
Thank you all
|
2/22/2010 6:08:04 PM
|
2
|
"Bre-x" <cholot...@hotmail.com>
|
Join using LIKE
I have two tables with data that is nearly exact - one table has truncated
data:
Table 1
BARRICK GOLD CORP
DIREXION SHS ETF TR
Table 2
BARRICK GOLD CORP COM ISIN#
DIREXION SHS ETF TR LARGE CAP BULL 3X SHS
I am wanting to join these two tables on the these fields to extract another
field. Is this possible? And is it possible without using VBA using a
Design View query?
Many thanks.
|
2/22/2010 11:48:02 AM
|
11
|
=?Utf-8?B?SkU=?= <...@discussions.microsoft.com>
|
Having problems understanding sub-form selections and uses of comb
Access '02:
Hi all, I guess i'm having fundelmental problems getting my sub-forms and
combo boxs to work for what i'm trying to attempt.
I've posted my first problem with use of 'drop down combo box" and getting
it to show me the text in the destination field already. I've made progress
with that.
Now i can't get a grip on the use of sub-forms and combo boxes for my next
part.
So i don't burden you to much can anyone recommend any useful visual demos
or examples for these. The online help is of no use to me for my needs, and
i can't find anything specific at the online sup
|
2/22/2010 3:03:01 AM
|
2
|
=?Utf-8?B?amVmZg==?= <j...@discussions.microsoft.com>
|
MID
I have a table with data such as:
CALL 100 BAIDU COM INC SPONS EXP 01-16-10
PUT 100 APPLE INC COM EXP 03-20-10
I need to pull out all information after 100 and stop when it reaches EXP.
Is MID the best function for this?
Also, I am not using VBA - only a simple design view query.
Many thanks for assistance or direction.
|
2/21/2010 10:10:01 PM
|
2
|
=?Utf-8?B?SkU=?= <...@discussions.microsoft.com>
|
How do I retrieve my ID code.I have already registered.
I am trying to put my ID number into my product number area but after
registering no code is coming up. What do I do?
|
2/21/2010 3:16:01 AM
|
1
|
=?Utf-8?B?S2F0aGVyaW5l?= <Kather...@discussions.microsoft.com>
|
Need to determine length of field for query
I need to use a query that will show me in the address field all those
records where the address is longer than 35 characters. I want to be able to
shorten those to fit in a specific label. I can then use this syntax to also
abbreviate city names that are too long for the label
--
Barry
|
2/20/2010 9:55:01 PM
|
1
|
=?Utf-8?B?QmFycnk=?= <ba...@discussions.microsoft.com>
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 54393
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas � 01M
Pre�o: R$ 1900.00
Temos outras tipos de solenoides e artigos importados, nao deixe de fazer uma consulta antes de comprar!
Audi a3 automatico
Audi a3 1.8 t automatico
Audi a3 1.8 turbo automatico
VW Golf gti automatico
VW Golf 2.0 automatico
VW Golf 1.8 turbo auto
|
2/20/2010 3:00:24 AM
|
0
|
kit solenoites audi solenoid.chicote<kit.solenoites.a...@solenoid.chicote.com>
|
Forms Option Group
I have created a Option Group in a form. The form is linked to a query
but I would like the users selection of the Option Group to update a
table. Is that possible?
|
2/19/2010 5:14:49 PM
|
3
|
Hendrix <hendri...@gmail.com>
|
Combining two fields in a table
I have a 5-digit zip field and a 4-digit plus-4 field. I created in my table
a 10 digit newzip field, so that combining these two make a 9-digit zip that
looks like this:
60016-2345. I have no problem creating this in a query, but I want this to
be in a table, and then I will delete the existing zip and the plus field,
then re-name the newzip as zip. How do I do this? Can I convert it from the
query into a table? I know this is basic, but I'm really new to this
--
Barry
|
2/19/2010 1:28:01 AM
|
2
|
=?Utf-8?B?QmFycnk=?= <ba...@discussions.microsoft.com>
|
Forms Drop down list
I created a form that works from a table. From the form you can enter
information and it will put it into the table. I would like to create
a field in the form where the user can selects what to be inputed from
a drop downlist. how would I do that?
|
2/18/2010 8:24:08 PM
|
4
|
Hendrix <hendri...@gmail.com>
|
Forms Field List
I am using a form that someone else had created but I wanted to add a
check box to it. I added a field in the souce table but when I go to
the form in design view the new field is not listed. What am I doing
wrong?
|
2/18/2010 5:07:16 PM
|
2
|
Hendrix <hendri...@gmail.com>
|
hours, minutes, seconds
I am new to Access.
I need a field in my database that records the duration of an event in
hours, minutes, and seconds. I will then need to determine the average of
these events
I tried using a "General Date" field with a "h:n:s" format. That seemed to
record the times okay but I couldn't get the report to compute the average.
When I click on "Totals" in "Grouping & Totals" in the report's design view
the only options I get are "Count Records" & "Count Values".
Any suggestions?
|
2/17/2010 10:15:01 PM
|
5
|
=?Utf-8?B?S2FybA==?= <K...@discussions.microsoft.com>
|
Open mode
I have Access DB 2003 that I splitted it to front end and back end. I will
put the back end in shared drive and the front end in users' hard drives (4
users including me). No one except me needs to make change to the front end.
Should I set the open mode of the back end to "Shared", the front end of
each user to "Shared" and my front end to "Executive"? Thank you. Gina
|
2/17/2010 6:32:01 PM
|
3
|
=?Utf-8?B?R2luYQ==?= <G...@discussions.microsoft.com>
|
How do I prevent others from editing my Access 2007 database?
I've posted this elsewhere in this discussion group, but have not received
any replies, so I thought I'd try to post my question here as well. I just
started using Access 2007. In the previous version (03), I was able to
prevent other users from changing/deleting/adding data. I can't seem to find
out how I can do this in Access 2007. Please advise. Thank you !
--
jeannine
|
2/16/2010 7:39:02 PM
|
2
|
=?Utf-8?B?amxkdWJl?= <jld...@discussions.microsoft.com>
|
Fiscal Six-Month Periods
I have a database with a bunch of dates in it. I'd like to create a new
calculated field that designates the associated date in a six-month period
through a query.
The periods go from April 1st to September 30th (1st half of our fiscal
year) and then from October 1st to March 31st (2nd half of our fiscal year).
So, a date in OBLG_DATE of 6/1/09 would be designated in the new field
SFY_SIX as something like 2009S1. A date of 11/13/10 would be designated as
something like 2010S2.
Thanks for your help to this quite novice user in advance.
|
2/16/2010 7:32:01 PM
|
1
|
=?Utf-8?B?Um90aG1hbg==?= <Roth...@discussions.microsoft.com>
|
Opening Forms based on Combo Box Selection (Access 2007)
I am creating a database in which people in 10 different regions will
enter information into forms for facilities in their respective
regions.
I'd like the users to open the database, select their region from a
combo box and click an "open form" command button that will open all
the records/forms in their region (right now, the forms only have the
facility name and address information entered).
How do I link the command button function to the combo box?
I know their is probably a simple answer to this question. Any help
would be appreciated!
Thank you!
Mary
|
2/16/2010 7:28:23 PM
|
1
|
Mary <maryfaithja...@gmail.com>
|
Counter
I want to add a column to an existing query that is a counter. Example of
data and desired result below. The criteria is: If Name, Symbol and Date are
different, counter changes; if Name, Symbol and Date are same, same counter
as line above.
I read about DCount but was unsuccessful. Any insight or direction to
reference material is most appreciated.
Name Account# Symbol Date
ANDREW 12345 AAA 08-Jan-09
ANDREW 12345 AAA 20-Jan-09
ANDREW 12345 BBB 20-Jan-09
ANDREW 12345 BBB 28-Jan-09
BOB 98765 CCC 30-Jan-09
BOB 98765 CCC 30-Jan-09
BOB 98765 CCC 30-Jan-09
Want
Counter
|
2/16/2010 7:20:16 PM
|
2
|
=?Utf-8?B?SkU=?= <...@discussions.microsoft.com>
|
pcnetsecurity@gmail.com =?UTF-8?B?QXNzaXN0w6puY2lhIFTDqWM=?= =?UTF-8?B?bmljYSAgbWFudXRlbsOnw6M=?= =?UTF-8?B?byBkZSBjb21wdXRhZG9y?= =?UTF-8?B?ZXMgaW5mb3JtYXRpY2Eg?= =?UTF-8?B?Vml0w7NyaWEtZXMgMDE5ODE=?=
Contato: pcnetsecurity@gmail.com
Contato: pcnetsecurity @ gmail.com
Planos a partir de R$ 250,00 .
Assist�ncia T�cnica
Prestamos assist�ncia t�cnica nos computadores de sua empresa ou resid�ncia, e tamb�m possu�mos uma equipe qualificada para fazer a manuten��o no pr�prio local.
- Contratos de Suporte e Manuten��o
Reduza os custos de sua empresa com solicita��es de visitas t�cnicas para seus computadores, elaboramos um contrato de manuten��o integrado para sua empresa onde disponibilizamos: t�cnicos, equipamentos de suporte e substitui��o, e atendimento no hor�rio comercial ou
|
2/16/2010 4:51:26 PM
|
0
|
Assitencia manutencao remocao de virus computador pc<manutencao.assiten...@computador.pc.com>
|
Data type mismatch
New to Access 2007
I'm putting together a database. One of the fields is test scores which
have a value of 0 through 100 OR "ND". They aren't willing to get rid of the
"ND", so I have the field set to "Text".
Is there a way to create a validation rule that limits input to these
values? A combo box with 100+ values seems awkward.
I tried:
Between 0 and 100 OR "ND" but I got a type mismatch error.
Thanks
|
2/16/2010 4:38:02 PM
|
1
|
=?Utf-8?B?S2FybA==?= <K...@discussions.microsoft.com>
|
how to view 2 tables in design view side by side (access 2007)
I used to use access 2003 and was able to show side by side two tables in
design view. How is this done in access 2007.
|
2/16/2010 3:34:07 PM
|
1
|
=?Utf-8?B?Y2VsZXN0ZQ==?= <cele...@discussions.microsoft.com>
|
Form field sizing & alignment troubles, using related tables
I've got 1 day under my belt with Access, so I don't know a lot more than I
do...
I'm "scrubbing" attributes from blueprints that we have scanned. At the
moment, the blueprint scan is identified by a bar code, not very helpful when
you have 1800 of them. My Access database will list the bar code number as
the primary key along with attributes (water, sewer, sidewalk, easement...)
listed on that blueprint. Our goal is to generate reports can be run
considering street address, and the attribute(s) in question, allowing us to
view only the scans of blueprints that would pote
|
2/16/2010 3:01:01 PM
|
1
|
=?Utf-8?B?TGlzYQ==?= <L...@discussions.microsoft.com>
|
Error Message after exporting MS Access Table
I receive the below error message when I export a table from a Microsoft
Access database to the Microsoft Word Merge format:
�The data being exported does not match the format described in the
Schema.ini file.�
Microsoft Access database is in .mdb format.
--
sam.joseph74
|
2/16/2010 7:26:33 AM
|
0
|
sam.joseph74 <sam.joseph74.5c00...@officefrustration.com>
|
Images and thumbnails questions
Hello--
I am running XP Pro, with Access 2007. I have several folders, each with
hundreds of image files-- most of these are photo .tifs.
I would like to make a database that contains the file names and key
information about each file (date it was taken, what it is a picture of,
etc.). I want this database to be searchable by users, who will be prompted
to enter criteria for specific attributes ("The photo(s) you are looking and
from what year(s)? _____________"); users must be able to answer in plain
language-- the users cannot be required to enter any code or anything othe
|
2/15/2010 9:55:18 PM
|
2
|
=?Utf-8?B?U0xPVw==?= <S...@discussions.microsoft.com>
|
Access 2007 Runtime breaks Office 10
I installed Access 2007 Runtime for a test on a Win XP Pro system that
has Office 10. When I tried to run my previous application (.MDB)
it run under Access 2007 Runtime, instead of Office 10.
So I uninstalled Access 2007 Runtime, but it then I could not
run any Office 10 applications (Access, Excel, Word).
I ran the Office 10 installation CD and I expected the option
to "fix", but it didn't appear, even though the files existed
in Program Files. I ran a full installation and Word & Excel
seems to be working OK.
However, when I try to open my database via a Shortcut, an
error
|
2/15/2010 6:48:00 PM
|
1
|
rlh <...@nospamYahoo.com>
|
installing office home and student
I purchased a copy of office home and student and was wondering if I needed
to uninstall the copy that came preinstalled on my computer before installing
the new copy.
|
2/15/2010 1:26:01 AM
|
1
|
=?Utf-8?B?Y2Njb29wZXJlbG1v?= <cccoopere...@discussions.microsoft.com>
|
duplicate record in my first colomn
i have 8 columns and the first is title. when i enter a title that is already
in my list, why do i have to go through the other 7 to get a notice that the
title is already on file? thanks for any help.
--
LORENZO
|
2/15/2010 1:18:01 AM
|
3
|
=?Utf-8?B?TE9SRU5aTw==?= <LORE...@discussions.microsoft.com>
|
looking for CD1 for microsoft compatible 3 comp 3
i am trying to down load microsoft word for one of my kids projects
|
2/15/2010 12:40:02 AM
|
1
|
=?Utf-8?B?YmlnZ2d5Ymln?= <bigggy...@discussions.microsoft.com>
|
How to use access 2007 external database paths
I have a database that several computers access. I have a query that is a
union something like this:
SELECT main.*,"list1" as owner
FROM C:\path\test1.mdb.main
where main.listname<>"condition"
UNION
Select main.*, "list2" as owner
From C:\paths\test2.accdb.main
Now this works fine from the hosting computer, but from another computer it
doesn't. I am now using the shared drive name\path in a second query and
advising users to use the correct query. this seems like a hack. Is there a
way of making it so I can use just one query so all users trying to execute
the query can w
|
2/13/2010 9:49:13 PM
|
2
|
=?Utf-8?B?Y29kZVNsYXZl?= <codeSl...@discussions.microsoft.com>
|
Access 2007, Query's prompts parameter twice
For some reason my query's ask for a parameter twice when run. I then copy
the code into a new query, delete the old query and rename the new query to
the old name and everything works. It seems regularly this will happen and I
have to redo all that are affected? This access 2007 install has the latest
patch from MS. Am I doing something wrong here or is this documented
somewhere so I can fix
|
2/13/2010 9:40:03 PM
|
2
|
=?Utf-8?B?Y29kZVNsYXZl?= <codeSl...@discussions.microsoft.com>
|
Query help for zip codes
My table has several thousand 9-digit zip codes (like 90210-2345). I want to
create a query whereby all 5-digit zips are grouped together at the top (or
bottom) so that I can research them and convert them to 9-digit. I think it's
a "Mid" kind of thing, but I'm not sure. In dBase, it was an index like this:
substring(zip,8)=" ". Any help would be appreciated.
--
Barry
|
2/13/2010 12:02:01 AM
|
10
|
=?Utf-8?B?QmFycnk=?= <ba...@discussions.microsoft.com>
|
How do I get rid of "getting started with Microsoft Office Access"
I've just "moved up" to Office 2007 from Office XP. How can I get rid of the
annoying Access startup page, "Getting Started with Microsoft Office Access",
or at least modify it to get rid of the "Featured Online Templates" and
"Microsoft Office Online" frames. I prefer a clean, uncluttered interface, as
in Access XP. I know that you can avoid this by opening a database file
directly, but that isn't always the most efficient method of working.
Thank you.
|
2/12/2010 6:00:01 PM
|
2
|
=?Utf-8?B?VGVycnk=?= <Te...@discussions.microsoft.com>
|
Average Age
I'm doing end of term reports for pupils in a school whereby each report
needs to show the age of the pupil on a given date in YEARS and MONTHS (not
a fraction of the year). In other words, 10 yrs and 3 months, (not 10.25).
I've managed to use a function called Diff2Dates Author: � Copyright 2001
Pacific Database Pty Limited Graham R Seach MCP MVP gseach@pacificdb.com.au
to display the pupils age in years and months fine, but I ALSO need to show
the Average Age of the Class in Years and Months.
Simply adding up the results of the Function above and dividing by the
number o
|
2/12/2010 5:13:43 PM
|
8
|
"Laura" <la...@nowhere.com>
|
open form/subform at specific record
I have a form (repair status) the has the same field (work order #) as
another form which is actually a subform(work order detail) to a main form
(Customer data). What I want to do is double click on the field (work order
#) and have it open the form (customer data)/(work order detail) at that
specific record.
I selected On Dbl Click to run a macro that opens the form where both field
match. That works but it pulls the customer data form and the work order
detail but it goes to the first work order detail associated to that customer
not the specific on i clicked on. Any id
|
2/11/2010 6:24:01 PM
|
4
|
=?Utf-8?B?am9obg==?= <j...@discussions.microsoft.com>
|
subform question
I have a main form and a subform
Whe the subform is not showing any record I want to stop my code on the
main form
Private Sub Form_Current()
'Setup variables
var_folder = const_path & Me.fsearchsub!pmac & "\" & Me.fsearchsub!tcustid
var_path = var_folder & "\" & Me.fsearchsub!pmac & Me.fsearchsub!pprog
var_fn = "FN-" & Me.fsearchsub!tcustid & "/" & Me.fsearchsub!pmac &
Me.fsearchsub!pprog
var_prog = Me.fsearchsub!pprog
var_mac = Me.fsearchsub!pmac
End Sub
|
2/11/2010 5:52:46 PM
|
3
|
"Bre-x" <cholot...@hotmail.com>
|
New User Help with lots of information
I want to create a data base here in Access however I have never used it
before, So i dont know if these things are possible and what forms are the
best to use if this is possible. I have been using Excel which i am pretty
familiar with. Each tab I have a listing of different reports. One reports
lists all the deposits for every company that uses a specific product. Right
now this is about 30,000 + rows. THen i have another 5-6 different places
where I report things. I want to see if I can move these into ACCESS.
This is what I want to do.
First I want to enter all the
|
2/11/2010 4:04:01 PM
|
8
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
Ten calendar harm one of the products
Ten calendar harm one of the products
www.laptop-battery-inc.co.uk/spy-pen.htm
|
2/11/2010 9:23:17 AM
|
0
|
"Starain" <hxp...@vip.qq.com>
|
Ten calendar harm one of the products
Ten calendar harm one of the products
www.laptop-battery-inc.co.uk/spy-pen.htm
|
2/11/2010 9:16:36 AM
|
0
|
"Starain" <hxp...@vip.qq.com>
|
Checkbox that pulls related info from form to report
I have a table which has a questionnaire field and a question that relates to
that questionnaire name. I would like to create a form that users can choose
which questions they want on the questionnaire by checking the button next to
the type of questionnaire. I would like the results to output to a report.
Please help
|
2/11/2010 7:00:01 AM
|
3
|
=?Utf-8?B?Q2hhbnRlbDMz?= <Chante...@discussions.microsoft.com>
|
field references in forms
If I have a form "myform" with recordsource "mytable" and the table contains
a field called "id," I can reference the current value of that field in
expressions used for controls in the form by myform.id. This is true even
when there is no control bound to mytable.ID on the form. I can "print" the
value of myform.id in the debug immediate window.
If I try the same thing for a form whose record source is a query, ?
myform.id produces an error.
Why the difference?
And a corollary question: what's the most efficient way to test the values
of expressions, for example the con
|
2/11/2010 4:13:44 AM
|
4
|
"Ron" <Harves...@comcast.net>
|
Storig data from website to database
I am in 6th grade and I want to put a survey up on a website. I want
to capture the following information
Trial One
Choose L or R (selects only one)
Trial Two
Choose L or R (selects only one)
Trial 3
Choose L or R (selects only one)
Gender
Choose M or F (selects only one)
Spayed/Neutered
Y or N (selects only one)
So 5 fields plus unique ID need to be captured. Is there an easy way
to do this? My mom knows Access and basic HTML pretty well but has
never captured data from the web before.
Thanks for any help.
Connor
|
2/9/2010 10:06:32 PM
|
2
|
Connor ScienceGuy <pawprefere...@gmail.com>
|
Photo Directory Template
I am looking for an Access 2007 Photo Directory template. I am trying to
make a members database that will print a photo directory for our church, but
I am having a hard time because I don't know Access well enough to make the
form and report work right together. Any help is appreciated! Thank you!
|
2/9/2010 7:10:09 PM
|
14
|
=?Utf-8?B?Q2hlcnls?= <Che...@discussions.microsoft.com>
|
DCount with one single condition works, but several ones, joined together with the logical operator AND, do not!
Dear friends out there,
I simply do not understand this. What's wrong with the syntax in my
Access-2007 report?
=DCount("[ID]", "Table", "[ConditionYesNo1] = No") -----> returns a correct
minor total of all records with no checkmarks in the field (column)
"ConditionYesNo1".
=DCount("[ID]", "Table", "[ConditionYesNo1] = No" AND "[ConditionYesNo2] =
No" ) -----> returns ALL records. Why i that?
Thanks in advance
Henrik
__________ Information fr�n ESET NOD32 Antivirus, version av virussignaturdatabas 4848 (20100208) __________
Meddelandet har kontrollerats av ESET
|
2/9/2010 5:51:16 PM
|
2
|
"Henrik Jansson" <pobo...@hotmail.com>
|
Change receiving email for microsoft.public.access.gettingstarted group
I am retiring 2/26/10 and I need to change the receiving email for
this and other groups to my home email address. I went to two places
that I thought would take care of it but the one place wouldn't let me
put in another email address. I believe I could only change the sign-
on name. THe other place said I couldn't add a gmail address because
the group couldn't go to a gmail address.
Please help!! Thanks
|
2/9/2010 2:08:25 PM
|
0
|
cricket7 <hugh...@waukeganpd.net>
|
variables
Hi
I have assigned a variable called StPracLock as follows:
StPracLock = "Forms!Results1.Mod" & stMod & "Ass" & StAssNo & "Prac.Locked =
False"
Now I want to run the command by typing in the variable name but, ofcourse,
it doesn't work! (Comes up with "COmpile Error, Sub,Function,Procedure
expected) Can anyone help me. I have a number of fields to lock/unlock
depending on the Module (stMod) and Assignment (StAssNo) selected.
Thank you
Kary
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/201002/1
|
2/9/2010 1:12:13 PM
|
3
|
"kary via AccessMonster.com" <u57...@uwe>
|
outlook 2010 beta
i'm not getting any replies from all the questions i have asked on discussion
groups .Why is this? where do i access the replies for my questions only?
Secondly, i have installed the MS Office 2010 beta and am not recieving any
mail inbox or showing any sent messages even though i am sending and the
outbox is empty and i am recieving but the inbox is empty,
I check the box here to notify me of replies and recieve nothing
|
2/9/2010 12:31:01 PM
|
0
|
=?Utf-8?B?YnJhZA==?= <b...@discussions.microsoft.com>
|
help
I am having a terrible time with this email server in and out. I have never
had a problem sending or receiving emails in the past and now I am applying
for jobs and I flipping out with not being able to send my info through
gmail or aol.When i go to reply this mail form that I am using write now
comes up. I write my email and then comes the screen with strting a new
email account and servers and I need help.
HELP to anyone out there that can contact me.
Thanks
Terri
|
2/8/2010 7:12:04 PM
|
0
|
"Terri Popper" <terri.pop...@gmail.com>
|
57 R4I :COMPRAR
Nuevo Modelo R4i para Comprar
R4i para nintendo Ds, Ds Lite , Dsi y Dsi XL
http://www.elotrolado.net/hilo_r4i-comprar-nuevo-modelo_1373328#p1718911991
www.Dsiconsolas.com
Chao
T_bV,.e*u<>l%SO@vLKJDv,P)
|
2/8/2010 5:41:37 PM
|
0
|
tesddalws<r4icomp...@yahoo.com>
|