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
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 145
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 137
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 119
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 112
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 168
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 164
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 156
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 158
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 142
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 159
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 152
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 145
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 155
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 149
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 126
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 114
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 131
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 121
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 147
Better way to utilize my form by mlieberstein
I have a user go into a Form which allows the user to select a BusinessGroup with a combo box. Then the user has a command button on the form which launches...
July 8th, 2009 07:06 PM
by mlieberstein Go to last post
7 579
Post New Thread


Display Options
Showing threads 9981 to 10000 of 92186
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 02:15 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.