combo box recording incorrect values
I have a form with a combo box that looks up values from a table. There are
three columns, ID, lngClient and txtCompany from tSuppliers. The cbo is
bound on column 0. ID and lngClient are hidden.
When I create a new record and select a supplier, say Alpha Inc. it records
the next company on the list. In this case the ID for Alpha Inc. is 1 and
next on the list is ID 2, Beta Inc. The record created is shows Beta.
I have recreated the cbo, but I still get the same result.
Any thoughts on what is causing this? Let me know if you need any
Thanks in advance.
...Insert AutoFilter selections in Header
I have a spreadsheet that I want to be able to autofilter, then to print the
My problem is that I also want to show what Criteria was selected from the
AutoFilter drop downs in the Header.
Is this possible? If so, how?
Any help appreciated.
...On status bar, sum of selected cells doesn't automatically appear.
Excel 2003 -
when you use the auto filter - nomally the sum of cells selected
automatically shows up on the bottom left hand side of the status bar - eg:
32 of 100 records found..
but this is not always the case when i open or start a new worksheet
Can anyone tell me if there is a function to activeate this on my
Debra Dalgleish explains why and offers some workarounds:
> Excel 2003 -
> when you use the auto filter - nomally the sum of cells selected
> automatically shows up on the bottom l...when i change data in a sum forumla, the sum doesn't change?
i am doing a simple sum formula, using it several times in the worksheet, and
it used to work fine, however, suddenly now the formulas are only working
after the initial calculation, if i go back and change data later on, the
formula doesn't reflect any changes and special pasting of the formula only
reproduces the value of the original calculation! I want the Sum function to
work as it should. Reflect changes as they are made and be able to paste a
function to another group of cells!
Under Tools->Options->Calculation make sure Automatic is checked
"richard_kta"...Update information on a subform from another subform
I have form called Schedule with two subforms. One subform shows appointments
by date and the second subform show appointments by time. I want to update
the form showing appointments by time from the subform by date. I tried the
Forms!APT! = [AppTime]. Forms!APT is the subform showing
appointments by time and the [AppTime] is on the suform showing appointments
by date. I get an error saying cant find the form APT referred to in your
Macro or VB Code.
Thanks in advance for any help
Subforms are not seen as form objects. They are seen as the Source Obec...selecting formatted cells
I have two columns of data (column A and column B). I have applied a
conditional formatting so that cells (in column B) that appear in B
but not in A are shaded. Now I am trying to select JUST these
formatted cells from column B and put them in a new file. I don't want
to have to Ctrl+Click to select them because I think there's about
5000 items that were detected as missing from Column A. Is there a way
to select and copy these cells with some function or program? note
that I am just diving into Excel and i'm learning something new
everyday. Also, I know crap for VB.
Thank...How can I select printer in a vbs-file?
I have a vbs-file, which prints me word-document.
I would like to print it to different printers some times and I would
like to have a possibility to select printer during the code.
What is the code for that?
On Aug 18, 7:31=A0am, hannu <hannutlappalai...@gmail.com> wrote:
> I have a vbs-file, which prints me word-document.
> I would like to print it to different printers some times and I would
> like to have a possibility to select printer during the code.
> What is the code for that?
WSH has...Status Selection
I have set up an Access file which includes over 500 records of employees who
have attended a required training class. They have two chances to pass, and
the information is indicated as follows:
Passed first training. (Y/N)
Passed first exam. (Y/N)
Eligible to attend second training. (Y/N)
Passed second exam. (Y/N)
However, there are those who signed up for the 1st class but had to cancel
for any reason wherein this information is included in the Status field
information. I finally was able to set up the query criteria for the Y/N
columns, but the Status field only appears for those fou...Forward selected attachments from another email
I received an email with 10 attachments, and I want to forward 5 of them to
someone. How can I select the attachments and send in a new email? I am
using Outlook 2003. In Outlook 2000, I can do <Ctrl> + highlight the
attached files, but can't do it in 2003. Any suggestions?
"Tiffany" <firstname.lastname@example.org> wrote in message
>I received an email with 10 attachments, and I want to forward 5 of
> someone. How can I select the attachments and send in a new email? I
> using Outlook 2003. In...how do I sum only visible data in a column
I have some rows manually hidden, Please is there a formula I can apply to
return the sum of the unhidden data contain in a column?
If you don't want to use VBA (create a UDF), you could review the following
In any case, there is a fundamental issue with both approaches: since
hiding/unhiding rows doesn't trigger any event, such event will have to be
forced from time to time, or maybe you can leave with the formulae updating
their result in the next recalculation...Simulating Explorer type selecting using Shift Key + LButtonDown -
Iam looking to have a Behaviour( Selection of ListCtrls items) in Windows
Explorer Shift + LButtonDown and does any one have idea about that using
Thanks and Regards
That method of selecting will work in a list control by default. You can
also use Ctrl+Left Button to select items that aren't connected.
"suresh at his best" <email@example.com> wrote in
> Iam looking to have a Behaviour( Selection of Lis...conditional sum #6
I would like to count the cells from A1 to Ax, hvor x is a number I read in
Something like a calculated range. Which formula does that?
"Uffe Kousgaard" <firstname.lastname@example.org> wrote in message
>I would like to count
It is actually the sum of the values in those cells I am after. Otherwise it
would be too easy.
On Oct 7, 8:43=A0pm, "Uffe Kousgaard" <o...@no.no> wrote:
> "Uffe Kousgaard" <o...@no.no> wrote in message
I've data that looks something like this:
Product Period Qty
Pdt1 Q1 12
Pdt2 Q2 10
Pdt1 Q3 08
Pdt3 Q2 07
Pdt4 Q2 06
Pdt2 Q2 06
Pdt3 Q3 11
Pdt3 Q3 25
Pdt2 Q4 23
Pdt4 Q4 08
Pdt2 Q2 19
Is there a formula to sum the total quantity of Pdt2 in
One way if your table (including headings) is in A1:C12
Another using an array formula:
=SUM(($A$2:$A$12="Pdt2")*($B$2:$B$12="Q2")*($C$2:$C$12...using IF to select 2 different formulas
I'm trying to use the IF to select 2 different formulas depending on
the text entered.
here is what I got so far ,
It functions correct when you input a "r", but gives me the #NAME?
error when a "s" is entered.
Can anyone offer a solution to this problem?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
=IF(J20="r",G20/3800,IF(J20="s",G20/15...NetWork Printer Selection Problems
I need some assistance please with a network printer selection.
I use two network printers one colour the other non-colour and I need to
print documents to both printers at different times during the day. The two
printers are in different parts of the building. I currently use code to
designate the printer required, such as:
Application.ActivePrinter = "Colour Admin Office on Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Colour Admin Office on Ne03:", Collate:=True
Application.ActivePrinter = "Lexmark E323 on ...how to pull a record to a form and save it to another table
I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What I'm trying to do is take a Whole record and save that
record to a new table.
Why? It's seldom a good idea to store redundant copies of data.
You can use an INSERT INTO query:
Dim strSQL As String
strSQL = "INSERT INTO TheOtherTable(Field1, Field2, Field3) " & _
"VALUES(" & Me.txtNumericField & ", """ & _
Me.txtTextField...Sum of common rows
I am trying to find an automated way of summing common row
data. For example:
Row1 123 John Smith
Row2 456 John Smith
Row3 678 John Smith
Row4 324 Dave Jones
Row5 678 Dave Jones
Row1 1257 John Smith
Row2 1002 Dave Jones
I have several thousand rows and don't want to write
something that is specific to the data that appears in the
Row 1(col A and B) must have a header like Number and Name
It will make a Unique list in Col C and the sum in Col D
Dim LastRow As Long
With Sheets...dynamic combo box on subform- show full list Box on main form
I have a combo box on the subform cbomanname its row source is based off of
queries that only show employees Not sched(ie. available) for that Given
Workdate the combo box is updated for each workdate as emplyees are sched -
names taken off of combo box. I would like to DISPLAY this combo box as a
List box on the Main Form - I copied and pasted the combo box onto the Main
Form and changed it into a ListBox(just reallywant to see all of employees
available for a given day(workdate) that sitting on in subform). but for
some reason the new copied ListBox on the Main form show...select class by combobox??
I'm wirting application which will be "host device" or "peripheral
device" Program will be to perform two roles. I choose it when I
starting application. And in first case I use some other functions
which I will not use in second case and vice versa. So I thing that I
can use two class for each case separately. And I want choose class
which I want use by combobox... How can I do this ?
some function and variables
some function and variables
//select class - c_number_class is variable of combobox
int nIndex = c_number_class.GetCurS...Table record count
Is there an easy way to get the number of record in a temporary table without
yes i just did that
Declare @RowCount Int
set @RowCount = (Select Count(*) from "YOUR TEMP TABLE")
why not use countrecords() function - assuming dexterity here of course.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Phil M" <PhilM@discussions.microsoft.com> wrote in message
> Is there an easy way to get the number of record in a temporar...sums on a query
I’m building a query that I would like to sum quantities of a part numbers
used on multiple Purchase Orders
PO Item # qty sum
16 100 2 5
27 100 1 5
39 100 2 5
19 200 2 7
26 200 5 7
Use the 'Totals' button in the query designer (see toolbar in query, look for
Then group the field you want for instance the 'item' field, just above the
criteria field use the arrow for the group by..
> I’m building a query that I would like to sum quantities of a part num...Problems with select statement that is a combination of select and a variable
I would like to create a search form that is pretty flexible so I
created a from with oll the fields possible on it so you can fill them
in or not.
then I put a button on it that will get the query in a listbox.
this is the code behind the search button:
Private Sub cmdSearch_Click()
Dim ctl As Control
Dim qry As String
Dim teller As Integer
Dim lengte As Integer
Dim i As Integer
Dim field As String
Dim fieldtxtlen As String
Dim fieldtxt As String
Dim Condition As String
Dim sSelect As String
'Clear the listBox
lstQuery.RowSource = &q...Select and display records on Form
I am trying to create a form which :
(i) allows user to input criterion to select client records by various fields
(ii) display the records meeting the criterion in a sub-form on the form
(iii) ultimately, allow user to de-select/delete individual records from the
select results before delivering each an email
First I tried to launch a make-table query via a button and let the sub-form
query those results. But whenever the button was pressed, it could not
complete...record locking, I guess, against the sub-form which has that table
Then I tried to launch a simple query...calculating the sum of a range
I am trying to calculate the sum of a range.
In a sheet I'd just select some cell and type "=SUM(a3:a15)".
But I am trying to do this in a makro and its crucial that I do not
manipulate the sheet.
So I need to call a function - that is available from within a cell -
from outside a cell.
I am looking for something like:
dim a as double
a = range(a3,a15).sum
a = calculate_excel_function("=SUM(a3:a15)")
thanks in advance
msgbox Merry Xmas
dg...Creating a button that goes to the next new record
I am fairly new to access and i am trying to build an inventory database that
lists all our grounds maintenance equipment. I have all the records typed in
but would like a button for adding new equipment as it is purchased. Ideally
the button will take me to the next new record rather than an existing one.
What is the easiest way of doing this?
I am using Access 2003
At the bottom of your form, there are navigation buttons, like this:
|< < [ 5] > >| * of 77 records
The star button takes you to a new record.
If you don't see this, open the form in design view, an...