Search results

Okay, I know this is fairly simple, but I'm suffering from a case of "coder's block" in how to make this work. I have a parent form, frmPatient, with a subform on it, called frmSubVendor. The main form gathers information about a patient and the subform shows the contact info for the vendor...

Good morning, all! I'm trying to figure out some way of reducing the administrative workload on our secretary. Here is the scenario: A manager hires or receives a new employee. They are required to meet with the employee on the 60-day, 120-day, 6-month, 8-month, and 10-month anniversaries of...

I have a report that is being populated by data in a cross-tab query. Because I need to have the user specify the date range for the report, I have a criterion in the query that reads "Between [Enter Start Date] And [Enter End Date]". This has worked fine in all my other queries and reports...

I could have sworn there was a way to do this built into Excel, but I'm not finding anything that works so far. I'm going to resort to example names to make the state of things clearer. In essence, I have two columns: Child and Grade. Child has five potential values: Annie, Bobby, Clare...

Odd question, but I'll see if I can describe it effectively. I'm creating a booklet version of a union contract, and one of the features that would help us all greatly would be if I could put the article title along the outside margin of the booklet, with the text alignment being such that, if...

I could certainly use some input on how to structure this. I have a table that's 20 rows by 12 columns. Each cell has a particular value that I want to draw by random sample; each run of the sample will pull five random values. To do this, I set up two columns, each with five cells that...

I've already solved this, but thought I would share. I have an Excel 2007 workbook with multiple worksheets in it. One sheet is called "Tables" and houses all the reference data, which in turn are defined by names and absolute ranges ($A$1). Another sheet is called "Design" and has dozens of...

I've tried a number of different methods and still can't get this to work. I have the following in a sheet called "Tables": 10 9 8 7 6 5 4 3 2 1 0 10 9 8 7 6 5 4 3 2 1 0 9 8 7 6 5 4 3 2 1 0 8 7 6 5 4 3 2 1 0 -1 7 6 5 4 3 2 1 0 -1 6 5 4 3 2 1 0 -1 -2 5 4 3 2 1 0 -1 -2 4 3 2 1 0 -1 -2...

I have a report that pulls together all kinds of data. In essence, it gives the CEO a list of departments (called "services") within our hospital, with numbers of employees assigned and vacancies. Below each department header (the report is grouped by service) is a list of the current open...

I built a call-center database for our pharmacy technicians to use in logging patient phone calls. Since March 3, they have logged 13,700 calls in the system without any trouble. Suddenly, starting this morning, they have all been receiving the "You can't go to the specified record" error when...

Good morning! I'm building a database for use by four technicians in a call-center type operation. The call records are purely transactional in nature -- once the call has been logged, the record is closed. If the customer calls again, a new record is opened. The supervisor doesn't want the...

Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page...

Howdy! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology, and I'm not wild about trying to do anything fancy with data access pages or whatever. What I really want is for the CEO's secretary to be able to upload a new HTML page once a...

I'm not even sure which forum to put this in, as it involves a form, two tables, some queries, and possibly a macro. I've poked around the message boards here and haven't quite found a method that works for my situation. So here we go! I have a recruiting database that I've developed for some...

I'm building a database to allow me to store and draw reports from Equal Employment Opportunity information needed for government-required reports. I have three tables: tblJob: 1. jobSPN (a number attached to the Civil Service description of the position) 2. jobTitle tblCandidate: 1...

Hello, all. I have two combo boxes on a form; each has integer values from 1 to 5. ComboGreen cannot be greater than ComboRed, so if the user selects "3" in ComboRed, they should be restricted from choosing "4" or "5" from ComboGreen. I thought I could use the ValidationRule property to do...

I'm sure there's a way to do this, but I haven't been able to figure it out. I have a form with a combo box and five subforms on it (numbered 1 through 5). If a user selects "3" from the combo box, for example, I want subform4 and subform 5 to be inaccessible to the user; I figured that I...

How can I compare two nearly-identical tables to see which records/fields within them are different? For background: I have built an Access tool that allows me to generate some fairly complex reports at the touch of a button. The tool is fed an Excel spreadsheet that is downloaded monthly and...

OK, I'll set this up for you. I'm using Access to create a set of reports that previously took days and days of Excel pivot tables. The reports are fed by a single gargantuan spreadsheet downloaded once a month from our HR database, so my Access tool is purposely not normalized. There is a...

I have a list of people and three possible criteria for each -- fields A, B, and C. I need to extract a count of those who meet at least one of these criteria, but I don't want to count people twice who might meet more than one criteria. So, if Jennifer meets the criterion for field A, she...