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

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

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

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.

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

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

I have two applications that are developing the same problem. Both of these applications have been in production for several months (with no problems). In each of the applications, users may generate a report. The Access report works fine. Once the report is generated, the user publishes the...

[b][blue]I have a DB that is accessed by multiple users. Is there any way to compact the DB on a scheduled basis (e.g., daily)? Do I need to have exclusive access to the DB to do this? How do I kick everyone off prior to the DB being compacted?

[b][blue] I have a database that is accessed by multiple users. Is there any way to set up something that will automatically compact the database at prescribed intervals (e.g., daily)?

[b][blue]I need to import a flat-file into an Access database. I can make the flat-file delimited or fixed-width. My intention is to automate this process and import the flat-file every day. To do this, I need to create a macro to TransferText. TransferText requires that I specify the...

[b] [blue]I need to calculate 'working days' for clients. This is defined as the number of days between today() and an admission date -- excluding Saturdays and Sundays. Does SAS have any kind of 'working day' function?

A few months ago, I was attempting to send as an attachment a rather large Excel workbook. For whatever reason, the transmission was unsuccessful. The problem I have now is that the message and the attachment are permanently esconced in my outbox (this is MS Outlook 2000). My e-mail still...

[b][blue]A report I've written is, essentially, a form letter that contains info existing in the database. One field that is output is a long narrative that can be anywhere from a couple lines to a couple pages. Here's the problem: [b][red]How do I set up the report so that the size of this...

[COLOR=blue] I have a report that sums mulitple events by division based upon a crosstabs query. The output is similar to the following: [COLOR=red] Event 1 Div A total Div B total Total of Event 1... Event 2 Div A total Div B total Total of Event 2... Event 3 Div A total...