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
HELP!!! Validation rule by Chris
I have to introduce in a table some data, using a form with contrtols: combo boxes and text boxes. The fields need to follow some VALIDATION RULES, and to...
June 1st, 2004 01:11 PM
by bracke eric Go to last post
4 609
ADO Parameter Query by Tony_VBACoder
I have a bunch of Parameter Queries that I have been calling with VBA. But now I am converting my code to use ADO recordsets. How would I change my old code...
June 1st, 2004 01:50 PM
by Tony_VBACoder Go to last post
2 332
Queries don't work after conversion to MS Access 2000 by Nel Kes
Dear all, I have this problem with the queries that don't seem the work anymore. In the query I use selecion criteria in several fields (example Like !! )....
June 1st, 2004 01:55 PM
by Jeff Boyce Go to last post
1 545
Return Left Portion of a String by Bonnie
Returning the left portion of a string in a query. i.e. if the string is: " What combination of functions would return only "anybody" or...
June 1st, 2004 02:23 PM
by Newbie Go to last post
3 303
qry-SalesAnalysysCollectData? by Maureen
tblInventory + tblInvoiceDetail I would like to collect sales history for analysys. I'd like sales for various periods (based on tbleInvoiceDetail.date) for...
(Multi-page thread 1 2)
June 1st, 2004 02:40 PM
by Gary Walter Go to last post
10 811
Return most recent record [Repost] by Jordan
I have a table of payments made by clients. It includes the fields: PaymentID ClientID DateRec AmtRec I was trying to use the Last function on the Total row...
June 1st, 2004 03:27 PM
by Go to last post
2 558
How do I declare a variable as a Variant by Sandy C
I am running an append query and get this error: You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to...
June 1st, 2004 03:41 PM
by Sandy C Go to last post
5 810
Multiple instances of a report on the same page by Chris
My technical manager is asking me a tabelar report with header and footer. For every change of each one of 2 of the parameters from rhe header, he wants a new...
June 1st, 2004 04:20 PM
by Wayne Morgan Go to last post
5 673
Duplicated Query results by Alex
I have two tables; "Orders" & "Cancellations". The Orders table contains the following orders: part# loc 1 a 3 b 1 a 5 d The...
June 1st, 2004 04:40 PM
by Gerald Stanley Go to last post
1 550
SQL Intersect by Allan
I am going through a "teach yourself SQL in 21 days" and doing the examples in Access. They are using Personal Oracle in the book, so I am noting...
June 1st, 2004 05:08 PM
by Michel Walsh Go to last post
1 294
pivot tables by Stanley
I am using a privot chart where the underlying query groups by the week.The problem is the weeks are not sorted correctly (1, 10, 11,...2, 20, 21...). Any...
June 1st, 2004 06:05 PM
by Newbie Go to last post
1 400
Empty recordset query by time by larry cowan
I have a table where one field is date/time format. Only the time value has been entered. When I enter query criteria such as 9:01 PM Access 2000 converts the...
June 1st, 2004 06:50 PM
by Newbie Go to last post
1 405
dates problem by bogi
Hi, I have a table with records each with a certain dates, I would like to make a report that gives me dates that are one year ahead from the dates in the...
June 1st, 2004 06:53 PM
by bogi Go to last post
2 409
YearFrac by Grace
Excel has a function named YearFrac() which allows you to specify where a year calculation uses 365 or 360 days. I would like to use this in Access, however,...
June 1st, 2004 06:59 PM
by [MVP] S.Clark Go to last post
1 644
HELP with updateable query by Jacqueline
Using an Access 2000 mdb with linked SQL tables. I am opening a report (based on a query)...after the report closes I am running a simple macro to open...
June 1st, 2004 08:37 PM
by Steve Schapel Go to last post
3 349
a bit confusing by Andy Levy
Hi, apologies for the previous accidental post. I currently have a table with the following values ID Value GroupValue 1 ...
June 1st, 2004 10:55 PM
by John Vinson Go to last post
3 243
Concatenation by Andrea
I have a query that I am trying to concatenate more than 2 fields. This new field is set up as a parameter that asks the user for a value that equals the...
June 1st, 2004 11:33 PM
by Ted Allen Go to last post
1 287
Date Range in Multiple Queries by James Stephens
Here is the situation I am stuck in. I have 3 queries that pull data off of 3 seperate tables. I then combine them all into one. The problem is that there...
June 2nd, 2004 12:10 AM
by John Vinson Go to last post
1 651
error message "not enough space on temporary disk" by P Straube
Michael, Sorry to impose but I ran across the same problem and can't find anything in the MS KB. I'm running an update query in Access 2003 under Win XP Pro. ...
June 2nd, 2004 01:00 AM
by david epsom dot com dot au Go to last post
3 715
Subforms-Intriguing question by Chris
I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it...
June 2nd, 2004 03:18 AM
by Marshall Barton Go to last post
1 328
Post New Thread


Display Options
Showing threads 181 to 200 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 10:38 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.