Recent content by DrStephen

We have an Access app that resides on a Novell server. The app allows users to enter text data into a form, mark that data entry form as complete (or save it for future editing), file the form (which moves the record from a temporary table to a permanent table, converts a report (more or less...

We have an Access application that automatically converts a report into a Word document (and subsequently distributes the doc via e-mail). We just experienced a problem. In the original Access report, a user entered the character string 'CTRL' (or maybe 'ctrl')as someone's initials. The...

...but you're forgetting (actually, I forgot to mention) that, while my work laptop is getting a bogus IP address, the other workstations and laptops accessing my home network are acquiring correct addresses...

It is a company PC -- which worked fine on my home network prior to Safeboot/Active Directory...also, we've been able to access other non-work networks (e.g., at Starbucks)...

...this one's driving me crazy... Everything was working fine on my home network...multiple workstations/laptops...DHCP was handing out appropriate IP addresses (192.168.1.xxx)... Safeboot was recently installed on my work laptop (Dell Latitude D630). Active Directory was also put into the...

...worked like a charm. I was leaning in that direction, but probably would have used a make-table query rather than a select (for no good reason)... ...thanks.

I have two tables: 'T Drugs' and 'T Removed'. 'T Drugs' is a list of 100 drugs that can be used. 'T Removed' is a table that records drugs actually used. This table contains a date field. I want a report of all drugs used between two entered dates. The report, however, has to include all...

Sample of data follows: userid lastname firstname testname grade 123456 Jones John Addictions 123456 Jones John Safety 123456 Jones John Compliance 784584 Smith Betty Addictions 789584 Smith Betty Safety 789584 Smith Betty...

I have a query that returns multiple records for users (staff taking exams). Each record indicates an untaken exam. I have a query that will deliver all of the untaken exams (one exam per record). Unfortunately, that produces a very large number of records. I want to write a report that...

OK...weird problem (aren't they all?)... I have a data set with 4 fields: TestName, Group, Division and Grade. I have 400 staff taking exams. The dataset returned by the online test-taking application gives me a table of every user by every exam. I have a total of 11 exams. Here's the...

Is there anyway to have a macro close Excel, itself. I can get one to close the workbook, but can't find a way for it to continue after and close Excel. Thanks.

...worked like a charm, PH...Thanks.

The data are imported from another application. Both grades are contained in a single record in that application. Actually, the application, itself, is supposed to return the highest score on any exam taken, but it doesn't appear to be doing so. As a result, I have to program around it. I was...

I have two fields (Grade1, Grade2). How do I return the higher of the two grades? Grade 1 Grade 2 High Grade 100 20 100 50 87 87 This has got to be a simple thing to do (unless, of course, you don't know how to do it). Thanks.

I have a report that runs off of a query. I'd like the text field to expand to whatever size is required. The problem is that the text field in my report (Report 2) is truncated. I haven't counted, but I willing to bet it's chopped at ~255 characters. I have another report that accesses this...