Search results

Hi I have a select QRY that asks for a date range for intake calls. I need to get a count of calls that came in during that period that dropped out. I have a dropped out date field and in the qry have that set to is not null. Here is the issue I only want the drop outs that are in the same date...

never mind I just switched it to on focus and it works

HI I am working with a mesage box with yes and no that is triggered on the lost focus event after the discharge date is entered if yes the users is thanked and approved to go on to the next step. If no the user is prompted to complete the task and retun to enter the discharge date. I would also...

worked great thanks

I am working on a stat database for a dart league. each player has the possibility of playing in 3 games a night. I have been able to gather all the totals of scores wins lossess number of times played and a percentage on each type of game. example 601, cricket, 301 when I try to total the...

HI I am working on a database that holds communications from treatment episodes. the sub form holds the communications related to that client and that treatment episode. when you enter a date into the communication record a mesage box asks if this is a new treatment episode and if yes opens a...

Thank you seth I was able to do the if than from the form it was between the form and sub form works great thanks

Hi I have a database with a form and subform the database is for a bedlist tracking system it monitors both the bed availablity and the treatment episode of the person. the form has the bed specific info and the subform the episode specific info. I need to be able to create 3 check boxes on the...

Hi I have a booking database that I am building when you go to book a bed you enter the bed number and another query runs showing you all the beds in that room and if they are booked if they are male or female. can only have one gender per room. when the bed is released and made available for...

I have a listbox with client DOB SS gender the user picks a client and then opens the record. the Query holds the format of the SS number but when opened in the listbox it looses its formating and all the numbers run together any suggestions thanks

Looking for an automation solution currently I have a database for client progress and prescriptions. when the file is opened it is set for data entry so that a clean note form is opened. I have a button that pulls up past notes for their review. it has been requested that there be a way to pull...

Hi Ive been searching for answers need assist. I have a multi tab form with multiple sub forms and control buttons. One of the buttons calls a report to come into preview mode. the problem is when I close the report the multitab form loses its max size. I have tried docmd.maximize on the on...

Hi Ive been searching for answers need assist. I have a multi tab form with multiple sub forms and control buttons. One of the buttons calls a report to come into preview mode. the problem is when I close the report the multitab form loses its max size. I have tried docmd.maximize on the on...

Thanks as I explored further I realized that it was actually a subform that I had embeaded into the report and it would only pull the data for the first client record in the subform. All the other client records pulled fine in the report but without the subform of their meds. I changed the...

I checked the Child and master Links and those appear to be correct. the report itself pulls fine If I pull up a progress note for an individual the Meds comes in correctly in the Sub form/sub report. It is when I run a query attached to the report asking for all notes on all clients since a...

I have created a report that documents a visit to the Dr Office. the Meds that are prescribed are in a different table and linked into the progress note via a subform linked at the Client ID. This works well. However now they would like to be able to print all notes since a secified date. This...

very helpful thanks :)

Hi I have sendkey "{f7}" on loss focus. this works great as a spell check but then I get the mesage box that spell check is complete. How do I stop this box from occuring?

Out of memory I experienced multiple out of memory messages with Access97 found the only way around it was to conver up to Access 2003

HI I have five tables that contain information all connected with a clientID I want to set up a delete query that will erase all information on a particular client. I know I can run 5 separate delete queries each asking for a client Id before running. What I want to do is find a way to run all...