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

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access Board   Print This     

MS Access Interactive Topic

Interactive Access (creating forms, reports, queries, etc.).
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

FranktheFrank
TimeStamp
Hi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :)
15 years ago
3 replies. Last post:

Sam.j
Which certainly make it among a best amusement resource. Mobdro Chromecast, media Players like Kodi. It undoubtedly.
11 days ago
Nothing New Since Your Last Visit
738
Hits

Thread 24 of 25
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!!
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.
9 months ago
Nothing New Since Your Last Visit
1949
Hits

Thread 23 of 25
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
13 years ago
1 Reply:

Anonymous
Excellent post --- Anonymous
50 months ago
Nothing New Since Your Last Visit
2304
Hits

Thread 22 of 25
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
15 years ago
2 replies. Last post:

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

Thread 21 of 25
Thread Starter  

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,
7 years ago
Nothing New Since Your Last Visit
1721
Hits

Thread 20 of 25
Thread Starter  

Wade.G
Query help
{Too Long!}
7 years ago
Nothing New Since Your Last Visit
2370
Hits

Thread 19 of 25
Thread Starter  

mrs179
Form with dependent combo boxes (beginner)
Hello- Very much a beginner at Access here.  I'm trying to create a form for data entry, and may have several questions, but let's start with this one: I am entering data related to employee attendance at professional development sessions.  There are six categories of sessions, and each category contains about 20-40 independent sessions. For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question  (sorted by data and course title) is selected.  Of course, I would rather not have the second combo box contain over 200 sessions.  The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second? Thanks in advance.,
9 years ago
1 Reply:

dmichael
{Too Long!}
7 years ago
Nothing New Since Your Last Visit
3392
Hits

Thread 18 of 25
Thread Starter  

lludlow
Secure Database
Can I set up a Secure Database where I have five users accessing a table. This table will have information about 12 divisions. Passwords are assigned to the five people whereby the password allows them to either edit or only view the data about the division., For example:, John can update info about division 1 and division 5 but he has only read-only rights to the rest of the divisions., , If anyone has any suggestions please help me., , Thanks
16 years ago
2 replies. Last post:

dmichael
{Too Long!}
7 years ago
Nothing New Since Your Last Visit
3380
Hits

Thread 17 of 25
Thread Starter  

stuwaddy
HOW DO YOU GET AN PRIMARY KEY ON A FORM TO FILL IN
ORDER_ID FIELD ON A FORM HAS TO BE FILLED IN BEFORE YOU CAN ENTER A SUBFORM OR LINKED FORM, I WANT THE ORDER_ID FIELD TO FILL IN AUTOMATICALLY WITH A AUTONUMBER (AS IT IS A PRIMARY KEY FIELD) WITHOUT YOU HAVING TO ENTER DETAILS IN ANOTHER FIELD AND WAITING FOR THE AUTONUMBER TO FILL IN,, , THANKS//.
16 years ago
1 Reply:

mprestwood
The answer to this old question is to use an Autoinc field. Restructure the table (select Design mode) and change the field to an Autoinc field. Alternatively, you could spin your own auto incrementing key fields with code.
7 years ago
Nothing New Since Your Last Visit
1647
Hits

Thread 16 of 25
Thread Starter  

Hockey25
MDE Files/Need Help with path problem
Hey everyone,, New hereBig Grin!, I will post elsewhere not sure if this is all IT or both IT and access, at my job IT manager moved all shared files to a different location example - instead of Ment01 he moved it to Ment04. While doing this there is a folder in there that has a large database and now I cannot log into it keeps giving me an error message saying the path is invalid or typo., , We tried copying it to desktop, and even shortcut does not work????, , When moving MDE files are you suppose to make a replica of the orig before moving it over or is this more an IT issue with permission and IP addresses?, I am the only one that has all requirements to modify, enter ect, everone else is read only, , Please if anyone out there let has any suggestions or ideas let me know, Thanks, Hockey
13 years ago
1 Reply:

mprestwood
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
2500
Hits

Thread 15 of 25
Thread Starter  

gsempcb
Populating ComboBox...
(Hi, I am using Microsoft Access 2003) Is it possible to populate a ComboBox with choices from more than one field? I've got a couple of different tables, both having a "Department" field. One table has some departments, and the other table (Linked SharePoint table) has some different departments. I've got a form with a ComboBox control where the user picks a department from the drop-down list, and right now it only pulls the departments from one of the tables (the non-SharePoint regular table). Is it possible I could give the ComboBox "Row Source" property to, in addition to pulling data from the one table, also adding the Department field from the SharePoint table, too? Just so it lists all departments from both tables. Any help is appreciated, thanks.
9 years ago
13 replies. Last post:

nashwannabe7
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
5773
Hits

Thread 14 of 25
Thread Starter  

gsempcb
Mathematical data in a report..
{Too Long!}
9 years ago
4 replies. Last post:

nashwannabe7
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
2458
Hits

Thread 13 of 25
Thread Starter  

craigh
upgrading Access97 DB to Access 2007.

I have a database that I wrote about 8 years ago in Access 97. I need to upgrade it to Access 2007. I know parts of the VBA code I wrote do not work. I need a frame of reference to begin to rewrite whatever parts of the code that are incompatible, but I don't even know where to begin. I assume some functions and stuff changed over 10 years.

What I was hoping was someone could give me a starting point - a resource of "how to upgrade" or "here's all the functions that changed", etc. Can someone get me started? TIA

9 years ago
Nothing New Since Your Last Visit
2274
Hits

Thread 12 of 25
Thread Starter  

gsempcb
Acess 2003 basic report question...
I am using Access 2003. Say you've got a report that draws some fields from a query, then spits out their values on a report. Now what if I wanted to set some sort of condition on one of the number data-type fields such that, "If is blank/zero, don't display other field."  In this report, say I want to set it up such that "If 'Hours Spent' is blank/zero, then don't display 'Project Description' (or make it blank--whatever)." And then, how would you do something like "If 'Hours Spent' is blank/zero, then don't show that particular record at all." ? Is this possible?
9 years ago
3 replies. Last post:

nashwannabe7
Ok, I was mistaken. I thought since I had not directly addressed this that it was not yet fixed. But it appears to be self-correcting--possibly as a result of what I did in correcting the other field--as I now cannot make a query that returns any blank numeric values at all in the report. So that's great. Thank you for replying.
9 years ago
Nothing New Since Your Last Visit
2566
Hits

Thread 11 of 25
Thread Starter  

gsempcb
Form questions...
{Too Long!}
9 years ago
3 replies. Last post:

nashwannabe7
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
2760
Hits

Thread 10 of 25
Thread Starter  

gsempcb
Stuck, in Access 2003...
{Too Long!}
9 years ago
3 replies. Last post:

nashwannabe7
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
3253
Hits

Thread 9 of 25
Thread Starter  

philmarcus
Secured database - make changes
Friends, here is the story: my client bought a commercial program from , a guy (sort of a program, it's written in macros), Access97. My client , wants to do enhancements, new reprots, etc. Thing is, the objects are , protected. (Not passworded data, and I have the .mdb, but design-, protected objects) I need to be able to circumvent that if I am to help , much. , , Oh, and the vendor has apparently been sent to a dilithium mine , somewhere off-planet. How do I figure out what user or usergroup has , design-change or design-read rights on the objects? Of course, without them I cannot simply import the objects into a blank database., , Phil
14 years ago
3 replies. Last post:

mprestwood
For those lurking, you might try the following software... Access Recovery Module - http://www.passwordservice.com/access/index.htm
9 years ago
Nothing New Since Your Last Visit
1815
Hits

Thread 8 of 25
Thread Starter  

Nate Chute
image best practice
For managing images in an access database, is it better to let the images reside outside of the database and reference them or load them into a table. Secondly, what file extension works best (gif, jpg etc) And lastly, can you imbed a windows explorer (XP) into a form where you can view images by the API get the file name (inventory number) and display the database information for that item. Nate Chute
14 years ago
1 Reply:

mprestwood
Store the image outside of your MDB Access database. Definately. There are many benefits to storing it outside of Access including the following:
  • More easily work with all the images at once.
  • avoid the overhead of an OLE server
  • decrease the size of your MDB file
  • easily reuse images with other development tools such as a website, VB, VS.Net, etc.
  • Metadata is preserved
  • 9 years ago
    Nothing New Since Your Last Visit
    2206
    Hits

    Thread 7 of 25
    Thread Starter  

    mvz
    Tabbing across fields in a form
    I have created a form with the fields in my table. The users needs a new field to be established. I entered it in my table and on my form. But the field is now the last field to be highlighted when tabbing through the form. I intially used the Tab Order feature to drag the field into the position I wanted it to be selected by the tabbing process. I also verified the Tab Index property was the correct number. The field is still highlighted as the last field in the form when tabbing., , I tried this in 2000 and in XP., , A simple example would be to layout field1, field2 and field3 on the form. Now position field3 between 1 and 2. No matter what I do, field 3 is always last when tabbing., , Thanks for the suggestions.
    16 years ago
    1 Reply:

    mprestwood
    What development environment? If Delphi, did you try the tab order property?
    10 years ago
    Nothing New Since Your Last Visit
    1893
    Hits

    Thread 6 of 25
    Thread Starter  

    S0nY
    New to Access, File Size Question.
    I am very new to MS Access i have a question. My.mdb file is 312MB, i am looking thru the mdb file at the tables and queries and what not that are in my mdb file, i am trying to figure out which tables in my mdb file are the largest.. I have found in the file menu Database properties and it tells me the total size of the mdb file, but is there a way i can see the file size of each table and wetc that are inside of my mdb file ? Thank for the help, David.
    10 years ago
    3 replies. Last post:

    S0nY
    Again Daniel, you once again helped me, thank alot ! hehe
    10 years ago
    Nothing New Since Your Last Visit
    3189
    Hits

    Thread 5 of 25
    Thread Starter  

    David H. Thornton Sr
    Dues
    I use access 2003 and I am trying keep track of my team dues and it is a weekly dues that is being paid. I want to add a command button that I can add the payment and store it in my table with the current date and payment so I can get a current dues paid every week, Thank you
    12 years ago
    1 Reply:

    mprestwood
    Just checking, did you complete this task?
    10 years ago
    Nothing New Since Your Last Visit
    1704
    Hits

    Thread 4 of 25
    Thread Starter  

    JBoeder
    How to add Pic at Input Scree
    Can someone share with me how to allow a user to add a picture (embedded) to a database at the Data input screen? It seems everytime I try it blows up the program or maybe my brain is not able to wrap itself around the process. Please help!!!
    11 years ago
    1 Reply:

    SANDMAN
    Hello: This URL to tutorials onMSAcess maybe of some help to you ? http://search.yahoo.com/search?ei=UTF-8&y=Search&fr=yfp-t-501&p=ms+access+tutorial&rs=5&fr2=rs-top
    10 years ago
    Nothing New Since Your Last Visit
    3256
    Hits

    Thread 3 of 25
    Thread Starter  

    lucasLondon
    Full Outer Join in Access
    {Too Long!}
    10 years ago
    1 Reply:

    Dan
    {Too Long!}
    10 years ago
    Nothing New Since Your Last Visit
    4597
    Hits

    Thread 2 of 25
    Thread Starter  

    kbeana
    macro won't run on another computer
    {Too Long!}
    11 years ago
    Nothing New Since Your Last Visit
    2206
    Hits

    Thread 1 of 25
    Thread Starter  

    salating
    Counting in Reports
    I am making a report that has to count different locations for each company I have in a table., , Each company has more than one POA with different locations. , , Example:, ABC Company has ABC Components with 34 locations and ABC Products with 50 locations., , I need it to read all those locations for ABC Company and display a total., , How would I count this in a report?
    12 years ago
    1 Reply:

    salating
    {Too Long!}
    12 years ago
    Nothing New Since Your Last Visit
    1754
    Hits

    New Thread
    -
       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!

    1,749 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