|
place spanish accent letter in microsoft access
How do I place a spanish accent over a letter without deleting the cell and
copying the previous cell into it. When I press control + accent as I do in
Word, it automatically deletes the cell and copies the material above into
it. Thanks for our help.
Elise...
|
4 |
30.09.2006 16:25:01 |
|
|
Compare with last record
I have an ordered list of Trades, each with a Price.
I would like to compute Price variation from Trade to Trade.
Variation may be positive, negative or zero.
TIA
--
AP
...
|
2 |
30.09.2006 16:15:15 |
|
|
Round to 0.5
I need a formula, in a report or query, that will round my calculated result
to X.5 if the result has a decimal. Example: 2.6, 2.2, 1.9, 1.1 would be
changed to 2.5,2.5,1.5,1.5. If the result is a whole number then there is no
change. I need this for inventory counting whole/half bottles. Thanks, Dan
--
Dan...
|
3 |
30.09.2006 15:01:11 |
|
|
HOW OLD IS MICROSOFT ACCESS 1.0
I WOULD LIKE TO KNOW HOW OLD OR WHEN MICROSOFT ACCESS 1.0 WAS FIRST PRODUCED
AS A DATA BASED PROGRAM...
|
6 |
30.09.2006 14:42:23 |
|
|
Using a button to fill in a form
I am designing a new db system for the non-profit i work for. I cannot
build a totally new system, merely add onto the old one, and here is
what I have:
Two tables that are updated via one form each. In have one form, with a
subform that that is for a third table, I would like to add a button
that will fill in the second form with the information from the first.
We collect data on income...
|
2 |
30.09.2006 14:26:34 |
|
|
Full Screen on database
Is there a way i can have a full screen view of my database with out
any of the toolbars at the top of the page.
Just to make it look tiredier and more profetional
Thanks
SImon
...
|
6 |
30.09.2006 14:13:41 |
|
|
books
I need to start learning SQL for access.
I mainly use 97 but I also use 2003.
Can any one suggest any good books to start of with please.
Thanks
Jon
...
|
8 |
30.09.2006 14:04:19 |
|
|
DBs no longer open in Access 2007 Beta 2 Technical Refresh
Hi, I've just applied the technical refresh to Office 2007 beta 2 and none of
my Access DBs open. Access just goes back to the opening page of "Getting
Started With Microsoft Access".
Has anybody encountered this before and how did you fix it?
Thanks
Damian...
|
1 |
30.09.2006 14:01:02 |
|
|
How do I create directory folders based from access database
Is it possible to get access to automate creating folders and have them be
named using data from the database?
All suggestions greatly appreciated...
|
3 |
30.09.2006 13:23:47 |
|
|
Document Management System
Hello,
I am hoping to be pointed in the right direction as to providing a solution
to meet a business problem. I need to provide a Document Management System to
manage the inventory of legal documents. I am thinking I could do this in
Microsoft Access and perhaps adapt a ready made template for this purpose. I
had a look under standard templates and did not see anything directly relate...
|
4 |
30.09.2006 13:18:48 |
|
|
Code Help
I have the following code:
Private Sub cboAssetNumber_AfterUpdate()
If Not IsNull(Me!cboAssetNumber) Then
Me!txtAddress1 = Me!cboAssetNumber.Column(1)
Me!txtCity = Me!cboAssetNumber.Column(2)
Me!txtState = Me!cboAssetNumber.Column(3)
Me!txtZipCode = Me!cboAssetNumber.Column(4)
Dim db As Database
Dim Rst As DAO.Recordset
Dim qdf As ...
|
9 |
30.09.2006 13:16:42 |
|
|
Can I use InfoPath and Access in Moodle?
I have uploaded an InfoPath 2003 form and an Access 2003 database (to which
the form is connected) to Moodle 1.5 on our college student network. When I
click on the InfoPath form I get the message that the form cannot be opened.
Does anyone know the reason for this, please?...
|
2 |
30.09.2006 12:58:56 |
|
|
count summary question
I have a query that returns a list of transactions and dates and currencies
(plus various other fields) . (amount, ccy, sdate etc)
I am trying to buid query that tells me the count of all transactions that
are within the last 30 days, split by ccy.
I'm using the count(*), and date()-30 to get an overall result, but i cant
seem to get one query that will give me this seeming simple thin...
|
4 |
30.09.2006 12:24:23 |
|
|
installing office upgrade on laptop & PC?
Am I allowed to install Office Professional Upgrade on my laptop as well as
my PC?
The laptop came with a trial....
|
3 |
30.09.2006 12:17:53 |
|
|
Backing up a secured database
I created a database for someone and secured it giving myself admin
permission and the person I created it for user permission. This database
currently resides on a thumbdrive. I would like this individual to have the
ability to back it up to his hard drive so that he has a second copy incase
he looses his thumbdrive. Would this be accomplished with a button on a form
and a macro? He ...
|
6 |
30.09.2006 12:07:49 |
|
|
how to get full screen during game playing
I downloaded microsoft updates, and I can't play games with a full screen. I
don't know what to delete, or how to change my settings to resolve this
problem. I can search with full screen only. Can anyone help me?...
|
2 |
30.09.2006 11:40:02 |
|
|
Combining fields in a report
I'm a complete noob with Access and I'm struggling to produce a report for a
simple contact database. The first field in my record is for "Initials" the
second is for "Name" the third for "Address1" and so on. I want to print out
the name and address where the first line is a combination of Initials +
Name with a single space between.
I've entered this into a text control in my report as =[...
|
13 |
30.09.2006 11:14:10 |
|
|
Get SMTP Server Information
Is there a way to get the SMTP Server Information for a PC's default mail
system. I'm thinking about using CDO, but apparantly the SMTP Server has to
be specified. Every bit of code I've seen has this hard coded.
Thanks.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/200609/1
...
|
4 |
30.09.2006 11:04:01 |
|
|
combining data from different queries
Hi
I have 2 tables
I have one table (customers) with Customer No, Name, Address fields. I want
to link it another table (products) which has Customer No, Product No,
ProdName, Date.
I'd like to create a new table Mailingdata with Customer No, Name, Address,
Product No1, ProdName1, Product No2, ProdName2, Product No3, ProdName3, and
PurchaseDate.
However many products there are I w...
|
5 |
30.09.2006 10:20:43 |
|
|
How to query for first occuring event only
Ok, I'm running some queries in our ER's event times. What I'm trying
to get is the time it takes to get a patient from the door and into a
room. The only way I can see this is with an Event Time and Event
Description. It looks like this
Patient key_EventTime_Event Description
-----------------------------------------------------------------------------
123456____7:55 AM___Patient Regis...
|
2 |
30.09.2006 10:11:00 |
|
|
Updating multi-user mdb, and version control
I have built a 6 user DB and installed it on the server and given access to
the clients. So far so good.
Question 1: Inevitably there will be changes and enhancements that I will
want to deploy. I will be doing the development locally on my own machine
and will want to upgrade the shared mdb on the server. Obviously I cannot
just overwrite the existing one as that would wipe out all the ...
|
3 |
30.09.2006 09:59:05 |
|
|
Linear regression in MS Access
I am developing an MS Access database that should forecast a manning
load. This forecast is based on linear regression (which I until now
have performed in MS Excel). However, I would like to automate the
actual linear regression part into Access. But how do I do this.
I cannot find any methods or anything explaining this on the net. I
would rather not through the long way of implementing the...
|
4 |
30.09.2006 09:29:01 |
|
|
Searching through list box based on query
I have a list box based on a query. When you hit the first
character of the query it takes you to the records that
begin with that character.
When you hit another character, it takes you to the
records that begin with this new character. I would
like it to go to the records whose second character matches the second
character hit on the keyboard.
...
|
3 |
30.09.2006 09:03:01 |
|
|
How to prevent the Mouse wheel from moving input data in forms
Hi,
I am relatively new to access - and am experiencing a problem where if I use
my mouse wheel, it changes my blanks out my form. Is there any way I can
prevent this? A setting perhaps?
Thanks in advance...
|
2 |
30.09.2006 08:18:34 |
|
|
How do I keep data together on report with group?
I have a database for sponsors of trophys. I have a sponsor table and a
trophy table. The trophy table lists the sponsor. Some sponsors may have
multiple trophies. I created a form to be sent to sponsors with a list of
their trophies. I can't get all of the trophies from one sponsor to print on
one form. I get separate pages for each trophy. Please help if you can. I
am very Acce...
|
12 |
30.09.2006 03:57:12 |