Sequentially number records in a query
Hi all -
I know this is a common question, but I haven't found a complete answer. Is
there a technique to generate a sequentially-numbered, calculated column in
an Access query so that the records in the query output are numbered 1
through N, where N is the number of records ?
Thanks in advance for any advice or leads,
There are lots of questions and answers related to your question. You might
want to search on "ranking query". If you still can't find an answer, then
come back with your significant table and field names.
Microsoft Access MVP
I am using PA extensively to record nearly verything that goes through our 'P
& L'. I have it set up so that each cost category within PA will actually
post to its 'mirror' in the GL. e.g. Project 'FINANCE_06' category '6000'
(salaries) will post in the GL to account code 6000-0-01 (being salaries,
finance). There are reasons I have set it up this way, too numerous to go
My question is....if I record an invoice through PA, into payables etc. How
do a reverse all or part of this invoice if I choice to? We have an invoice
from a vendor ...Problems with opening a few attachments
I have had a few users experiencing problems with opening attachments in Outlook. When they try and do so, it comes up with a "Can't Open" error message. It is only occurring on a few attachments. I have checked the event log and there doesn't appear to be any issues on the Exchange server (2003). I have checked the hard disks on the server and there a re no issues with them. It is a single server Exchange 2003 environment.
I am just wondering what the next course of action to take is. If you could get back to me on this as soon as possible it would be gr...Problems Printing a Linked Word document
I am having trouble printing a word document that has linked excel tables in
it. When I print the document, some of the linked excel tables get skewed
and distorted. However, they look normal on screen.
What causes this?
How can I fix it?
...Problem opening Excel 2003 in a Small Business edition
When i open excel ,it appears a window "installing:function of Excel"
Its seems like installing a new function of Excel , it last a few seconds
we can work wiht it.
How can i eliminate this
You could try looking into your tools>Add-ins to determine what function
packs are being loaded when you start Excel. If this is poiting to an add-in
on a network drive, it could be what is causing the delay. You can try this
by unchecking each option in turn and closing and re-opening Excel.
Hope this helps
""installing:function of Excel"...How to create a report based on multiple queries
I am trying to create a report based on 30 queries . These 30 queries
are based on one table. When I use the Report wizard and select more
than one query I get the message " You have chosen fields from record
source which the wizard can't connect. You may have chosen fields from
a table and from a query based on that table. If so try choosing
fields from only tha table or only the query".
I do not know what to do.? Any guidance will help
On Wed, 29 Aug 2007 08:21:02 -0700, email@example.com wrote:
>I am trying to create a rep...Report from Access 2003 to 2007 problem
I have converted a database designed in 2003 to 2007. One of the reports
unfortunately does not work the same as it did in 2003. The report
generates invoices and on the form I had put in a text box with the Control
Source property set to [Enter Invoice Date] which brings up a dialog box
when the report is run asking the user to put in a date. This works ok in
2003 but comes up as #Error in 2007 in the report generated.
In 2007 report design, the text box has a green triangle on it indicating an
error "Invalid Control Property: Control Source" & "No such field in t...Custom PopUpBox in Parameter Query
I am using a custom PopUp Box in parameter Query.
( Like [Forms]![Form For Plant Wise Query]![ComboPlant] ).
It is working fine when i am calling this query in my report i.e. when i
open the report the custom popup box appear asking the value and after giving
the parameter value the specified report open.
But when i use the same query as record source in my form and when i open
the form, first the system generated PopUp Box appear asking the parameter
value and after giving the value, then the custom PopUp box appear.
I don't want this system generated Popup Box to appear when i open t...Track Changes Query
Hi I wonder if someone could help me please with a problem that's been
baffling for a few weeks now.
I am trying to create a query, which in turn feeds a report, that shows
tracked changes. I have previously posted on this forum and got some great
advice that's really helped me along but I'm really struggling with the query
to extract the data. I am relatively new to Access in particular VBA but I am
willing to learn.
What I would like to do is to use a date parameter to extract those fields
with an updated time stamp within a given time period, which in turn I can
sho...sum a field value in all querys
How do i sum a value with another field (always the same one) in all my
Later, i would like to change that value to see the result in all querys.
How do i do that?
Please explain me best you can do cose i'm not an expert on access.
Tks in advance
What is the data type of the other field (always the same one)?
The value you wish to sum it with - what data type is it?
For example: if you had a query where one field was called rating and it was
a long integer, if you wanted to add the value 4 to this you could create a
calculated field in the que...Problem restoring backup file from money 98 to money 04
Just upgraded to a new computer with Money 2004 --- Have
transferred my money back-up file to the new computer ---
Everytime I try to open using Money 2004 it begins the
process of converting the file and then times out (stops
Any ideas??? Extremely frustrating as I don't want to
lose 6 years of financial data ----
How long have you waited? It could take a long time--like tens of minutes.
While it is in this state, it will be "not responding." This doesn't mean
it's dead, just hat it's busy.
"jh227" <firstname.lastname@example.org...Problems with licensing
i have got a problem with how to tell exchange how many CALs exists.
In the normal way I put it under Verwaltung/Lizensierung - there appears
under products the Exchange Server 2003. But in this case there is no record
with Exchange Server 2003. I can't find any licensing information for the
Exchange Server. I think something got wrong during installation.
1 x Domaincontroller width Server 2003 Standard
1 x old Mailserver with Server 2000 and Exchange 5.5 as member of domain.
1 x 2003 Server R2 as Member of Domain with Exchange 2003 (newly installed -
will repla...Exchange 2000/2003 Public Folder item Permissions Problem
I've been having an issue with Public Folder permissions for some time now. The folder contains contacts for all company employees (most of which aren't on the company network), and is maintained by HR. Brief history is:
Had Exchange 2000 on Win Server 2000, and a previous administrator modified public folder permissions on the M drive in explorer (a no-no). This resulted in the ESM "Invalid window handle" error.
Managed fix these by following KB 270905 (permissions nuke), and deleting and re-creating the public folder. The latter was a problem, as most users were ...Exchange Cluster Query
I currently have an exchange 2000 setup which recieves email from a filter
system on the DMZ to a single exchange server which then forwards it on to
the 2 node cluster. I want to eliminate this single server and wondered if i
could send the mail from the dmz straight to the clustered IP address
instead, if not what else could I do to get rid odf this server.
On Tue, 11 Jan 2005 06:41:01 -0800, "Phill Heath"
>I currently have an exchange 2000 setup which recieves email from a filter
...Querying Messages Addressed to a Domain
Dumb Question: We have a single Exchange 2003 server receiving e-mail
messages addressed to domain1.com, domain2.com, and domain3.com. We'd like
to turn off domain1.com, but want to make sure messages aren't being
addressed to that domain even though it's not the primary in the recipient
How do I search the information store for any inbound messages addressed to
this domain? Can I do it on the fly over the past say 6 months or does some
type of logging need to have been enabled?
Message Tracking would need to be enabled, or SMTP Protocol logging (the
la...Budget account problems with transfers
Transfers out of budget accounts are distorting my budget reports, yet I
can't add the relevant accounts (e.g account created for a loan to my
business) to the list of budget accounts. Using Money 2005 UK. Thanks for
...Calculation Problem 01-19-10
All though the formula is correct ( a simple math addition between 2 cells)
..There are a few of these cells in my 2003 XL Spread Sheet that consistently
makes a 1 cent error in the addition - that is, it's adds the cell less 1
cent (formatted in currency)
How do I fix this?
Microsoft MVP - Excel
"djm123" <email@example.com> wrote in message
> All though the formula is correct ( a simple math...data entry problem
I am trying to make a detailed sheet of some inventory data whic
changes each month. The first sheet just has general data, but ther
are more columns on the second sheet with varying expanded details
Column A - product number
Column B - color
Column C - available
Column D - Misc notes (may or may not be filled in)
A B C D
2310 blue yes
2348 red M/R must sell soon
2362 blue no
(some text data in-between)
2405 red M/R need to be redone
2450 grn yes sell cheap
2477 wh yes
Month 2 (new ones may be added, and sold item t...MBNA, Yodlle, Money 2006 problem
Over10 days ago I had an account transferred to MBNA Credit Card. (I already
have 2 other accounts with them.)
Since that time I've been trying to setup my accounts at MBNA in Money 2006.
No luck. Each time I try and do it, I receive either the error message
"Account setup is temporarily unavailable. Please try again later." or
"Microsoft Money could not set up your account because of technial problems
at your bank or brokerage..."
Last Monday I called Microsoft about this since the problem had been ongoing
for several days. They verified the problem and said th...Date problem #6
I have a column containing
Which I need to convert to UK dates.
because of the variables(4/, 10/) I am unable to use mid
etc in seperate columns.
also =TEXT(f2,"DD/MM/YY")fails to work.
are these values 'real' date values. If yes a simple format should do
"Gerry" <Gerry.Briant@goodrich.com> schrieb im Newsbeitrag
> I have a column containing
> Which I need to convert to UK dates.
> bec...Solver problem #3
I have a complex equation that is equal to zero with just one unknown that I
have entered as "x". I need to know how to use solver to solve for the
unknown variable. How do I do this? It seems like it should be simple, but
I'm not sure how to enter the unknown into the equation. I keep getting the
error, "Invalid target cell." Which makes me think that I should enter the
unknown into a different cell, or something else. Please help!!!
Assume some value for this x, and then enter this cell as 'by changing
cell'. Your equation cell should be the target cell....Mapi email problem (and Apology)
First off my apology for multiposting. I posted to the wrong group by
accident. This post was meant for this group and not the enterprise group I
had posted to by accident.
I have automated VB6 application that sends email to to clients when
prompted by a user. The app uses MAPI client (using the default mail client
information to send the mail). After sending mail the email and attachments
gets added to SENT Folder of the mail client.
This app has worked well and still does for users using Outlook express.
Am unable to open websites when they show up in Outlook Express 6. Anyone
know why? When I click on an URL all I get is a BONG. Am running WinXP
Home Edition w/SP3.
"bandi" <firstname.lastname@example.org> wrote in message
> Am unable to open websites when they show up in Outlook Express 6.
> Anyone know why? When I click on an URL all I get is a BONG. Am
> running WinXP Home Edition w/SP3.
Outlook Express General newsgroup:
In your newsreader:
news://msnews.microsoft.com/microsoft.public.outlookexpr...Format Problem #2
how can i save an excel file to text file with out
chainging the format.
when i change this to text file the alighment changes like
so how can i solve this problem. i tryied many wayes and
nothing work out properly.
so if someone know this , plzz do help me.
Try saving it as a "Formatted Text (Space delimited) (*.prn)" file.
You may have to widen columns to make it look right. (And I like to change the
font to Courier New--a nice non-proportional font. Then I can see how it'll
>...Debt reduction problem
When I work out a plan for debt reduction, it keeps adding $350 to the first
month of the plan. So for example if I want to pay $263 per month it comes
up with $613. On my old Money 2003 I had worked out a plan paying $350 per
month, but I deleted the account so I don't understand why it seems to have
that number locked in. Any thoughts?
First, reset the DRP--Tools, Settings, Planner Options (or Tools, Options,
Planner in 2004 and prior), and click Reset Plan. Then add the account back
into the DRP. Since your DRP will begin 11/1, if you have any payments due
prior to that date,...