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 » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Reclac Conditional Formatting by CH
I have a template that uses conditional formatting to hide selection boxes based on certain selections that are made within the workbook (note: selection...
November 30th, 2009 09:36 PM
by Marshall Barton Go to last post
1 162
Update Kanji Char in SQL Database from Access returns question mar by sjalter
I'm trying to update a SQL database from ms access. There is a a lot of Japanese data in kanji. I've imported the data into Access from Excel and it looks...
November 30th, 2009 08:38 PM
by sjalter Go to last post
0 171
query by form problem by John Harrington
On my form I have a series of six unbound, unconnected check boxes labeled (for the purposes of this post) a, b, c, d, e, and f. When a is checked, I want my...
November 30th, 2009 08:28 PM
by John Harrington Go to last post
0 158
What is wrong with this SQL? by Joe M.
I am trying to delete all the data from 3 tables using this SQL in a query: DELETE WBS_List_PRPS.* FROM WBS_List_PRPS DELETE WBS_Dates_PRTE.* FROM...
November 30th, 2009 08:12 PM
by PieterLinden via AccessMonster.com Go to last post
2 236
Cumulative value by warrio
Cumulative values Is there a way to write a query that looks on values and return the cumulative sum for each month since a specified date? For...
November 30th, 2009 06:51 PM
by warrio Go to last post
0 153
Return all records many to many by Lorna_Jane[_2_]
Hello, I have several many to many relationships. Example: CatchmentTable: CatchmentID, WasteID, Area WasteSiteTable: WasteID, Location WasteLookup:...
November 30th, 2009 06:26 PM
by Jeff Boyce Go to last post
1 154
how to allow the user to enter their search criteria by No1momof3
HI I have wached the video showing me how the user of the DB can enter their own dates to perform a query but I need to know how the user of my database can...
November 30th, 2009 06:19 PM
by Bob Barrows Go to last post
2 182
Queries by Trace45
I have 4 tables that I have to develop queries for, can't seem to think what queries to build relationships between. any suggestions.Table Permits-PermitID,...
November 30th, 2009 01:32 PM
by bhicks11 via AccessMonster.com Go to last post
1 207
Append Invoice by Lez[_4_]
Hi Guys, I have an got an invoice application and want to be able to part dispatch items and append a letter to each invoice , so for each dispatch I...
(Multi-page thread 1 2 3)
November 30th, 2009 01:28 PM
by Lez[_7_] Go to last post
22 550
Query Based on Time Rane and Date Range by Little Penny[_3_]
How can I create a query that can searh for a time range Example between 6pm and 11pm base on a date ragnge example 6/1/09 - 9/1/09
November 30th, 2009 01:01 AM
by KenSheridan via AccessMonster.com Go to last post
7 338
Calculating a difference between an absolute value and a sum of va by newby
My query needs to show time remaining from "eligible time off" and accumulated time taken. However, rather than subtracting the total of time taken from the...
November 29th, 2009 06:33 PM
by Marshall Barton Go to last post
1 234
Run a Query using VBA without User Interface by Pasadena-D via AccessMonster.com
Hello, I have a VBA Macro that Opens an Append Query (see below), which works great, except for the end user has to answer the following MsAccess prompts: 1)...
November 29th, 2009 05:06 PM
by Pasadena-D via AccessMonster.com Go to last post
2 273
A dialog box pops up when I start my application by BobC[_6_]
I did not write the application (Access 2007), but am trying to modify it. I have a dialog box that pops up when the home form (page) of the application opens...
November 29th, 2009 04:37 PM
by KenSheridan via AccessMonster.com Go to last post
7 247
Expression for combining multiple children with one parent in a qu by john15243
Need query to create a form with parent name and multiple children listed in same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable:...
November 29th, 2009 03:33 AM
by Crystal (strive4peace)[_2_] Go to last post
4 210
Expression Exceeds 1024 character limit of design view, HELP!? by DawnTreader
Hello All i have a query that goes like this: SELECT dbo_CUSTOMER_ORDER.CUSTOMER_ID AS CustID, dbo_CUSTOMER.NAME, dbo_CUSTOMER_ORDER.ID,...
November 29th, 2009 01:37 AM
by Crystal (strive4peace)[_2_] Go to last post
1 221
Filter for Same Value in Two Fields by Dave
There are two fields in my query. "From" and "To". For sake of ease, let's say both these fields are US Cities. How can I pull all the records that show...
(Multi-page thread 1 2)
November 28th, 2009 10:33 PM
by KenSheridan via AccessMonster.com Go to last post
10 338
Using a field name as variable in a query by Titlepusher
I need to use a field name as a variable in a query. I have a table "Contractor List table" with forty-some Yes/No fields titled by County names. ...
November 28th, 2009 04:36 PM
by TedMi Go to last post
1 213
Linking Multiple Queries and a SharePoint List by GLT
Hi, I have an Access 2007 Database (MyDB) which connects to an enterprise database (EnDB) using an ODBC connection. MyDB extracts a list of servers from the...
November 28th, 2009 01:28 PM
by GLT Go to last post
0 198
Comparing columns in two otherwise identical Tables by PatK
I have created the following SQL query to attempt to find the differences between two identically structured tables. What I do each day is take a "snapshot"...
November 28th, 2009 01:55 AM
by PatK Go to last post
5 225
Query repeated values by Jose Lopes
Hello everyone. Sorry for such a newbie doubt, but since my Access and SQL experience is a bit “trial and error” I don’t even know what to search for...
November 27th, 2009 05:54 PM
by TedMi Go to last post
1 223
Post New Thread


Display Options
Showing threads 2141 to 2160 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:12 AM.


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