Query Help 04-27-07
I have a form where the user can enter from 1 to 4 different criteria in text
boxes. The text boxes are: ReceiptNum, Date, BuyerName, Staff. What I'm
trying to accopmplish is to run a query based on that criteria. What I want,
for example, is if I'm looking for a record of all sales on 11/30/2006, then
I enter this in the Date field and leave the other fields empty. All sales
on that date appear, regardless of Staff. If I'm looking for all sales on
11/30/2006 by Staff John Doe, then I enter 11/30/2006 in the Date field and
John Doe in the Staff field and leave the other...Fastest way to deploy changes
I'm giving some advises to certain company. They have a Project STANDARD
Environment (2007) and I've created several custom fields for their Projects.
Since they have between 20 and 30 projects, I need to find the fastest way to
deploy changes in that custom fields.
So far I've followed these steps:
1.Make changes to the custom field in the project template.
2.Copy modified field to the global (overwriting the existing one)
3.Copy field from global to EACH project (have to open one by one)
Changes include: formulas, lookup tables values, graphic ind...Best Access to ASP.NET converster
Does anybody know what would the best Microsoft Access to ASP.NET converter
Desktop Solutions for Small Companies
Message posted via http://www.accessmonster.com
I'm not aware of any of them being any good.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"vanleurth" <u13147@uwe> wrote in message news:72f5c6880730b@uwe...
> Does anybody know what would the best Microsoft Access to ASP.NET
> Thank you,
> Desktop Solution...Information Store keeps stopping
We are running Exchange Server 5.5 and 1 or 2 times a day
the Information Store is stopping. So far we have been
able to restart it with no problems. In the system event
log is the following message:
The Microsoft Exchange Information Store service
terminated unexpectedly. It has done this 15 time(s).
The following corrective action will be taken in 0
milliseconds: No action.
I have searched everywhere that I can think of and any
description of a problem that sounds even close to this
just says to install the latest service pack to fix it.
We already have the latest SP on it t...Problem with installing Office information bridge Framework for MS
I have already sucessfully installed Microsoft Office
Information Bridge Framework Server 1.0 (server
component) and Microsoft Office Information Bridge
Framework Client 1.5 (client component)(1.0 is not
avaliable any more), and Information Bridge Framework for
Microsoft CRM server components. But when I install
Information Bridge Framework for Microsoft CRM client
components, there is an error message as follows:
Application has been genenrated an exception that could
not be handled.
Process id=0xa24(2596), Thread id=0x164(356)
Did anybody see th...SQL Query needed
Type # Amt # Trno # DC # Code # Subcode
ADV # 1000 # 1 #D # 103625 #
ADV # 1000 # 1 #C # 103400 # S1
ADV # 2000 # 2 #D # 103625 #
ADV # 2000 # 2 #C # 103400 # S2
VES # 5000 # 1 #D # 103400 # S1
VES # 5000 # 1 #C # 300070 # S1
Now I wanna find out the details of Code & Subcode of Type(VES) which does
not match with Type ADV
Expected result should come with subcode of the other record
ADV # 2000 # 2 #D # 103625 # S2
Thanks in advance
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/2010...Need Query or Macro to Update Form
I have a form with two textboxes, both tied to field names in the table I am
using for the form. The two fields are GroupName1 and Groupname2. I need to
build a query or macro to run where if there is any text in Groupname2, to
transfer the text to a new record where the text from Groupname2 is now in
Groupname1 field. Please help!!!
You've described "how" you want to solve a situation... but we have no idea
what situation this is supposed to solve!
More specific descriptions will probably lead to more specific suggestions.
www.In...Group same type of field from 3 different queries
Can anyone help me with this?
I have 3 different queries each summing up a value for a given month.
Past sales, present sales, future sales, these only have two fields Month
What I want to do is create something like
Month Past Present Future
Jun 5278 3424 3454
Jul 5625 6254 5462
Jun 2562 5264 5262
Where it will merge the two values for Jun, this will account for more than
one product showing a summary of all sales.
Ive tried using crosstabs queries, nested queries, even writing ...SQL query question 06-04-07
I have a SQL query question...
I have a table with road segments that have a low and high address
(see sample QUERY below)
I am wanting to produce a report of the roads that meet the
1. [FROM_ADD] > 0
2. the [FROM_ADD] > [TO_ADD]
3. if there is more than one segment with the same name...
the [FROM_ADD] < the previous road segment with the same
So if I ran it on the query below, I would end up with...
AARONDALE ROAD Because third segment's [FROM_ADD]
...Best Seller Report
Need to get some info out of GP 10.
We need a report to show our best selling items top seller down. Can't find
this in GP.
How do we get it?
SmartList Builder, SQL Reporting Services, or Crystal.
MCP-GP, MCT, MVP
East Coast Dynamics
...Query Criteria Question
I'm trying to make a query of two tables however they both have multiple
entries of the same information. One table has about 2300 Item Numbers with
lots of duplicates; the other table has about 10000 Item Numbers with even
more duplicates. What criteria do I need to use to get the query to find the
first matchings in both tables and then move on to the next without using the
previously matched numbers?
Thanks In Advance,
> I'm trying to make a query of two tables however they both have
> multiple entries of the same information. One table has about 2300
>...Show Query Design Toolbar
I am starting my database with the database window and built-in
toolbars hidden. Certain people have the right to created new queries,
so I have created a button (which is visible only for these people)
that will display the database window so they can access queries.
The problem is the Query Design Toolbar is not displayed when they go
into Design view. I have tried to show the toolbar using the following
statement, without success:
---DoCmd.ShowToolbar "Query Design", acToolbarYes
I have tried putting this statement before and after the statement
that opens the database window, a...Use Of ":" In Query As Part Of Header
I have a query with a field name of "Street", however, I would like it
to read "CAT:STREET".
This query is exported to a csv file the requires the format of the
later. Currently the csv file is modified manually afer the fact.
In the query I have been unable to create an expression that does not
choke on the ":".
Any suggestion as to how allow this in the query, or maybe allow this
in the export.
Thanks in advance
You won't get that fixed. Can't you use as header CAT_STREET:
> I have a query with a ...SQL Trace: "Normalizing" TextData Column Values to Obtain "Query Signatures" for Hashing
The TextData column in a SQL Trace table will contain a distinct
string for any invocation of the captured SQL statement that was
invoked with a set of parameters distinct from those before. So, for
instance, 'EXEC dbo.PayThisInvoice 130254' is naturally different than
'EXEC dbo.PayThisInvoice 342902'. But, clearly, both statements
involve invocation of the same stored procedure. For monitoring
purposes over time, I need to be able to recognize that these and any
similar statements are actually using the same underlying query.
Standard practice, as I under...Is there a way to hide text in a cell?
I'm trying to format a spreadsheet where some information (passwords) should
only be viewed by certain people.... not for the general viewer. Is there a
way to hide text in a cell? I have done it in the past but I can't seem to
figure this out now.
For a very casual and inexperienced user you may get away with something like
this, but anything you do can be easily un-done by just about anyone who could
access these news groups.
You could format the text to white so's it wouldn't show in the cell.
You can go to Format>Cell>Protection and check "hidden"...Create an simple way to subscribe to Outlook!
For whatever reason, I cannot find an easy way to subscribe to Outlook.
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.
In news:387E5...Easiest way to backorder all items on an order.
I have a client who needs to be able to backorder items where significant
qtys already exist in Inventory. These would be quotes made into orders and
they may have upwards of 100 a day.
The date of some of the orders may be up to a year in the future so they do
not want to allocate items that they could sell in the meantime but they need
to have the qtys included when they auto generate POs.
I have looked and there does not seem to be a way to automatically send the
item to backorder but does anyone have an idea of the best way to change this
manfully? I tried to work with macros but...Is there an easier way?
There has got to be an easier to accomplish the same end results as the
attached formula... any pointers?
|Filename: Doc2.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4133 |
wmaughan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29743
View this thread: http://www.ex...Query-Based Distribution Groups #2
I'm looking to create an LDAP query in Exchange 2003 that will show domain
users that are currently logged on. This will allow me to create an email
distribution group that contains only people who are in the office at that
moment. Surely this must be possible as the query is searching Active
Directory, but I've not been able to find a "logged on" attribute and I've
trawled the web and newsgroups for answers but found nothing ... if anyone
knows how to do this, I'd be very grateful of your help!
"Robert Stokes" <email@example.com...Payables Management query
Hi everybody -
can somebody tell me which table holds the invoice information for payables
management. I have to make a query that show which checks paid for which
invoices and I have to include the invoice description as well. Thanks!!
PM10000 - PM Transaction WORK File
PM20000 - PM Transaction OPEN File
PM30200 - PM Paid Transaction History File
Hope this helps,
MCP-GP, MCT, MVP
East Coast Dynamics
I have posted code for a SQL view that may already have everything you need
except the invoice descrip...Reminder for a received email for follow up
I would like to put a reminder on an email already received. This reminder
would basically call my attention to the email (even though the email is in
a different folder). Is there a way I can easily do this?
I'm using Outlook 2003 SP1.
Off the top of my head, quick and easy, drag and drop a copy into your
Such as are your habitual thoughts, such also will be the character of your
mind; for the soul is dyed by the thoughts - Marcus Aurelius
> I would like to put a reminder on an email already received. This remi...Charting challenge/query
The following quote is posted on behalf of a client using Windows and
Office 2003 Standard. Please email responses directly to me, too,
since I do not read this group much.
Any help/insight would be most appreciated. I'll do my best to relay
any questions people have and bring back any answers to said questions.
In an effort to come up with a new way of looking at organizational
structure, I employed Excel's 'Donut Chart' function. My goal was to
have the head of the organization in the middle of the chart and then
that person's direct re...Change the follow up date for multiple emails
I have a group of 14 emails with follow-up dates set for today. I
can't get to them today. Can I change their follow-up dates to
tomorrow as a group, or do I need to do it one by one?
...Filter and Query Records Mismatch
When I perform a filter on a table I get 371 records but when I design a
query based on the same criteria, I get 63 records. And the result in my
report is not showing the correct data based on this. I can't figure out what
I am doing wrong. Any help will be greatly appreciated.
...function in query summing results of 2 switch functions?
can I build an expression in a query that sums the values of 2
computed fields in the same query.
E.g, Sum(1-CF_1 + CF_2) ? CF_1 & CF_2 are 2 other fields that
use Switch statements.
slight correction. Can I do this in the Field builder window:
field_B: (CF_1 + CF_2)
if both CF_1 & CF_2 are computed fields in the query themselves
(basically fields computed from switch statements).
Access is giving me an error saying it does not recognize these as "a
valid field name or expression". I'm not sure why - aren't they
expressions :) ?