Search results for query: *

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

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

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

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

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

I'm new to Crystal and want to create a Crystal report using an Access database as my data source. I tried to open the database but get the following error message: &quot;DAO error code 0xc26 DAO fields Could not read definitions, no read definitions permission for table or query...

On a small database I created a limited menu, toolbar and shortcut menu for a few of users. But I need a method other than using <shift> to bypass and restore the default menu and toolbar for maintenance and updates. Any ideas or suggestions are welcome and most appreciated? I didn't disable...

I have a text field that contains numbers with a maximum length of 5. How can I place a period at position 4 on records with length >=4, i.e., v672 should read v67.2 or 80711 should read 807.11, but 462 should read 462. I've tried IIf statements and formating the field as &&@.&& and that doesn't...

I have a report that I run using a parameter query. Now I need to run the same report but for selected records. I've tried creating a form with an unbound list box and the multiple select property set to simple so I can select several records. When I click on the print or preview command buttons...