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
Filter by form by Darren Melbourne
From Table view, when I filter by form the drop down boxes in each field returns Null, is not Null rather than my data options. Actually I have no Null data...
May 19th, 2007 07:28 PM
by Maurice Go to last post
1 73
Complex Query by khashid via AccessMonster.com
Hi, I need a help with my query. I have a form with 6 combo boxes, and a query in subform. Subform query is updated based on the combobox selection, user has...
May 19th, 2007 07:24 PM
by themausman via AccessMonster.com Go to last post
2 113
One-to-Many link shows duplicate records in query. by Scott A
I've got a query that uses form parameters to display a list of records. Worked great until the client requested that we reference data on the many side of a...
May 19th, 2007 06:51 PM
by Amy Blankenship Go to last post
7 103
decode by Joshua6007
Is there a function in Access that I can use in my queries to map values to other values. (Oracle's decode) In other words, if I have a table with payment...
May 19th, 2007 05:55 PM
by John W. Vinson Go to last post
6 102
Immediate IIF() problem by Marc Miller
I have a string field with 'numeric' values (abbas) and another string field (abbas_sign) that contains the indicator for the value's sign. It contains a 'D'...
May 19th, 2007 03:33 PM
by Douglas J. Steele Go to last post
1 188
String to number by Jeff Klein
I have created a column in my query that extracts a number from another field that is a string. I need to convert my new field to be a number so I can sort...
May 19th, 2007 09:39 AM
by Maurice Go to last post
3 93
query doesn't return new records by MorningStarFan
I have created some vba code that inserts new records into my db. However, even though a record exists in all tables for the new id and all other criteria...
May 19th, 2007 02:30 AM
by Jerry Whittle Go to last post
3 83
Access 2003 simple question by Ron Geilow
I am just getting started with Access and have a simple question. I have a basic table with part information in it. I would like to have a small window open...
May 19th, 2007 01:07 AM
by John W. Vinson Go to last post
2 121
Data LookUp Query by Steve
Trying to lookup a value in a table which is dependent on 4 fields in a second table. Suggestions on how to accomplish?
May 19th, 2007 12:22 AM
by Amy Blankenship Go to last post
4 88
Query with three tables by joey
I posted earlier and was able to pull a query using Unrelated Records but now I need further assistance. I have three tables: One has 15,000 records of...
May 19th, 2007 12:04 AM
by John W. Vinson Go to last post
3 103
Anyone know of a good/quick (and free) way to compress HTML code? by ship
Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000) Hi Anyone know of a good/quick (and free) way to compress HTML code? We are trying to use...
(Multi-page thread 1 2 3)
May 18th, 2007 10:25 PM
by Jerry Stuckle Go to last post
25 446
Running a Query Date by Kat
There is a field in a table that give a date time stamp. I want to be able to do a query on just the date part of the field. Is there a way to extract just...
May 18th, 2007 08:28 PM
by Dale Fye Go to last post
4 104
PARAMETERS statment in the query by elena
Hi, All I have a question, How can i specify the size of the dialog box with "Enter Parameter Value" it has two buttons "OK" and "CANCEL"? Is it possible to...
May 18th, 2007 06:49 PM
by elena Go to last post
4 117
Mid in query by DrEvil
Hi guys, I feel like I'm posting something every day here.. In any case here is my problem; I'm importing table from Excel into Access and that works fine but...
May 18th, 2007 06:26 PM
by DrEvil Go to last post
5 111
eliminate duplicates by holly
I have a table with 7 columns of team member names. I need a count of all team members, but need to eliminate duplicate names. How do I query seven...
May 18th, 2007 05:41 PM
by John W. Vinson Go to last post
2 123
How to write an access querry to select 12 most digits in a field by SB
How to write an access querry to select 12 most digits in a field
May 18th, 2007 05:30 PM
by KARL DEWEY Go to last post
1 81
Summing values where one is #Error doesn't work by will
I have a raw_data table (originating from an external source and pasted regularly into Access). I have a normalised_query query based on raw_data and doing...
May 18th, 2007 04:19 PM
by Dale Fye Go to last post
3 61
RE : Access 2003 : Numbering alarms by PermitNo so that after 365 days of the last number 1, the count returns to 1 by Céline Brien
Hi everybody ! In February I had an answer to this question. See the codes below : UpdateNoAlarmeIncendie and GetNoAlarmeIncendie. Maybe I am not in the right...
May 18th, 2007 03:15 PM
by Céline Brien Go to last post
0 88
Cartesian Help Please by Gaetanm via AccessMonster.com
I have two queries built into one. From my the other from my . This data base I have inherited. The which I created dervies work time from date diff....
May 18th, 2007 02:33 PM
by Gaetanm via AccessMonster.com Go to last post
5 148
Can you combine multiple functions into one with Access 2002 connected SQLServer by Mitchell_Collen
Can you combine multiple functions into one with Access 2002 connected to SQL Server? If so, how? Please let me know if this is the wrong group for this type...
May 18th, 2007 02:22 PM
by Mitchell_Collen via AccessMonster.com Go to last post
1 76
Post New Thread


Display Options
Showing threads 18001 to 18020 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 03:12 PM.


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