Search results for query: *

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

...that's it...column heading properties...although I like the join approach... Thanks, guys...

OK, here's the problem (and I think 'help' is descriptive)... I'm running a report that counts incidents by program (e.g., 'Program A', 'Program B'...). The report is based upon a crosstab query that summarizes incident type and subtype by program. The report needs to present all programs...

I have an Access that I export to Word using the 'Publish it in Word' command button. The output takes the form of a letter. One field of the report is allowed to expand (let's call the field 'problem resolution'). On page 1 of the report, the 'problem resolution' field begins about 4 inches...

I'm using the 'Office Links' command button (i.e., 'Publish it in Word'). There is no 'new Word format'. This app has been running fine for a couple years already. Something about SP-2 or SP-3 is causing a problem. If I run the app from a Win 2000 (SP-1) machine, it still works fine.

I have an application that produces an Access report. Once the report is generated, users are instructed to click on the blue 'W' icon on the menu bar to convert the Access report to a Word document. The application worked flawlessly for a couple of years. We've discovered, however, that once...