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
Popup Calender by Leo
I am trying to incorporate a pop up calender from Allen Browne. Downloaded the file (for Access 2000 and later) from the address below and unzipped it. ...
May 20th, 2010 03:06 AM
by HNIM2010 via AccessMonster.com Go to last post
4 223
Help with expression builder in a Query to retrieve wanted dates by Access Rookie[_3_]
I have 4 columns/fields of dates in a table: Field A, Field B, Field C & Field D. These fields can be either filled with a date or left blank. ABCD are all...
May 20th, 2010 02:30 AM
by John W. Vinson Go to last post
2 272
Can't see existing table in Design view for a QBE by DontKnow
Hi Guys, I can't see a table in QBE even when I have the scroll bar as far left as I possibly can. I have joineed another table to the query and I can see...
May 20th, 2010 12:03 AM
by DontKnow Go to last post
6 260
Mid string null value by Jim
I'm using the code below to display everthing after the pound sign (#) and it works for the most part, but displays the whole field for fields that don't...
May 19th, 2010 09:12 PM
by John Spencer Go to last post
4 267
Word merged with Access by MAD
I am using both Word and Access 2003. When I merge a Word Letter with Access, sometimes not all of the queries show up, in the drop down box, to link the...
May 19th, 2010 09:08 PM
by John Spencer Go to last post
3 204
insert into by seeker
I have an insert into query which is as follows; strgoaldescription = InputBox("Type new goal.") strservicetype = InputBox("This goal is for what...
May 19th, 2010 09:04 PM
by John Spencer Go to last post
3 204
in access, round up to nearest fraction(.5) by Stephengw
In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to...
May 19th, 2010 07:56 PM
by Daryl S[_2_] Go to last post
1 508
Access 2007 Append Query – Issue with automatically inserted brack by Brad
I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a “purchased system” table that has many field...
May 19th, 2010 07:39 PM
by Brad Go to last post
4 461
Query on SQL Server is fast, while Access is crawling by Mike G[raser]
I have a query that executes a Table-Valued Function in SQL server. If I execute it withing Query Analyzer in SQL server, it completes in 40 seconds. If I...
May 19th, 2010 07:04 PM
by AG[_3_] Go to last post
2 377
Concatenate Text Fields to Date Field by alhotch
I have three (3) columns in a table which represent the month, day, and year. The values in these columns are 04 (month) 21 (day) 2010 (year). I want to...
May 19th, 2010 06:43 PM
by alhotch Go to last post
5 411
SQL server backend by inungh
My mdb file is moving tables from mdb backend to ODBC link to SQL server tables, but queries are in the front end. Should I change the queries to stored...
May 19th, 2010 04:35 PM
by Jeff Boyce Go to last post
2 308
Help with expression builder in a select Query by Access Rookie[_2_]
I am a beginer of Access. I have a database that consists of 4 columns/fields of dates. These dates/fields can be filled or can be blank. I call them A,...
May 19th, 2010 04:08 PM
by Mackster66 Go to last post
2 243
UPDATE records by copying from same table? by Billp
Hi, I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they...
May 19th, 2010 03:53 PM
by Jerry Whittle Go to last post
1 354
How to retrieve dates that meets a criteria using Query? Exp Build by Access Rookie[_3_]
I have 4 columns/fields of dates in a table: Field A, Field B, Field C & Field D. These fields can be either filled with a date or left blank. ABCD are all...
May 19th, 2010 02:18 AM
by John W. Vinson Go to last post
1 280
Averaging Hourly Data by Jake D[_3_]
I have a lot of weather data for one month that is broken down by the minute. My end goal is to take the average hourly value of the column values (temp,...
May 18th, 2010 08:14 PM
by Jake D[_4_] Go to last post
2 268
Multiple table query displays only one record by Elaine_Moore
I have a table the has information about grant applications. I have another table that has the names and addresses of the schools related to the applications....
May 18th, 2010 07:28 PM
by Elaine_Moore via AccessMonster.com Go to last post
2 207
No data returned from query by gchichester
I can't seem to figure out why this query will not return any data. SELECT AsiaContracts.AsiaContractShipper,...
May 18th, 2010 06:42 PM
by KARL DEWEY Go to last post
1 231
Min/Max Dates and Group By by Andy
I have a small table of data: Start End Appointment...
May 18th, 2010 04:06 PM
by Andy Go to last post
2 259
Use Schedule Task to run Updates, but bypass User-Level Security by amanda_jb
I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can...
May 18th, 2010 03:51 PM
by amanda_jb Go to last post
0 200
How do I increase the size of my Query by Gary
The default number of columns on my Access database is 24. Can this be expanded to 40? Thanks
May 18th, 2010 03:20 PM
by ron11311 Go to last post
2 243
Post New Thread


Display Options
Showing threads 161 to 180 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 07:31 AM.


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