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
No Windows Media in the SP2 verson of Internet Explorer! by Loved One
Has anyone noticed that in the Windows XP, PS2 version of Internet Explorer there is no Windows Media? In the PS1 version you could go to View/Explorer Bar...
August 29th, 2004 08:17 PM
by Spammastergrand Go to last post
1 303
Bump the key code up by `1 for new recs w/o using autonumber by cheswyck
BACKGROUND: I had a table with autonumber key. Then I had to export it an Excel format so others could make changes and deletions. When I tried to import the...
August 29th, 2004 10:19 PM
by tina Go to last post
1 110
Date Value: Week Begin by Bernie
I'd like to use an expression to identify the Week Beginning date (using Monday) of a given entered date value. Users can enter any day of the week, but I...
August 30th, 2004 12:58 AM
by Bernie Go to last post
2 303
IIf(IsError... by beppe005
I am trying to use the two functions IIf and IsError in a query in this way, which is wrong (since it doesn't work): Total: IIf(IsError(/;0;/) my intenttion...
August 30th, 2004 01:51 AM
by John Vinson Go to last post
4 85
MAX vs. LAST by Dave
Hi all, After creating a formula to extract the 6 right most characters from a 7 digit code and then returning the last one, I found that the results...
(Multi-page thread 1 2)
August 30th, 2004 02:39 AM
by Pike Go to last post
10 210
Find a word in comments field by David
I can create a query that finds a word in the "comments" field (200 char text field). I need the results to show the word searched for plus the next 7...
August 30th, 2004 10:24 AM
by Bonnie Go to last post
3 123
Function?!? by Dan
Hi: Store Date 1 01-Aug-04 1 03-Aug-04 2 04-Aug-04 2 05-Aug-04 3 06-Aug-04 **************** I have many stores thata should send data every day for
August 30th, 2004 11:23 AM
by Michel Walsh Go to last post
1 91
IIF formula by hermie
If have the next IIF formula =IIf(IsNull(),,IIf(IsNull(),,)) This formula works, it shows the fields porhora and mensual but not the field salario_otro? What...
August 30th, 2004 01:16 PM
by hermie Go to last post
6 132
MSAccess won't start by Keith Bryers
I can't get into my MS Access (1997), running on Windows 98, this error window opens:- MSACCESS caused an invalid page fault in module unknown at...
August 30th, 2004 02:28 PM
by Go to last post
1 139
Make Table query gets ODBC Error by Robin Hughes
Help! I am running an Access 2002 query to create a table from an ODBC file on a AS400. I am running under Windows 98. I can open the linked table without a...
August 30th, 2004 03:02 PM
by [MVP] S.Clark Go to last post
1 237
How do I show more than one contact type for a contact? by Erika
I am new to Access. I have downloaded the Contact Management template and am hoping to tweak it to meet my needs. The main problem I'm having seems like it...
August 30th, 2004 03:03 PM
by [MVP] S.Clark Go to last post
1 109
How do I show more than one contact type? by Erika
I am new to Access. I have downloaded the Contact Management template and am hoping to tweak it to meet my needs. The main problem I'm having seems like it...
August 30th, 2004 03:04 PM
by [MVP] S.Clark Go to last post
1 158
Joins Problem by esi
Running the following query and I'm not getting my desired result: SELECT tblPayroll2004.Period, tblDepartments., Sum(tblPayroll2004.Hrs) AS Total_OVTHrs,...
August 30th, 2004 03:07 PM
by [MVP] S.Clark Go to last post
1 193
Recordset not updatable by ExcessAccess97
I made a query for an end user. The query works, but when the user filters the list, it becomes un-updatable. Why does this happen how can I get around...
August 30th, 2004 03:07 PM
by [MVP] S.Clark Go to last post
1 175
Using date range in query criteria by Kathi
I have a form that gathers a date range that is then used in a Between statement in my query. But, I would like to include all records if the date is not...
August 30th, 2004 03:10 PM
by Kathi Go to last post
4 398
Delete/append queries in macro firing late by Kendra
Hello, I have a macro created from the combination of two action queries, a delete query and an append query. The delete query deletes a record if a certain...
August 30th, 2004 05:06 PM
by Kendra Go to last post
0 495
VBA HELP by JIMBO
What if I have more than one query, say for example: SqlStringA = Transform Query code SqlStringB = Select Query Code SqlStringC = Joins SqlStringA and...
August 30th, 2004 06:04 PM
by Michel Walsh Go to last post
1 89
Simple DMax lookup with "Like" filter by Stan S.
I need to find the record in tblResults (Access database) with the largest entry in the "SPECIMEN" column and I want to do it from VBscript only. I am after...
August 30th, 2004 06:09 PM
by Stan S. Go to last post
7 191
Big brain problem! by Jeff Klein
I have a table with check boxes for every day of the week. My query shows all dates (between MonthStartDate and MonthEndDate) if its respective checkbox is...
August 30th, 2004 08:33 PM
by Jeff Go to last post
2 146
Merging multiple rows into one with multiple columns by Zattack
I have two tables of data for example sake. One has addresses the other has names. Both have key fields that are used to join the data from the two tables. ...
August 30th, 2004 10:23 PM
by Van T. Dinh Go to last post
3 405
Post New Thread


Display Options
Showing threads 1961 to 1980 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 11:00 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.