Recent content by 4656rp

Howdy all, I created a query and form that allows the user select a record based on date of birth and I added a command box that will display the selected record. This works fine. The problem is that periodically, the prompt to enter a date of birth will popup intermittently and stay on focus...

Hello all, I thought I had it, but apparently not. I'm trying to determine a shift 1 (day 0700-1900) or 2 (night 1901-0659) from a timestamp. Here's what I've done so far, which sometimes works (probably a coincidence) and sometimes doesn't: UPDATE [Copydata] SET [Copydata].Shift_time =...

You folks are amazing! Many thanks. It's not what I was looking for, but I can work with it. I dumped the results in Excel and can cut all the other properties I'm not interested in like collatingorder or columnhidden and the like. Thanks again, this will work. me

I would like to copy the field, type and description fields of the table design to Word or Excel. I have searched at Microsoft after attempting a simple Ctrl C/Ctrl V. Specifically, I want the description which is not an available option in Tools/Analyze/Documenter. Do you have any ideas short...

I'm a novice to Crystal reports and need to create a report that counts the number of patients a doctor saw under several categories. For instance, patient consultDr admitDr treatingDr therapyDr 001 DrABC DrABC DrABC DrXYZ 002 DrDEF DrABC...

:~/ Tremendously! Many, many, many thanks, you've bailed me out again. So what was wrong with DateAdd......?

Another date question, sorry. I discovered that I can't use a parameter query in a crosstab query. I wanted the user to specify a date range between [start date] and [end date]; that didn't work. Next, I figured using a moving date range, but I want to exclude the current month. So I tried...

I'm sorry, I goofed. The time fields are numeric in 2400 clock. Nevermind, PH I figured it out. YOU ARE A GENIUS! Many, many thanks [bigsmile]

I'm sorry, I goofed. The time fields are numeric in 2400 clock. For instance, timein timeout Exp Result(in minutes) 809 842 33 710 1527 497 1018 1103 44 950 1116 86 917 1008 51

I have a couple a time fields (based on a 24 hour clock) in txt format that I need to calculate the difference. I have tried converting, using several date functions, using format(), and the only way I get it to work is padding records with len() < 4 with a leading 0. Is there an easier way...

Howdy, Here's my dilemma, I have a dataset of patients and each patient can have several diagnosis. I want to make a table that excludes patients if one (of many diagnosis) is in a lookup table of excluded diagnoses. Currently, I link both tables and select is null criteria in the lookup...

You read my mind, I intended to also ask about modifying the switchboard form to include tabs for data entry, reports, etc..., but decided to work on that myself. Thanks for the hint, though! I still don't understand how to create a 'customized' switchboard form per group. For example, if a...

I think a figured out a way around a previous problems I had with different levels of security. Now I want to create a switchboard form(s) that will open depending on the user's security level. For example, the switchboard for the user with view only security would not see the report options...

Many thanks SimonDavis, I had not thought of duplicating the front end and creating a new MDW for this group. Fortunately, I split the database to create front/back-ends. I'll give your suggestion a try, although I wish I could have the different levels in one MDW. Thanks again! [smile]

I have inherited an Access97 database. I've added and removed users as needed using the Tools/Security/... Now I need to add a group to allow specific users Read Only rights. Do I need to setup each table/query/form/report for each user? When I tested it with one user the default 'User' appears...