Microsoft Access New Activity

How to disable the Print Screen key in Microsoft Access

Posted to MB Topic: Access VBA Programming

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

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

I have an mdb file that appears to have some corruption.  I have run the "compact and repair database" utility several times.  This utility runs without reporting any problems.  However, there are about 5 forms of about 60 in the mdb file that, when modified cause MSAccess to crash.  I have also tried to start with a blank mdb file and cutting and pasting every form, table, query, report, from the old file to the new file and the same problem occurrs with the same forms.I am desperately hoping for some advice from somebody to hopefully help me save all the code that I have done and not have to build it again to get rid of the problems (it would really be a pain). Thanks in advance.

Posted to MB Topic: Access VBA Programming

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

Hope this is the right section to post this in.   I'm a bit stumped on how to create a query that will give me the average of a column for a specified range of years by location and the data by location for the current (or other) specified year., , My table (Weather) looks something like this:, , , Location, Year, Temperature, , MS, 2007, " " , IA, 2007, 86, TN, 2007, 92, MS, 2008, 96, IA, 2008, 89, TN, 2008, 93, MS, 2009, 94, IA, 2009, -999, TN, 2009, -999 , , , I have a buddy that gave me the SQL for the Average part:, , "avg(case when TEMPERATURE != -999 then TEMPERATURE else null end) TEMP_AVG,", , What I'm wanting to do is convert this to work in Access and specify the years I want to average (YEAR >=2007 AND YEAR <=2008).  My dataset will include temperature data for the past 50 years, but I want to average the temperature for a specified 10 period and return the temerature for a specific year.  I have form that will ask for a year.  Code behind f...

Posted to MB Topic: MS Access Interactive

I have an Access form set to continuous forms. I have an unbound text box on the detail row. When I set the text box to a value for that row, it is updated for all rows. Is there a way to change the value of a text box on only one specific row?

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: MS Access Interactive

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

Posted to MB Topic: MS Access Interactive

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

Posted to MB Topic: MS Access Interactive

I am in the process of switching to Access 2002, I cannot for the life of me find out how to get Access to automatically fill in other fields when key field is entered into "many side" table. Paradox did this so easily by checking the "Applicable fields" in table lookup, but find no such command in Access, any help appreciated, Thanks.

Posted to MB Topic: Access VBA Programming

Hi,, , I am fairly new to Access programming. My background is in Paradox. I have to write an application however in Access that is going to be multi-user. I have already learned that I need to split the database., , My question is this: In Paradox we define 'aliases' to reference table paths so that I don't need to know in advance where the tables will reside as long as I set the alias for those tables on startup to poin to their location., , How do I do that in Access? Since I may not know a drive letter or even and UNC path when I begin - how do I reference the tables?, , Any help appreciated., , Jon

Posted to MB Topic: Access VBA Programming

I have a form which is bound to a table. On this form I have a calculated field. The calculation is the sum of two other field values. How can I get the value of the calculated field to write to a specific field in the table?

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: MS Access Interactive

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

Posted to MB Topic: MS Access Interactive

Is it posible to start Access without the access startup showing? how can this be accomplished.

Posted to MB Topic: Access VBA Programming

Hello, I'm using Access 2003, and I have a few questions on a specific report I'm working on, but the first question isn't specific to the report I'm working on--it's a broad question about reports in general., , (1. Again, I'm working on a report that someone else built in the past. Therefore, I wanted to know what's a good way to see the queries/ or tables (the sources of data) at a glance from report Design view? What's a good way to see where everything comes from that Access pulls from in order to generate the report? Is "Object Dependencies" the best bet, or is there anything else?), , 2. This report pulls from 2 tables and a query. With the report I'm working on, the report accumulates all of the hours spent on all projects in a given time period worked on, groups by a specific employee, and throws out a total of all hours the given employee spent on all jobs at the bottom section of the report. In the report's current state, each project is assigned and identified by an ...

Posted to MB Topic: MS Access Interactive

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?

Posted to MB Topic: MS Access Interactive

(Keep in mind my questions come from someone with little to no practice of VisualBasic. I understand basically how it works, and have taken one class on it; but am nowhere near fluent in it.)  1. How do you go about having a text field on a form set up so that right when user gets to the form, a Message Box or Input Box (with accompanying space for user to type) appears saying "Enter Date", so that whatever user enters into that message box is entered into the text field? I'd want to set i...

Posted to MB Topic: MS Access Interactive

Hi, just want to start by briefly giving you an idea of what I am working with, overall: I am using Access 2003. The overal Access file is made up of various Tables, Forms, Queries, and Reports (like normal), a few relationships among them--just standard stuff. Also, one of the tables imports data from SharePoint. I'm stuck in a few places, though--I have three different issues, currently: 1. I'm trying to do a mass changes query, and change all of the values in a certain field (Text data type...

Posted to MB Topic: MS Access Interactive

I hope I can put this question in a way that's not too confusing.  I'm pretty sure what I need to do will require a lookup field but I'm not sure which type, and I'm not sure what type of code I will need to get the results I require.  Let me explain: I work for an engineering firm where we are creating a database to keep track of a certain type of file called a "roll file."  Each roll file was created for a specific project.  Each project has a specific client, job number, and name associated with the plan.  Let's say there are three columns (even though there are many, many more!).  The columns are entitled Client, Project Name and Plan Name.  What I would like to do, is create a pull-down where you can choose the client.  Then in the Project Name and Plan Name columns, the information that you can pull down will ONLY correspond to the specific client chosen.  How can I achieve this? If this makes sense to ANYONE, I would gre...

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: MS Access Interactive

I have an Access 2003 Database and I need to be able to automatically dial phone numbers from a field I have in the form or table within the database (eg. Members work (field)) but when I press the command button the command is blank. any suggestions.

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: MS Access Interactive