Search results

hello, I have a database that I would like to have a google search from. I would like to have an unbound text box named "searchitem" the user would type their search topic in the box and press a command button. This would search google and pull up the matches in their web browser. How...

Hello, I have a continuous form that utilizes a touch screen for input. I have placed a page break after each record and am looking for a way to add a command button to perform like the Page Up button on the keyboard so the user can scroll throught the records. Any ideas? thanks, jason

Hello, I have a database with an action on a click event. The action is plays a wav or mp3 file. I would like for it to play for a specific length of time or allow the user to stop the sound when another action is completed. Set wmdp = CreateObject("WMPlayer.ocx.7") wmdp.url =...

Hello, I have a database where I capture when a task was created and when it was completed [dteDate] and [CompleteDate]. I want to capture the time as well so i document the now() into those fields. On my form, I want to view only the tasks that are due today. When I put the filter of...

Hello, I am a self-taught Access programmer and have done quite a few database builds. I'm struggling right now on how to set up my latest challenge. I want to create a database to keep track of duties that need to be done every day. Vision: A list of duties shows up on a form each day. An...

Hello, I have a report set to print 24 blocks of information. I am trying to figure out how to ask the user how many pages to print before the report runs in case they need more than 24 "blocks." Any suggestions would be much appreciated! Thanks, Jason

I have a date field that I want to default to the current day on the form opening. I have a yes/no box that defaults to no. When the user selects the yes/no box, I want the default date field to become blank. Any ideas on how to do this? Thanks, Jason

Hi All, I have a dap where users can input medication errors into a database. I have set-up other dap's that users can access to see the results. I would like to create a dap where a user enters their name and password and a date range. Upon entering this information, the user only sees the...

I have a database for my staff to enter data into via a data access page. It works on all windows xp os computers. We do have staff working on Windows 2000 os computers and it is not working appropriately. The database was created in Access 2003. When the user pulls up the page, none of the...

Hello. I built a database for work that lists high risk medications. It includes the name of the med, special monitoring parameters, warnings, and links to various policies. I created a form with a search function that works perfectly. I have a list box that contains all of the meds. In a...

Hey Guys, I have a DB with a 4 tbls: MedRecAudit; Physicians; Unit; PracticeName I have a query that finds only physicians from a particular practice and whether they filled out a particular order. One portion of the query is AuditDate. I use a between statement to limit the dates. I then...

I created a database to track tardies and absences of my employees. I would like to be able to sum the number of absences and tardies for each person per month and graph it. Per our attendance policy, 6 tardies = 1 absence. I need to take the total number of tardies that month/6 and add to...

I would like to build a database to keep track of tardies and absences in my dept (~70 employees). I need Date, Name, tardy or absent, My current table: TblEmployees EmployeeID PK Last Name First Name Team TblEvent EventID PK Event (Tardy or absent) TblAttendance Date EmployeeID EventID Is...

I'm trying to run a query that will show when something is due within the next 90 days. I keep track of employees competencies that they complete. I want to run a query that will only show me when the field [Renewal Date] is within 90 days of the current date the query is run. How can I do...

I am creating a data entry form with combo boxes related to two different tables: TblEducationID EducationID - Auto# PK Education - Text TblMediaFill MediaFillID - auto# PK Incubation Time- text Incubation Temp - text In my form, I have a combo box that the user selects the Education Type...

I need some help setting up my tables to allow cascading combo boxes. I need to document when a Pharmacy IV room and chemotherapy room are cleaned. Each Room requires different cleaning procedures. Here is my table structure: TblCleaningDuties DutyID-Auto# (PK) Duty - text (Example- mop...

I have a table that documents the result of unit inspections. The data is Date inspected (once/month), Unit, and about 12 yes/no fields. I want to run a query that shows the percentage compliant (yes) of all of the categories per month. I also want to be able to graph the results for one year...