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

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

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

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

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

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?

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

I have a command button to print the note from the open record. I am using the code stDocName = "Reproduce progress note" DoCmd.OpenReport stDocName, acPreview, , "[PNID]=" & Me![Text2] this works however in another location in the database I have a multi-tabed form that on the last tabed...

I have built a form that has a listbox driven by a query. query asks for last name the list box displays a list of first last and customer numbers. the design is such that you click on one of the customers and then on a button that opens that customers record. to accomplish this I added a text...

Hi I have a table with the following listed {ClientId], [Effective Date], [Lapse date],[Contract] This lists each authorization record for each client. The info is imported from another system which is not capable of filtering so I bring the data into access to run several queries and reports...

Hi I have created a database that keeps sports stats. each season I clean out the database to start fresh I would like to automate that. I know how to setup the clearing of the tables. what I need an assist with is this. there are multiple reports and forms in the database that have a heading...

I have built a database and have hidden the DB Window at start up. Knowing that I can get at it via f11 or holding down the shift key at start. while I was working on the programming my keyboard on the laptop had a key combination that locked the number pad on the keyboard it took several...