Can't get a value from a querry into a forms text box
I have a main Shippin Control table, and a main Shipping Control form
with description of cargo and quantity text boxes. I have a querry which
is a join of tblValues and tblShipping_Control. The SQL is below
SELECT Shipping_Control.DescriptionofCargo, Shipping_Control.CargoQty,
tblValues.Value, ([Shipping_Control].[CargoQty]*[tblValues].[Value]) AS
CommercialValue, Shipping_Control.ShippingDate, Shipping_Control.ShipTo,
Is it possible to make an "update query" to roll back year to date overtime
hours? I have an tblhours that totals all overtime hours worked and refused
in which I have ran queries to sum all of those. Once a year we have to
rollback the year to date overtime hours which means we take the lowest
employee, he goes to "0" and we subtract the lowest employees hours from the
highest employees hours. I was trying to do this in an update query, but
everything I try subtracts, for example, 10 hours from every line of
overtime in the tblhours table. I know you are no...Stored Procedure details in one query
can anyone help in getting below information from all stored
from one DB
we have 100 procedure in one DB of sql server 2005.instead if of
manully getting info for each procedure i want all below details in
one shot or one query
Procedure Name :
Input Parameter :
Output Parameter :
Called By :
Dependent tables :
Thanks in advance
Abhi (email@example.com) writes:
> can anyone help in getting below information from all stored
> from one DB
> we have 100 procedure in one DB ...Lookup on a combo box
I have a combo box in cell C2, with facility locations in it. In another
cell i want to either have an if statement if it matches the name put in an
overhead rate or i could do a vlookup and have a hidden table in the sheet.
Is there a way to do either of these on a combo box.
What kind of combo box is it? Is it a Forms combo box or a Control Toolbox
combo box? You have to do the lookup based on the combo box linked cell. The
2 types of combo boxes use the linked cell differently.
A Forms combo box will return the selection *index number* to the linked
A Control To...Enable Macros Dialog Box
Is there a way to not have the dialog box that asks you if you want to
enable or disable macros in a word document not show when opening a document
with macros. I have a form I want to send to a group and I don't want that
dialog box showing when they open the document.
Thanks very much for you help.
If I'm not mistaken, the decision to enable or disable macros in a received
document is determined by the recipient , not the sender.
> Is there a way to not have the dialog box that asks you if you want to
...Crosstab Query: Column Heading problem w/ Dates
running access 2k;
don't know why Xtab queries seem to be SO hard to understand....
I have a REALLY simple table:
all I want is a query that produces:
contact_ID 1st_call_date 2nd_call_date date3
clearly, I need a datediff formula to create the date 1, 2 3 etc...
But I can NOT get the 1st date from 1 person, to line up in the same
column as the 1st date from another...Combo Boxes in Charts
I have created a chart which includes a combo box which refers to a list
of names. The problem is that the font size is too small - size 10 - and
I would like to make it bigger. Have tried changing the font size of the
data range for the combo box but this has no effect. The properties of
the combo box let me change its size but not the font size of the list
Shirley Munro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=83...Placing an CHtmlView on a Dialog Box.
I have created a dialogbox . On Above that I placed a Window Created
from CWnd , parent of this window is my dialogbox.
Now My task is placing a CHtmlView on this Window(Window Created from
CWnd). Is it possible.
> I have created a dialogbox . On Above that I placed a Window Created
> from CWnd , parent of this window is my dialogbox.
> Now My task is placing a CHtmlView on this Window(Window Created from
> CWnd). Is it possible.
You can use CHTMLCtrl:
...Main form, Tab control, subforms and a query question
I am trying to build a main form, that will have a tab control and 2 pages
each with a subform (the easy part) . I have this already, but I have 2
seperate forms and 2 query's for the tab control pages. I figured this is
not the best way - if I had to make a change, I have to do it twice - I'd
rather figure out how to build it to reuse them. And then I may be able to
apply that to other forms still to come.
What I would like to do is:
Have one query, and one form as the subform for both tab pages, and have it
filter based on which page it's one.
So the structure I...Consistant Box Sizes in Visio
If you can answer this impossible question which should be an easy quick
answer, mad props to your ingenious mind!!
All I am trying to do in my Human Resources Organizational Chart is make all
of my shapes (which are all square boxes) the SAME SIZE (at once).
So far I can view the dimensions of a shape by going to the
Insert--field--Geometry, etc. Or I can go to View--Size & Position window
and type in the exact height and width of a box---but HOW in God's name can
one select all the boxes and find a field to type in the dimensions desired,
and have them ALL chan...importing data from the query wizard
i have tried to import the data using the query wizard but all i get is
SYNTAX ERROR in FROM CLAUSE. Im not doing this using visual basic so i have
no idea how to correct this error. Can anyone help please?
...How to get the info from form to query to report
I have a form that uses 5 tables for the information so I built a query to
have the info all in one place. I also want to use the submit button to send
the information to a report to be emailed, right now the report comes in
blank. Please help I am fairly new to access and trying to build this for
Base you report on a query.
Use the form reference as criteria in the query like this ---
[YourObject] is displaying the data from the 5 tables.
Build a little - Test a little
> I have a form that us...Protection of check boxes in excel 2002
Hi I have a form set up in excel with check boxes, and I wish to protect the
sheet but allow users to be able to select and deselect the check boxes.
When I protect the sheet and then use the sheet, an error mesage lets you
know the sheet is protected and read only, I have tried in format control for
the check box to deselect the locked option and lock text option. Its bound
to be simple but help is always welcome.
Try unlocking the cells that are linked to the checkboxes.
You can hide the columns/rows that contain the link (or move them to another
Newbeetle wrote...How do I add a floating text box in Excel?
I have a shared workbook with several huge spreadsheets. There are certain
things that other users/viewers would readily want to know without parsing to
the end of the spreadsheet. How can I create a floating text box in Excel
and include totals of certain cells from the same worksheet?
MS has lots of templates at:
And there's always google!
> I have a shared workbook with several huge spreadsheets. There are certain
> things that other users/viewers would readily want to know without parsing to
> the...Variable Criterion for Query
I have a form, FORMA, that has a button and two text boxes. Clicking the
button runs a doCmd OpenReport. The report contains a subreport which runs
a query, which uses the values of the text boxes on the form for its
The problem is that I now want to use the same subreport in another report
with another form, FORMB. And of course at the moment it isn't working
because the criteria of the query is pointing to a filed in FORMA, which
I can see various way around this but I'm wandering what is the slickest
scaleable method. Here's m...Business Portal
Dynamics GP v9.0 - Business Portal 3.0
Before I go to the effort of document this information....I was wondering if
there is some sort of documentation available which will give me the hierachy
of the "select" columns under Modifying queries in Business Portal.
I am working with our sales force to developing a results viewer that will
return as much information as possible for them as they transition off
Dynamics to Business Portal.
I have spent hours combing through the "select columns" section under
"modify query" (no matter whether 'inventory' &...Query data and formatting
I have a query on a VFP table (linked through ODBC to our sales software) to
summarize the daily value of sales orders entered. I need to group it into
weekly amounts and daily amounts but cannot manipulate the data in the query
to finish it in a report. I have the daily values totalled by day, but cannot
group it beyond that. My end result should display:
Date Daily Amount MTD Amt YTD Amt
Week of (date) with sub-totals
Is there a query criteria formula I can use so I can keep the link to the
...does this xpath query work in .Net 2.0?
Dim strFacilitFile As String = Func_Facilit(strJobSite)
Dim xTempltDoc As New Xml.XmlDocument
Dim xGpDoc As New Xml.XmlDocument
Dim y As Integer = 0
'Dim intNxtInstNumb As Integer = NextInstanceNumber(strJobSite)
Dim intNxtInstNumb As Integer = FacilitNxtInstNum(strFacilitFile)
Dim intGpFlag As Integer
If CInt(arlsGpYN.Item(y)) = 1 Then
Dim intGpYNFlag As Integer = CInt(arlsGpYN.Item(intGpFlag))
Dim strImgsPth As String =
xTemplt...Use Query or Macro to Creat enew Database
I need to figure out a way to create a new database from within an existing
database during a process in which i am running several queries. the new
database name will have a generic name like "Quarterly..." but will then be
concatenated with the quarterly submittal date in a specific format (e.g.,
I'm thinking i could create a query to determine the quarterly date and then
concatenate with the other part of the file name, but how would i actually
create a process for creating a new database (in a specified directory) from
within my existing directory. any sugg...Special Combo box
Access 2007, programming in 2003 mode.
I have a table "tbl_tasks" which is the main table of my application.
Several of its fields are lookups into other tables such as
tbl_persons and tbl_urgencies.
On one or more of my forms, I want to be able to filter list boxes via
queries tied into the combo boxes. As an example, tbl_urgences
I want to enable the user to filter what shows up in list boxes based
on a combo box which would take its values from tables like
t...Adding a databound list box to excel ?
I need to add a databound list box to excel.
I would like me to type in a cell, the contents of the listbox is from
a MS Access database !, I just can't see any help in the excel help or
google searches :(
any help would be grateful
...Excel Query error #2
I've created an Excel query which pulls monthly sales.
The criteria fields are store, sales accounts, month and
year (the first two criteria are fixed; the last two have
the parameters entered when the query is run.
The fields returned are store, sales sub accounts, sales
amount and month. The query works fine, but it gives me
all of the sales detail -- 20,000 lines -- and I just want
the totals, so I clicked on the sales amount field and
selected "sum of". Now I get an error: "Too few
parameters. Expected 2" when I run the query. What am I
doing wro...Query or Retrieve Email Activites Problem
I'm trying to query the email activities that show under the history of
an object, specifically an account. Ive had success retrieving
activities that are not under the history but I can't seem to find the
exact method to get the ones in the history. Any help would be
Ive used the the activity.RetrieveByObject method and the
query.ExecuteQuery method with no luck.
I have figured out what my problem was.....
The activities were actually associated to a case that was associated
with the account(but was still showing in the history of the account...why does my parameter query repeat the prompt?
I have a query with three parameters. The query asks for each parameter and
then repeats itself before returning the data.
Probably because the query is being run more than once -- perchance, is this
query the RecordSource of a subreport or subform?
<MS ACCESS MVP>
"nickaf" <firstname.lastname@example.org> wrote in message
>I have a query with three parameters. The query asks for each parameter and
> then repeats itself before returning the data.
OR have you applied a filt...Query 04-20-10
I have table with which has difference categorys which depend on the name
of the form selected. How do I get this to show up when a form is selected.
Example have a form called Task Order - categories for this are Request,
Issue, Quotation Acceptance. Another form is called Technical Query with
categories Technical query/Resolution, Alternative Proposal, Notification of
CE, Early Warning. There are a total of 5 forms and only 4 Categories.
Pavement Maintenance Technican
You need a combo box with the rowsource type ...