I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE
   ► MB LobbyAll Groups   Print This    All Groups  

Access Coding Message Board

Microsoft Access Q&A

Access Coding Message Board (Q&A). Free help! Answer questions. Part of our Access Group. Microsoft Access database system for Windows. Covering all versions of MS Access.

To start a new thread, choose a topic, then click [New Thread].

Access Specific Topics

TopicThreadsPostsLast Active Thread 
MS Access Interactive100222
mahi77.m
RE: Trapping Access Error 3200
good and also select it from the listing of tools shown at the top, in Xcode. Kodi Chromecast   an "Organisation Identifier". For this guide nice.
5 months ago
Nothing New Since Your Last Visit
Access VBA Programming100227
Jay.M
calc count all
Check the field you want to count and enter "calc count all"
5 days ago
Nothing New Since Your Last Visit
Access News / Other4595?No Subject!
--
Nothing New Since Your Last Visit

Newest Posts...

New Posts: Access Board

More...

Thread 10 of 10
Thread Starter  

kirsten
query count
i need to total the amount of duplicate records in my database. I know this should be easy but i can't figure it out!
Posted to MB Topic: Access VBA Programming
16 years ago
2 replies. Last post:

Jay.M
Check the field you want to count and enter "calc count all"
5 days ago
Nothing New Since Your Last Visit
422
Hits

Thread 9 of 10
Thread Starter  

chemistwendy
Trapping Access Error 3200
I have another post that is related to this one. In my claim form, if I change the key and then tab until I would normally go to the next record, I get error 3200. What I would like to do is trap it. So, I tried putting in the OnCurrent event this code, , on Error Goto err_try, err_try:, if err.number=3200 then, msgbox "blah blah blah", sendkeys "{esc}" to put form back the way it was, end if, , However, I continue to get error 3200 instead of my message box. Have i tried the wrong event? I also tried before and after update and lostfocus. Help!!
Posted to MB Topic: MS Access Interactive
16 years ago
1 Reply:

mahi77.m
good and also select it from the listing of tools shown at the top, in Xcode. Kodi Chromecast   an "Organisation Identifier". For this guide nice.
5 months ago
Nothing New Since Your Last Visit
1837
Hits

Thread 8 of 10
Thread Starter  

Craig Goodman
Combo Box won't update with specified value
As this is my first post to this board, I will try not to complicate this with unnecessary information. I am trying to set a combo box to a specific value (the name of a loan) using VBA for when the form opens. The combo box is populated with Loan Names from an Access table. Currently, I am using the following code to set the list index property (I have used this with excel vba before and it worked):   Combo_LoanName.ListIndex = 3  The problem is that when the form opens the combo box list is populated but no item is selected. I have tried other variations of the code above but to no avail. Can anyone spot what I may be missing?   Thanks, Craig
Posted to MB Topic: Access VBA Programming
10 years ago
Nothing New Since Your Last Visit
3620
Hits

Thread 7 of 10
Thread Starter  

t
Missing Page Header in Subreports
Hey:, , I have a master report that contains independent subreports (that have no data relationship to the master report - the master report serves as a 'shell'). , , My problem is when the master report is previewed or printed, the page headers in the subreports do not appear. I'm baffled because while in design view, when I select the properties for a subreport's pageheader, the visible property is 'true', yet it does not show., , Anybody have this happen or know how to force the pageheader within a subreport to show?, , (How do I reference a subreport pageheader in using VBA from the master report code?), , Thanks!
Posted to MB Topic: Access VBA Programming
15 years ago
Nothing New Since Your Last Visit
1075
Hits

Thread 6 of 10
Thread Starter  

ScottCybak
Sparatic Query Behaviour
{Too Long!}
Posted to MB Topic: Access VBA Programming
16 years ago
Nothing New Since Your Last Visit
872
Hits

Thread 5 of 10
Thread Starter  

Rainier
Schedule database
{Too Long!}
Posted to MB Topic: Access News / Other
15 years ago
Nothing New Since Your Last Visit
2030
Hits

Thread 4 of 10
Thread Starter  

KCRABBE
Long binary data in an ACCESS 2000 database
I have been given an ACCESS 2000 database. I also have a copy of ACCESS 2003., , One field contains Long Binary Data., , Is there a simple (and I mean really simple) way to get access to this field? Is there a third party software that would give me access?, , I have tried a variety of strategies but they are beyond my technical skills (i.e. the programming is pages long)., , Thanks for any help. KC
Posted to MB Topic: MS Access Interactive
13 years ago
1 Reply:

