Query for latest salary
I have 2 tables with EmpID, Date and Salary. Can i make a query which will
pick the salary with the latest date for each EmpID?
Thanks in advance for any help
How do i use the max function on both the tables? i need the latest
considerign the union of the two tables.
"Maurice" <Maurice@discussions.microsoft.com> wrote in message
> You could use MAX([Datefield]) in your query where datefield is the field
> use for the date...
> &qu...Open third-party form with VBA
Is it possible to use VBA to open a third-party form from a GP form?
My specific example is I want to open a vendor cost inquiry screen
that's in the Myridas dictionaries using a button on the GP Item Price
List Maintenance screen.
Is this possible? GP 9.
Thanks in advance.
Yes, it is possible. Add a reference to the Myridas project in your Dynamics
GP project in VBA. Take a look at my 3-day VBA Workshop at
http://dynamicsgpblogster.blogspot.com/2009/02/this-week-free-visual-basic-for.html for the technique I used.
Mariano Gomez, MIS, MCP, PMP
Maximum Glo...Change Query Field Name
I have a query with the field name "LastName". When I pull a report and
export it to excel at the top of the column it come out as "LastName". How
can I change it in the query so when I export to excel the column heading
says "Customer/Entity Name?
Use an alias:
SELECT LastName AS [Customer/Entity Name]
<MS ACCESS MVP>
"Stockwell43" <Stockwell43@discussions.microsoft.com> wrote in message
> I have a query...web query on EXCEL does not work. Why?
In November 05 the link to the financial query in Excel stopped working. The
error message says" ...unable to open
I've tried it on several different computers. What am I missing?
Not sure if it is just a typo but shouldn't
(ie a missing colon)
julied at hctsReMoVeThIs dot net dot au
> In November 05 the link to the financial query in Excel stopped working. The
> error...Creating a select query from multiple fields on the same table
I've created a table for stores, the primary key is Store Name.
I've created another table for input of deliveries to stores on an
employee's shift. This is set up as Load 1,2 and 3 with Drop 1,2,3 and 4 in
each load. Each drop is validated from the store name field in the store
table. Each drop has an arrival and departure time.
The relationship set up between the store and deliveries table is a one to
many from store name in the stores table to the Load 1, drop 1 field in the
The query i want to create is by store, summarising dura...How do I set up a click "column title" and auto arrange data form.
you may provide some more details what you're trying to achieve. also
post your question as body of the message and not as the subject title
"Max" <Max@discussions.microsoft.com> schrieb im Newsbeitrag
...Exch2003: Query-based dist groups ?
I'm trying to set up query-based distribution groups on an Exchange 2003
server. So far no problems in collecting most of the data I need - but is it
somehow possible to specify in the filter, that disabled accounts should be
omitted from the distribution-group ??
...Auto fill form from a worksheet
Using Excel 2000 Professional for work
I have a worksheet (Log) that has 7 columns, the first column is a list of
pre-set numbers for reports. The second worksheet is an Incident report
form. 6 of the 7 colums on the log are also on the report form. We open the
log sheet which has pre set Report numbers, then fill in type of incident,
location of incident, start date and time. Then open the report form and add
the same information into the form plus more information not on the Log. Is
there any way to link the 2 worksheets so as the information is added on the
Log it will au...Business Portal Query Security
I need to create payroll & HR queries for users, but I do not want them to
have the ability to modify queries or to create new queries.
Thanks for using the newsgroups. I wouldn't suggest tring to secure your
data by not allowing users to create or modify queries. The best way to
secure your data is through the data permissions. Only give users data
permissions they should have. You can create new data permissions and take
away properties if appropriate. Finally, BP has out of the box data
permissions called "XXXX-Restricted Self". This means the user can..."Query cannot be edited by the Query Wizard"
Hi. User gets the message, "Query cannot be edited by the Query Wizard" when
editing a query. After clicking OK, MS Query appears and the query is
The switch that controls this option appears to be- Data Menu, Get External
Data, New Database Query, checkbox "Use the Query Wizard to create/edit
queries" at the bottom. This is checked. The problem follows the user to a
different workstation as well.
Thanks in advance for an advice.
can excell make a query?please help me
Look in Excel's On-line Help for the topic "Importing data with
> can excell make a query?please help me
Excel FAQ, Tips & Book List
...Form does not display all records in a table
2007 Up to date
Recently inherited an Access database with 8 separate tables.
A series of forms were developed to aid users to Add/Modify/Delete records.
There is a table called "Utility Vendors"
There is a form called "Utility Vendors"
After activating the form, I have access to all the records in the table "Utility Vendors" except
for one record. The fields in this record contain accurate data and the record is toggled "active".
FYI, I did enter the data in the "missing" record directly into the table (not via the form)
I do not bel...Continuous Form Question
I have a continuous form that has
I have a combo box cmbsearch that shows HorseID,HorseName, that is queried
to a query to only show unique Names
How do I filter my Continuous form so as when I select a HorseID,HorseName
it only shows those records below
Thanks for any help..........Bob
Assuming that cmbSearch is on the main form and HorseID is its bound column,
use the AfterUpdate event of the combo:
Private Sub CboSearch_AfterUpdate()
Form("SubFormNameHere").Form.Filter = _
"[HorseID]=" & Me.CboSe...From Query to Table via Form?
(I'm not even sure how to ask this, so patient people only probably need to
Portion of my database deals with preventive maintenance performed to vessels.
Originally I was instructed to utilize the database to create a library of
sorts dealing with equipment on a fleet of vessels. Followed by a general
table for entry that the maintenance had been completed, hours at time of
To keep from having to repeat Prev.Maint items for each vessel I set up the
tblvesselCompartment(main engines, bow Thrusters, steering etc...Open form to specific record quits working
I have a customer search form that opens a specific customer order. Sometimes
when I add a field or make a minor change to the customer order form, the
customer search pulls a blank or new record. I delete the change I made to
the order form but a blank record is still pulled. What can I do to fix this?
Sorry, I meant to post this to Access.
"Ron Weaver" wrote:
> I have a customer search form that opens a specific customer order. Sometimes
> when I add a field or make a minor change to the customer order form, the
> customer search pulls a blank or new record...Thanks for all the help on Year-to-date query!
It's so great to know that there are folks out there that can take the
time to help someone whose 78 year old brain is slowly turning to
Francisco 9 @ ATT N E T
...Prompting for a parameter in a query when one isnt present
I am trying to use an Iif statement in a query, using a calculated field as
one of the result paramets:
[code] is a field in the query being drawn from a table, while [tothrs] is a
calculated field in the same query. But for some reason it prompts me for
[tothrs] when I run the query.
This seems to happen anytime I use a calculated field in a query in another
calculation? Is this not allowed in Access and if so how do I get around
You need to redo the calculation that is TotHrs in the expression.
Your ot...Printing current record on a report from a form
I am trying to print the information from a current form to a report. I have
searched the web and tried using the different suggestions of code which,
begins with DoCmd.Open Report...but when I use that I am getting a message
that says this Macro has not been set up and I was under the impression that
I did not need a Macro...maybe I am putting this in the wrong place. I have
put the code below that I am using in the Properties of the button on the
form...on the "on click"...Please Help Me!
DoCmd.OpenReport "PrintCustomerReport",acViewPreview,, "[OrderID]=Forms!
frm...union query 11-28-07
I'm trying to create a database that contain electrical
performance of my companiy's product.As the objective,
at last I have a report look like below:
Model: OSC30TDS1 Prod.code: 71102
Ampere Power Airflow
SampleNo 3 10 100
1 2.4 8.7 89
2 2.6 8.8 90
5 ...Create controls on form through VBA
I want to auto-create a form based on input in a table, so
I am looking for sample code showing:
- How to place a control on a form through VBA
as starting point:
> I want to auto-create a form based on input in a table, so
> I am looking for sample code showing:
> - How to place a control on a form through VBA
Here is an example based upon selecting from a checkbox
Private Sub CreateControl()
Dim newButton As msforms.Control
Select Case True
...Error 'Invalid object ##Options' while running Multilevel query in
I created a company in GP9.0 with Analytical Accounting + Service Pack 1,
created a transaction dimension and some codes, posted transactions in POP,
GL and Inventory.
When I ran the Multi level query wizard, i got the error '[Microsoft][ODBC
SQL Server Driver][SQL Server]Invalid object name "##Options" when I gave all
the values and the system started to run the report.
What could be the problem?
Thanks - Murali
The options you are selected in MQW are stored in temp table and using that
"##Options" table is created in run time.It might be because the temp ta...Creating a form with twosubforms and multiple records
I have 3 tables called tblmonth, tblcompany and tblhivalue.
tblmonth has a date field txtmonth
tblcompany has a text field txtcompany
tblhivalue has a date field txtmonth and a text field txtcompany.
All the date fields are formatted mmmm yyyy
tblhivalue also includes a number of other fields which are a mixture of text
and number fields let’s say, txtnbr1,txtnbr2, txtnbr3, txttext1, txttext2,
The records for tblhivalue look like this:
txtmonth txtcompany txtnbr1 txtnbr2 txtnbr3 txttext1
June 2009 ABC Ltd ...Automatically track appointments form Outlook to CRM 3.0
With the sync add-on in Outlook, the 'Track item' is default set on
when creating a new E-mail message. All other items, like appointments,
are all set off by default. A user has to take action and click on
every new appointment when he wants to sync it with CRM. Not handy and
a big chance to miss appointments. Does anybody knows how to set the
Track-button 'on' by default when creating a new appointment/task etc.?
The product out of the box does not support this.
Thanks for your suggestion. We will consider this issue in a future service
pack or release. An Issue ha...Make-table query...
Quick run-down of the problem. We are trying to export tables from
Access to SPSS for analysis. We have tons of variables so had to
break the data up into about 100 different tables within Access.
We're looking for a good way to recompile these into several giant
tables in SPSS.
Basically, what we are doing is using queries to compile the data to
the extent that Access allows us (think the limit is 255 variables).
Then we use a program called Stat Transfer to export the data straight
to SPSS. The problem is that when we run the query, it rips out the
description field, wh...Query Problem
I have 3 tables, 06-07 projects, 07-09 projects, project construction. All
three I set School District Name as the primary key. When I go to
relationships, I pop up the three tables and hook them up with School
District Name, no problem. When I build a query with two or three of the
tables, no matter what I do it acts like I don't have good relationships set
because I get 10,000 - 100,000 records which is 9500 - 95,500 more than I
need the query to produce and there will be 30-50 copies of the same record
of each all the way through. It acts like my relationship is not ok but I am