MS Query #6
Just for curiosity.
MS Query has a status bar with seven boxes on the right.
I only get 4, 5 and 6 working: [Caps], [Num] and [Scrl].
Do the other boxes have a function? And if so: what function?
Thanks for a reply,
...Creating a userform?
I would like to enter data to a speadsheet with a userform.
I want enter the data in a form that will automatically insert the data to
the correct cells in my spreadsheet. And then allow me to enter new data on
the next line below.
Is this possible?
I have just put up a file for you at:-
It is item number 42 towards the top of my home page.
In here I have tried to explain, as clearly as possible, what you need to do
to set up and use a Form in EXCEL 2007. There is a simple worked example for
you to work through if you want to.
Please d...Query Results Where Qty Shipped is not Divisable by 4
How would I construct a query to return all invoices where the qty shipped
for a specific item is not divisable by 4? Really its the divisable by 4 part
need assistance with. Thanks!
WHERE YourFieldName Mod 4 <> 0;
"meangene" <email@example.com> wrote in message
> How would I construct a query to return all invoices where the qty shipped
> for a specific item is not divisable by 4? Rea...Open Userforms from a Dropdown list
Hello, and thanks for the help,
I have several userforms and would like to place the names of the forms into
a dropdown list to select the form i wish to use is this possible.
...'Operation must use an updateable query'
I have an issue with a query that I cannot figure out the answer to. I keep
getting the error 'Operation must use an updateable query'. The query I am
SET DGBTestVariations.JURISDICTION =
IIF(DGBTestVariations.JURISDICTION = "NoMoneyMuni",
(SELECT DGBJurisdictionCOO.JurisCodes FROM DGBJurisdictionCOO WHERE
"Municipalities", (SELECT DGBJurisdictionCOO.JurisCodes FROM
DGBJurisdictionCOO WHERE DGBJuri...Why is my query read-only?
I have a query linking my Customers table & my Contacts table, so that
all the information can be displayed together on the screen for
updates and deletions. Unfortunately, the resulting data is read only.
I didn't tell it to be read only. Why has this happened?
Take a look at http://office.microsoft.com/en-ca/access/HP051880011033.aspx
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Stapes" <firstname.lastname@example.org> wrote in message
> ...Addind an external LDAP query into the Exchange 2003 Recipient Lis
Is there a way to take a query from an external LDAP server and place this
list of names into a recipient list in my exchange server? I am running
Server and Exchange 2003.
Currently I am having my users individually setup a LDAP query address list
in Outlook. This is becoming a pain as too many users would like to have
access to the list now that I have it setup for a few. I have attempted to
get the offline GAL from the external server administrators but they are no
longer willing to distribute it and are forcing everyone to pull from the
LDAP query. I know I can manually create a ...opening a userform from a userform
Is there a way to open and use a userform from another userform?
I am using userforms for data entry and would like the option to open a
second form whilst entering data into a form
Can anyone help?
Just Show it. Call is like this...
or like this...
depending on whether you want UserForm2 to be modal or non-modal. Remember
to change my example UserForm name from UserForm2 to whatever the name your
second UserForm is.
Rick (MVP - Excel)
"Roger on Excel" <RogeronExcel@discussions.microsof...Missing Data From Excel Query
I'm querying an Excel database into another Excel spreadsheet. I have two
fields where I want users to input into the database. This input data is not
coming across in my data, even though I'm including the field.
Account Mar Apr Variance Explain Explanation
Printing 546 556 -10 Explain Printed spring catalogue
The explanation field is where the input is, everything else is a formula.
But even if I make the input data into a formula, it doesn't come across in
the query. If I make the input data a number such as 5%, it comes across,
but any text d...check for record before update query
I need to check if a record exisists before I run the following update query.
Not sure how to get there though.
Table name is InspectionLog
Field name is SalesOrder (text field)
Here is my code which runs fine.
stsoNum = InputBox("Enter Sales Order")
SQLstr = "UPDATE InspectionLog SET InspectionLog.PullDate = Now(),
InspectionLog.MotorPullDate = Now(),InspectionLog.MotorLoaded = True,
InspectionLog.PartsPullID1 = [Forms]![PartsPullSwitchboard]![TechNumber],
InspectionLog.MotorLineNumber= [For...Import query in code
I want to import data from one database to another. I have the following
query that will import all the data that i need. I am not sure how to modify
this query to only import data that does not already exist in the table. Any
sql = "Insert into classinfo (showid,classid,classnumber,classdescription)
"SELECT ClassInfo.ShowID, ClassInfo.ClassID, ClassInfo.ClassNumber,
ClassInfo.ClassDescription FROM (ActiveShow INNER JOIN ClassInfo ON
ActiveShow.ShowID = ClassInfo.ShowID) where ClassInfo.SeparateScoring = True
in '" & Text1.Value & "'&quo...Query duplicates results due to many-to-many relationships
I have a query with fields from different tables. Two or three of these
field may have one or more entries. When I run the query, if it displays a
record where there are multiple entries for a particular field, it will list
the record multiple times. An example: This DB involves officers using
force - if there is more than one officer involved, each one will be listed
with the applicable level of force and if the subject is arrested, there may
be one or more charges enterer - assuming there are 2 officers with 3
charges, that record may be listed 5 or 6 times, but the multipl...passwords - userforms
I have a spreadsheet which uses forms to enter and display data. The
Spreadsheet uses a main page form "frmDashboard" from which other userforms
are activated using command buttons. The form frmDashoboard remains open in
the background as a desktop while the user activates the other forms.
I am looking at various methods to password protect the opening of other
forms from the main useform frmDashboard and I use the following code to do
Private Sub CommandButton1_Click()
Dim i_pwd As String
i_pwd = InputBox("Please Enter Password&q...XML query
I need to have a small, easy and portable database and i'm thinking of
having a simple XML file (without using DTD, etc).
Can you please let me know, as to how I can read/write into different
I've given a example XML below and I need to know as to how exactly I can
loop and display all the "Title" attributes seperately (i.e. description and
<?xml version="1.0" encoding="utf-8" ?>
<Title Description="Hotmail" URL="http://hotmail.com>
<Title Description="Microsoft" U...Query into specific columns
Hopefully, this is a simple problem:
I have built a sheet with columns A-H. I query a separate Excel sheet that
contains 4 columns of data that I need. I would like the data imported into
columns A,B,E & G. But the query returns the data to A,B,C & D. What can
hello everybody, is it possible to see the content of a cell (i.e. worksheet
1 cell y32) (and all it's changes) in a userform (which is also used to
input data) while it is still open?
You will probably need some code for that, like
Label1.Caption = Sheets(1).Range("Y32").Text
trigged by some relevant events, like the Exit events of your input boxes.
HTH. Best wishes Harald
Followup to newsgroup only please.
"Mauro" <email@example.com> wrote in message
> hello everybody, is it possible to see the ...what is the query to list records with a certain field empty?
what is the query to list records with a certain field empty?
Put Is Null in the criteria row of the query
> what is the query to list records with a certain field empty?
Thanks a lot
...not recognising a query
shows me an error message: DELETEtbldatentry = empty
The name is correct and the query works fine when opened manually. What am I
why post twice?
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC o...Excel VBA
Hi Excel VBA'ers,
Via Google I found some great code (see below) that enables MouseDown
to paste what's in clipboard. I want this code to apply to ALL of the
textboxes in my Userform. Instead of repeating this code multiple
times for every textbox, I was wondering how/if I can specify multiple
textboxes using the one instance of the code please.
(Hmm, if I'm on the right track, perhaps I have to learn about Class
Modules to do this??)
Here is the code that I found:
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Sing...Web Query with Graphics
Can you import HTML data including any graphics, into a spreadsheet using
Excel web query? Or is there a way to import data from a web page into Excel
and keep the formatting in tact. Especially any graphics such as bullets?
...Basic Update Query
I have the following two tables Invoice-InvoiceProduct and there's a many to
one relation between them, I use the following query to work out the total
base on all the InvoiceProducts that share the same InvoiceNumber but it
SET Invoice.Total = Sum(InvoiceProduct.SubTotal)
InvoiceNumber ItmeID Quantity Price SubTotal
10 1 2 $100 $200 <- this
update query works fine
11 2 5 $8 ...Query too Complex...
words I have seen way too much of today! And if it is not "too compex" then I
get a message saying "insufficient resources".
I have spent the day trying to break up boards into smaller sections and
trying to find other ways to get the same answer. Eventually I have to bring
the seperated boards back together again, so the end result is still the
same: Query is too complex
Does anyone have a suggestion that I could try to get around these
frustrating comments? Should I be using subqueries? - would that help
simplify things in the FROM clause?
Without seeing ...Need Query Help
I am new to Access. I built a query which gives me purchase orders and
payments on those purchase orders. However, the query dpes not give me
purchase orders with no payments. I need both: (1) purchase orders with
payments and (2) and purchase orders without payments. How do I go about
adjusting my query to include both?
In your query, select the line that joins your two tables and right-click.
That should bring up a context menu with a choice for Join Properties.
Select that, then select the option that will include ALL records from the
purchase order table ...Blank Userform
I have a slight problem, I have some code which adds rows with formfields in
to a table in a protected form. These formfields have text in which is
dependant upon users ticking checkboxes. Before adding the rows my code
checks to see if particular rows have already been added to the table so that
these rows are not added again.
The whole macro takes about 30 seconds to run and to save users seeing Word
'dance' and the screen flash, I have tried to utilise a userform to appear
for the duration of the code.
Unfortunately the body of the userform turns bla...Vlookup in a userform
If I enter a number into a userform in a box called 'reference' can I then
use a vlookup to fill in the next box 'name' from an external file?
I can use the vlookup on a sheet but am not sure of the syntax? within VBa.
With such a generic question a specific answer isn't possible. But in
general if you can write a formula in a cell that returns the result you
want, yes, you can do it from VB.
"R D S" <RDS@members.v21.co.uk> wrote in message
| If I enter a number into a...