Anonymous
Excellent post --- Anonymous
46 months ago
Nothing New Since Your Last Visit
2238
Hits

Thread 3 of 10
Thread Starter  

Martin Gomez
Disable Print Screen Key
How to disable the Print Screen key in Microsoft Access
Posted to MB Topic: Access VBA Programming
16 years ago
1 Reply:

Anonymous
Plese revive this valuable thread--- Prilette
53 months ago
Nothing New Since Your Last Visit
2578
Hits

Thread 2 of 10
Thread Starter  

rdavidson
recover damaged file...MSysDb
I was working with my main .mdb file, and as luck would have it, Access up and crashed. This does happen every so often, as is true with most software including Microsoft products, but this was a very bad loss., , Upon trying to reopen the file and recover what I have since my last save, I get the following error message:, , The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name and the path name correctly., , There was no object named MSysDb in my system, so I am assuming it is an Access feature. Other backups I have work just fine...only the file which crashed gives me this error., , It is possible to spend a day recovering lost work, but if there is anyway I could recover my lost file and sidestep this error message, I would be very appreciative., , ``allen
Posted to MB Topic: MS Access Interactive
15 years ago
2 replies. Last post:

Anonymous
--- sajo
5 years ago
Nothing New Since Your Last Visit
3426
Hits

Thread 1 of 10
Thread Starter  

jseidel
Reading Paradox tables from Access 2007
I have an Access application that imports data from Paradox tables in an existing, external application (Timeslips by Sage). App was originally written in Access 2003 and I was able to link to several Paradox tables and read them successfully (no update is required). We upgraded to Access 2007 and the existing Paradox links work just fine but I have been unable to create new read-only links to more of the Timeslips' Paradox tables. The new Import wizard assumes a read-write link and then fails with the error:      "Unexpected error from external database driver (11010)." Development is on a Windows7 64-bit machine and deployed to a WindowsXP machine (soon to be upgraded to Windows7). I've tried linking on both machines and NoGo. I've also tried searching the web for code that could handle this but to no avail. Any suggestions as to how I can accomplish this?  Thanks very much.,
Posted to MB Topic: Access VBA Programming
6 years ago
Nothing New Since Your Last Visit
2202
Hits
More...

Unanswered: Access Message Board

Answer an unanswered thread. Even old threads. Our goal is to have a complete and thorough resource.


Thread 4 of 4

jseidel
Reading Paradox tables from Access 2007
I have an Access application that imports data from Paradox tables in an existing, external application (Timeslips by Sage). App was originally written in Access 2003 and I was able to link to several Paradox tables and read them successfully (no update is required). We upgraded to Access 2007 and the existing Paradox links work just fine but I have been unable to create new read-only links to more of the Timeslips' Paradox tables. The new Import wizard assumes a read-write link and then fails with the error:      "Unexpected error from external database driver (11010)." Development is on a Windows7 64-bit machine and deployed to a WindowsXP machine (soon to be upgraded to Windows7). I've tried linking on both machines and NoGo. I've also tried searching the web for code that could handle this but to no avail. Any suggestions as to how I can accomplish this?  Thanks very much.,
Posted to MB Topic: Access VBA Programming
6 years ago
Nothing New Since Your Last Visit
2202
Hits

Thread 3 of 4

Wade.G
Query help (again)
I have 2 tables, one (tblLOCProfile) is a list of locations, start day, and end day (LOCATION, StartDay, EndDay).  The other table (tblDailyData) consists of a list of locations and a temperature reading for each day of the year (LOCATION, DayofYear, TEMPERATURE). What I want to do is get an average of TEMPERATURE for each location based of the Day of Year range (StartDay, EndDay) from the first table.  THe kicker is the StartDay and EndDay may be different for each location. Any ideas of how to go about constructing such a query? Thanks,
Posted to MB Topic: MS Access Interactive
7 years ago
Nothing New Since Your Last Visit
1645
Hits

Thread 2 of 4

Wade.G
Query help
{Too Long!}
Posted to MB Topic: MS Access Interactive
7 years ago
Nothing New Since Your Last Visit
2311
Hits

Thread 1 of 4

hassan_sani
Starting MS Access
Is it posible to start Access without the access startup showing? how can this be accomplished.
Posted to MB Topic: Access VBA Programming
9 years ago
Nothing New Since Your Last Visit
2590
Hits
More...

Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).



-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,077 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2017 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech