MS Access Interactive Topic

Interactive Access (creating forms, reports, queries, etc.). |
|
|
Thread 25 of 25 | Thread Starter | | |  FranktheFrank | TimeStampHi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :) 6 replies. Last post: |  Jio.G | I agree with those special discussion. The self service portal of united states postal service department have the best result as the employees have got the best ever online presence and helped them a lot to improve their career.web posrtal at https://liteblueinfo.xyz/ have the best ever solution for them.
|
|
 1606 Hits | |
Thread 24 of 25 | Thread Starter | | |  modr0010 | Evaluation Data Entry FormI'm creating a database that will take in evaluations from our clients. I have a question table that holds information like the question ID, question text, category, and type (as in multiple choice, essay, boolean). I also have an answer table that holds all the answers and is sorted by an evaluation key which is unique for every evaluation, as well as by question ID. I am trying to create a form that automatically pulls the questions from the question table, and provides the right control to provide the correct type of answer for entering new evaluations into the db. If anyone has done this kind of project before, I would greatly appreciate any help., , Thank You |
 1180 Hits | |
Thread 23 of 25 | Thread Starter | | |  SteveL13 | How create help file?I've built an Access app. that will require a help file in the event the user needs guidance in filling out various forms. The information on how to do this is pretty sparce. Can anyone provide an easy step-by-step response on how to accomplish this?, , --Steve |
 2252 Hits | |
Thread 22 of 25 | Thread Starter | | |  chemistwendy | Trapping Access Error 3200I 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!! 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.
|
|
 2357 Hits | |
Thread 21 of 25 | Thread Starter | | |  KCRABBE | Long binary data in an ACCESS 2000 databaseI 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 1 Reply: |  Anonymous | Excellent post
---
Anonymous
|
|
 2638 Hits | |
Thread 20 of 25 | Thread Starter | | |  rdavidson | recover damaged file...MSysDbI 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 |
 3885 Hits | |
Thread 19 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,
|
 2032 Hits | |
Thread 18 of 25 | Thread Starter | | |  Wade.G | Query help{Too Long!} |
 2750 Hits | |
Thread 17 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.,
|
 4067 Hits | |
Thread 16 of 25 | Thread Starter | | |  lludlow | Secure DatabaseCan 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 2 replies. Last post: |  dmichael | {Too Long!} |
|
 3808 Hits | |
Thread 15 of 25 | Thread Starter | | |  stuwaddy | HOW DO YOU GET AN PRIMARY KEY ON A FORM TO FILL INORDER_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//. 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.
|
|
 1979 Hits | |
Thread 14 of 25 | Thread Starter | | |  Hockey25 | MDE Files/Need Help with path problemHey everyone,, New here  , 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
|
 2933 Hits | |
Thread 13 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.
|
 6474 Hits | |
Thread 12 of 25 | Thread Starter | | |  gsempcb | Mathematical data in a report..{Too Long!} |
 2848 Hits | |
Thread 11 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
|
 2478 Hits | |
Thread 10 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?
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.
|
|
 2911 Hits | |
Thread 9 of 25 | Thread Starter | | |  gsempcb | Form questions...{Too Long!} |
 3249 Hits | |
Thread 8 of 25 | Thread Starter | | |  gsempcb | Stuck, in Access 2003...{Too Long!} |
 3719 Hits | |
Thread 7 of 25 | Thread Starter | | |  philmarcus | Secured database - make changesFriends, 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 |
 2119 Hits | |
Thread 6 of 25 | Thread Starter | | |  Nate Chute | image best practiceFor 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 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 serverdecrease the size of your MDB fileeasily reuse images with other development tools such as a website, VB, VS.Net, etc.Metadata is preserved |
|
 2539 Hits | |
Thread 5 of 25 | Thread Starter | | |  mvz | Tabbing across fields in a formI 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. 1 Reply: |  mprestwood | What development environment? If Delphi, did you try the tab order property? |
|
 2247 Hits | |
Thread 4 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.
3 replies. Last post: |  S0nY | Again Daniel, you once again helped me, thank alot ! hehe |
|
 3563 Hits | |
Thread 3 of 25 | Thread Starter | | |  David H. Thornton Sr | DuesI 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 1 Reply: |  mprestwood | Just checking, did you complete this task?
|
|
 1990 Hits | |
Thread 2 of 25 | Thread Starter | | |  JBoeder | How to add Pic at Input ScreeCan 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!!! |
 3651 Hits | |
Thread 1 of 25 | Thread Starter | | |  lucasLondon | Full Outer Join in Access{Too Long!} 1 Reply: |  Dan | {Too Long!} |
|
 4990 Hits | |
 |
|
|