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
how to feed result from P_T query to combo box? by homer
I have this line of code working. Form2 Form_load currentdb.QueryDefs("qryPassthrough").SQL = "Exec INV_getParentItemBYID " & Me.OpenArgs I also have a combo...
September 13th, 2005 10:34 PM
by Ofer Go to last post
3 131
Criteria in Query by Gibson
I have a query (main query) whose data comes from one table and one query (data query). In the main query I have criteria such as Forms!frm1!Field1 so it only...
September 13th, 2005 10:31 PM
by KARL DEWEY Go to last post
1 145
can you specifie criteria for a parameter query in an Auto Num by Ofer
Try this WHERE .= Or WHERE .=cdbl() Or WHERE . Like cdbl() -- I hope that helped Good luck
September 13th, 2005 10:28 PM
by Lea Go to last post
1 363
Query Puzzle by Bradley
Hi I have 4 separate tables of which all have fields "Surname", "Forename" and "DOB", plus the data column. Tbl_0 = S | F | DOB (this is all 5 users) Tbl_1 =...
September 13th, 2005 09:48 PM
by Marshall Barton Go to last post
2 166
HELP With DATA and Make Table Query by Doc
Hi, SQL Srv2000 and Production Database - what I want to do is open the live database, keep the data and save it to be manipulated in a "non-connected" manner...
September 13th, 2005 09:27 PM
by Doc Go to last post
2 132
Expr1002 by aak
I have a query something like this. I want to order it by total. Everything else works OK only ordering doesn't work. It displays me window - 'Enter Parameter...
September 13th, 2005 09:20 PM
by Marshall Barton Go to last post
1 184
Create records using defaults by Alex
Each month I create a new table using the SQL below, where the records are just copied from the GoalsMain table, except that the NewDate changes each month. ...
September 13th, 2005 07:55 PM
by Lynn Trapp Go to last post
3 176
returning all records by Jason
Thank you to everyone out there who has tried to help me over the past few days. I am having a hard time getting my mind around this problem. The SQL at the...
September 13th, 2005 07:13 PM
by Jason via AccessMonster.com Go to last post
6 225
Computing Median by mcl
I need to compute the median not an average. Using help in Access 2000 it says there is a worksheet function "median". No there is not. It says undefined...
September 13th, 2005 07:08 PM
by MGFoster Go to last post
3 128
Why is access filling in fields in query results by Robbie via AccessMonster.com
I'm querying a table that has payments recorded in and the next payment due date recorded in . Only the most recent payment row has a due date recorded, is...
September 13th, 2005 06:37 PM
by Robbie via AccessMonster.com Go to last post
2 177
Subtract days from Left(Date(),5) by consjoe
I need a spreadsheet to generate 5 days before the anniversary date of when the contract was issued. Example I have an Issue_Date of 10/10/2002 and I want to...
September 13th, 2005 06:35 PM
by consjoe Go to last post
6 144
Form based on Query by RTimberlake
I have a form that is based on a Query. Since I have based the form on the query I can no longer enter information on my form. I am stumped. How can I base a...
(Multi-page thread 1 2)
September 13th, 2005 06:10 PM
by Rick Brandt Go to last post
10 274
too few parameters - Sub Query by Dianna
Hi, I am running a query which references a subquery. the criteria in the subquery is set to a value in the form (Forms!Results!cboSeason) I am receiving...
September 13th, 2005 06:01 PM
by Van T. Dinh Go to last post
4 155
Microsoft Access has encountered a problem by tCannon
When attempting to run a query, I keep getting the error message Microsoft Access has encountered a problem & needs to close. Sorry for the inconvenience" when...
September 13th, 2005 04:31 PM
by tCannon Go to last post
0 154
executeUpdate method does not load data by Naveen
Hello I am using the JDBC-ODBC bridge from Sun to load data into an Access database by calling on the executeUpdate method of the PreparedStatement object. I...
September 13th, 2005 03:49 PM
by Van T. Dinh Go to last post
1 93
Albert D. Kallal -WordMerge20 by Stephanie
Albert, Thanks for making your WordMerge20 sample db available- it's very slick! I have a question about chosing a query. All of the queries that I'd like...
(Multi-page thread 1 2)
September 13th, 2005 03:14 PM
by Stephanie Go to last post
11 243
Problems with Delete Query by MarkS
I am confused with the following Query. I would like to delete all records where the ITNO, PO, Line, and Vendor fields are the same in two tables. DELETE...
September 13th, 2005 02:57 PM
by [email protected] Go to last post
4 164
Queries with Expressions cause a Compile Error by Dr Rubick
I have a database with many tables and queries, which I have been developing for several months now. Today, all of the queries which contain at least...
September 13th, 2005 01:58 PM
by Dr Rubick Go to last post
2 235
DISTINCT vs GROUPBY ? by Stef
DISTINCT vs GROUPBY ? Hello all, I'm trying to figure out if there is any difference of performance using either GROUPBY or DISTINCT in the following...
September 13th, 2005 01:58 PM
by [email protected] Go to last post
5 180
Striping a common word from a field by JohnB
Hi. Im working on an A2000/XP mdb which has a field containing entries like "Maths Mentor", "English Mentor", "Music Mentor" etc. The second word is always...
September 13th, 2005 01:03 PM
by JohnB Go to last post
2 115
Post New Thread


Display Options
Showing threads 33281 to 33300 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 12:08 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.