Search results

Hi there. I'm having a problem with a data calculator that I've been using, basically I download this data extract that includes some dates, some numbers etc into an excel form. I've determined that the date values I extract are now being displayed as text (just 4/4/2011, instead of the...

Hi all, I currently have a database that I use to push out reports in the form of pivotcharts. I have a main form that has the ability to filter my data via a subform in pivotchart view. What I have been doing is export these filtered charts as pictures and building reports that way...

I have a quick and dirty way of building reports by exporting charts as jpegs and inserting them into powerpoint presentations. Is there a way I can just export the picture right into a specific slide in a powerpoint template? -Z

Hi all is there a way that I can configure myfront end to make a backup of the backend everytime it closes?

Hi all, I'm looking for ideas on how to corrdinate follow-ups for incident reports. What we have here now is a paper based incident report that gets sent to me with investigation notes attached to it. I input a summary of each one and use records to push-out data. Due to legal...

Hi all, Im creating a series of charts to shows trends over time. I would like to include a "grand total" of records series to go in my line chart, and I can't seem to find a way to include it. All I can get is the individual column fields. If I leave the column fields blank, I can...

Hi there, I have a field in a table that only has 2 possibilities: Near Miss or Actual Event. How can I create a ratio of one to the other, i.e. count the number of Actual Events by the number of near misses? -Matt

Hi all, I want to create a new field that draws from another field in the same table. One possibility is "Near Miss" in the existing field. For every record where "Near Miss" is in the existing field, I want to have "Near Miss" in my new field. In all other cases I want "Actual Event"...

Hi all, I have a subform based off a query that displays data in a pivot chart. In the pivot table view, I have it set up to give me the count of records per months over time for several categories, displaying in a line graph per month. The first time I use it, it works perfectly. But...

Sorry to repost, but Im not sure where it belongs. Hi there, I have a form that filters a subform based on a query. The subform's default view is pivot table and allows me to produce charts that I want to export as picture files and eventually add into .ppt presentations. I get a type...

Hi there, I have a form that filters a subform based on a query. The subform's default view is pivot table and allows me to produce charts that I want to export as picture files and eventually add into .ppt presentations. I get a type Mismatch error when I hit my export button and I'm...

Hi there. I have a cascading combo box based on a table of specific types of incidents. So: If you enter x into combobox A, you get list 1. Enter y into combobox A, you get list 2 and so forth. I want to update list 2, adding in a new selection. It is based on a table on the backend...

I built a database acouple years ago, but having had to convert it from a series of excel files to an access database. Almost all of the information is stored in a single table. Is there a simple way for me to pull apart this table into different categories? Would this help speed up the...

I have several forms that contain subforms. I require it to be an option that fields be left blank and saved that way. I get the error "you cannot add or change a record because a related record is required in "tblendreason" (or whatever table the combobox related to. How can I make it so...

Hi there, I have a series of forms for users to enter data about isolated patients. I have two tables with a parent-child relationship. The parent table contains info about the patient (tblPatient), and the child table (tblCase) contains info about the specific visit. There are also tables...

Hi there, I have a series of forms for users to enter data about isolated patients. The first form in the series contains a listbox linked to a query that displays all of the patients that are currently present and under isolation at the hospital. I have two tables with a parent-child...

Hi there. I found this example somewhere (see attachment search multiple fields.zip) and thought it would be great for my DB. I have a list box set up in my database's startup form that displays all of the open cases (child records that have a null value in the enddate field). I want to...

Im using the ajbcalendar button to populate a text box for dates. I have an afterupdate event that makes a control visible when the value is not null. It works fine if you type in the data manually, but not when I use the calendar button. What gives? -Z

Hi there, I have a TON of queries in my database, and I'm not sure if I need them all, they seem to be slowing my DB down alot. The Db only has one table, which keeps tracks of incidents and all their details (location, date etc.). I want to report back to the managers of the locations...

Hi there, I have a database with a parent-child relationship. Parent - Patient. Child - Individual visit. How can I create a form that will take user's input and put it into the correct table ? -Z Edit - For example, in the northwinds sample.....if there was a form for customers to use to...