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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
error code "80070663" showed up how to fix? by Talkmrcool
Had update, clicked to do update & got this error code. What to do to correct ?
July 9th, 2009 12:56 AM
by Gina Whipp Go to last post
1 262
Automation to Excel - Setting "Interior.ColorIndex" by Bob Barnes
I'm running this code within Access, during automation to Excel... ..... objXLSheet.Range("ETwelve").Interior.ColorIndex = 38 ....but it does NOT retain that...
July 9th, 2009 12:38 AM
by Bob Barnes Go to last post
1 86
Update Query Questions by Chuck W[_2_]
Hi, I have a table called AHRQ with a date/time field called DISCHARGEDATE and a numeric field that is currently blank called DISCHARGEYEAR. The...
July 9th, 2009 12:27 AM
by Klatuu Go to last post
7 76
Simplified table creation by MaryJC
I have an Excel file with a long list of variable names I want to use to create a table in Access. Is there somewhere I can paste them into the table design...
July 8th, 2009 11:57 PM
by John W. Vinson Go to last post
2 70
Complete list of shortcut keys by JerseyShore
Hello, The list of shortcut keys in Access Help is broken up into a dozen or so categories on separate web pages. Do you know if there is one complete list...
July 8th, 2009 11:10 PM
by JerseyShore Go to last post
0 65
How to add captions to be seen on a photograph? by Rob K[_2_]
How can I adda caption to a picture so that it can be seen on the picture itself? I have Microsoft Office Picture Manager, Windows Photo Gallery, HP...
July 8th, 2009 11:09 PM
by John W. Vinson Go to last post
2 86
Require fields by Jessica
I have a field call p structure which is a dropdown and one call p revised date. When some one makes a selection on the p structure field i would like the p...
July 8th, 2009 11:02 PM
by John W. Vinson Go to last post
5 118
Help with Coding by DevilDog1978
Here is what I currently have: SELECT .icp, .sortord, .part_nbr, .cage, .mfr_desc, ., .item_nbr, IIf(IsError(CInt(!)),0,CInt(!)) AS qty, IIf(!=,"T","F") AS...
July 8th, 2009 10:26 PM
by John W. Vinson Go to last post
6 100
Securities by LG
I have tried many times to set up securities for my DB. All have been unsuccessful. Where would I find the step by step process to do this? Thank you
July 8th, 2009 10:22 PM
by John W. Vinson Go to last post
1 106
Hyperlink Field Problems by nettiem
We recently changed the email address fields in our Access 2007 databases from text to hyperlink. We like the option of clicking directly on the fields to...
July 8th, 2009 10:04 PM
by nettiem Go to last post
2 84
sum time duration by Frances
I am making a database of musical compositions each with several tracks lasting just a few minutes and seconds . I want to be able to sum the duration of...
July 8th, 2009 10:00 PM
by Frances Go to last post
3 98
Errors: There isn't enough memory to update display. MS Access 20 by Stephen
Memory exhausts while computer and Access are sitting idle. Access 2007 database is linked to SQL Server tables. Returning to computer, error message...
July 8th, 2009 09:24 PM
by Stephen Go to last post
0 94
VBA code for table deletion by Smigidy
I have the following code to delete all table data except for what is in the Switchboard Items table, but there's a compile error. Any suggestions? Public...
July 8th, 2009 08:34 PM
by Douglas J. Steele[_3_] Go to last post
6 90
email report from access by prothery
I would like to be able to attach an access report to an email as automatically as possible. Any help really appreciated - even if it is give it up and use...
July 8th, 2009 08:24 PM
by Arvin Meyer MVP Go to last post
1 77
Averages by LG
I have a TAT column built with formula of TAT: Sum((QL_Production!Completed_Date-QL_Production!Received_Date)) How would I get an average of the that field to...
July 8th, 2009 08:12 PM
by LG Go to last post
7 93
Cancelling out of parameter dialog box by Sue
I have a dialog box for entering three parameters for a parameter query which is working fine. When the user hits the cancel button without entering any...
July 8th, 2009 07:45 PM
by Sue Go to last post
0 84
Black box for access app by John
Hi Is it possible to record all actions that are taken on access data? So for instance if a record is deleted to know who deleted it and...
July 8th, 2009 07:35 PM
by Jerry Whittle Go to last post
2 71
Keeping autonumbering after going to SQL backend by jmillerWV
I am in the middle of moving an Access2k3 Database to SQL. I have run into a problem I need help with. My main table "OP" in Access uses they autonumbering...
July 8th, 2009 07:34 PM
by jmillerWV Go to last post
6 79
conversion to Access 2003 giving errors by bubu
I have converted from Access97 to Access2003 for a client (they decided not to go 2007). When I run a specific report for them it gives the "Expression is...
July 8th, 2009 07:21 PM
by Jerry Whittle Go to last post
1 71
Controlling which app opens a hyperlink image file? by SharoneM
I have a designated folder which stores my jpeg image files to be hyperlinked to an Access 2007 database table. When I click on the images in that folder,...
July 8th, 2009 07:13 PM
by Clifford Bass[_2_] Go to last post
6 99
Post New Thread

Display Options
Showing threads 9981 to 10000 of 92189
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:08 PM.

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