A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.07 seconds.
Search: Posts made by: Ken Snell
Forum: Running & Setting Up Queries June 5th, 2010, 04:50 AM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,708
Posted By Ken Snell
Forcing an ambiguous outer join

OK your query structure essentially is this:

tblCostCode --- tblTransData --- tblCostCat

This structure is unusual because the table of greatest interest (as noted
by your query's output...
Forum: Running & Setting Up Queries June 4th, 2010, 08:24 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 2,094
Posted By Ken Snell
How to calculate days due?

What does "6/1" mean with respect to terms? I have no idea how to interpret
what that means with respect to your post. Help us understand how it's to be
interpreted.

--

Ken...
Forum: Running & Setting Up Queries June 4th, 2010, 08:23 PM Posted to microsoft.public.access.queries
Replies: 7
Views: 3,708
Posted By Ken Snell
Forcing an ambiguous outer join

How about if you post the original query's SQL where you got the error
message about ambigous joins? Let's see if we can debug that query before we
come to any conclusions about whether you need to...
Forum: Using Forms June 4th, 2010, 08:15 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,545
Posted By Ken Snell
this code doesn't work fully

Open CurrentProject.Path & "\Accounts\Users\" + username + ".txt" For
Output As #1
--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Bob H" wrote in message...
Forum: Running & Setting Up Queries May 13th, 2010, 12:03 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 243
Posted By Ken Snell
FROM and JOIN Problems

You're using the same tblContacts table twice in your join, which I don't
think you want to do. From the ON clause, it appears that you want the
tblFault table to be used too:

SELECT...
Forum: General Discussion May 13th, 2010, 03:45 AM Posted to microsoft.public.access
Replies: 5
Views: 116
Posted By Ken Snell
HELP A NEWBIE - EXCEL TO ACCESS

You'll find various code examples for importing data from EXCEL into ACCESS
here, including importing multiple workbooks / worksheets:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
--

...
Forum: Running & Setting Up Queries May 13th, 2010, 03:29 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 264
Posted By Ken Snell
Is there anything wrong with the syntax

SELECT [GL Finance Credit Query].* FROM [GL Finance Credit Query]
UNION ALL SELECT [GL Finance Debit Query].* FROM [GL Finance Debit
Query];


You must delimit the query names with square...
Forum: Running & Setting Up Queries May 12th, 2010, 03:30 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 275
Posted By Ken Snell
Select stmt using Like

Yes, thanks for the catch, Karl.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"KARL DEWEY" wrote in message...
Forum: Running & Setting Up Queries May 11th, 2010, 03:46 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 275
Posted By Ken Snell
Select stmt using Like

You can use a non-equi-join query (though it'll be slow with large amounts
of data):

Select *
From Issues INNER JOIN Contacts
ON Issues.Owner LIKE "*[Contacts.lastname]*";

--

Ken Snell
Forum: Database Design May 10th, 2010, 12:07 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 358
Posted By Ken Snell
Text wrap in column headings

You cannot wrap the text in a table's datasheet view's column (field)
headings. You must use a form with textboxes, where you put the name of the
field in the textbox, to do that.

To "wrap" a...
Forum: General Discussion May 8th, 2010, 06:00 PM Posted to microsoft.public.access
Replies: 2
Views: 120
Posted By Ken Snell
Count Results

Try this:

=Abs(Sum([activesuggestion]))

--

Ken Snell
http://www.accessmvp.com/KDSnell/
Forum: General Discussion May 7th, 2010, 05:02 PM Posted to microsoft.public.access
Replies: 4
Views: 156
Posted By Ken Snell
Exporting Query from Access 2007 to Excel 2007

See this article -- it may give you some insights on what is happening and
what you need to do to make it work the way you want:

Using the Range Argument of TransferSpreadsheet when Exporting Data...
Forum: Running & Setting Up Queries April 22nd, 2010, 04:13 AM Posted to microsoft.public.access.queries
Replies: 10
Views: 333
Posted By Ken Snell
Extracting the numbers from the Text Field

Also, IsNumeric will allow decimal points, etc. to remain as characters in
the string as well, so it sometimes is not a good choice when wanting just
numbers to remain.
--

Ken...
Forum: General Discussion April 20th, 2010, 03:38 AM Posted to microsoft.public.access
Replies: 7
Views: 192
Posted By Ken Snell
Data Type Issue in Linked Excel Table

You're welcome.
--

Ken Snell
http://www.accessmvp.com/KDSnell/


"MacNut2004" wrote in message...
Forum: Using Forms April 17th, 2010, 05:10 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 161
Posted By Ken Snell
access 2003 no query results for a form

In the form's Load event procedure, you can use this code to pop up a
message box:

Private Sub Form_Load()
If Me.Recordset.RecordCount = 0 Then _
MsgBox("No Records!")
End Sub
--

Ken...
Forum: Running & Setting Up Queries April 17th, 2010, 05:00 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 82
Posted By Ken Snell
How do I combine text fields in Access

You can use a function that will combine the values from the different
fields, using the date field to be the "key" that links the records
together; you then incorporate the function in your query...
Forum: General Discussion April 17th, 2010, 02:27 AM Posted to microsoft.public.access
Replies: 7
Views: 192
Posted By Ken Snell
Data Type Issue in Linked Excel Table

Importing is the answer. See my website for various ways to automate the
process, which would make it easier.

http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

--

Ken...
Forum: Running & Setting Up Queries April 11th, 2010, 11:01 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 131
Posted By Ken Snell
Parameter prompt when form is open

Is the query being used as the RecordSource for a subform on the Main form?
Or as the RecordSource for the Main form?

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Cadburys"...
Forum: Running & Setting Up Queries April 11th, 2010, 01:07 PM Posted to microsoft.public.access.queries
Replies: 1
Views: 98
Posted By Ken Snell
Parameters query

What you want to do is not what I would consider good database design. Just
make two separate queries, one for each form.

(To do what you want, you'd need to write a VBA function that tests to see...
Forum: Using Forms April 4th, 2010, 01:58 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 68
Posted By Ken Snell
Combo Box that fills Text Box in form

Assuming you want to have the combo box display the second column, not the
first, change the ColumnWidths property to something like this:

0";1";0"


--

Ken...
Forum: General Discussion March 26th, 2010, 04:16 AM Posted to microsoft.public.access
Replies: 6
Views: 152
Posted By Ken Snell
Why can't a primary key be duplicated?

Because a primary key, by definition, identifies a unique record within a
table. If it can be duplicated, then you don't have uniquely identifiable
records in your table.
--

Ken...
Forum: Database Design March 17th, 2010, 03:54 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 3
Views: 522
Posted By Ken Snell
Field Validation Rule to Exclude Ampersand

Try

Not Like "*&*"

--

Ken Snell
http://www.accessmvp.com/KDSnell/
Forum: Setting Up & Running Reports March 17th, 2010, 02:33 AM Posted to microsoft.public.access.reports
Replies: 4
Views: 171
Posted By Ken Snell
Wrong amount of arguments!

You're welcome. Glad you were able to "fix" those last few items!
--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Bob Vance" wrote in message...
Forum: Running & Setting Up Queries March 16th, 2010, 03:52 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 223
Posted By Ken Snell
Query not showing certain records

I cannot imagine how the query would have worked previously if the same data
condition existed then as now.

However, you can make the query operational if you use this SQL statement
(using LEFT...
Forum: Running & Setting Up Queries March 15th, 2010, 04:12 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 223
Posted By Ken Snell
Query not showing certain records

I'm not sure you answered my question?

For your query to work, each record in Customer table must have at least one
record in each of these tables:
Customer_Contacts
Order

And each...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.