MS Access Interactive Topic

Hi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :)

I'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

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

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

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

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

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,

{Too Long!}

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.,

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

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//.

Hey 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

(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.

{Too Long!}

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?

{Too Long!}

{Too Long!}

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

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

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.

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.

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

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

{Too Long!}