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

I think there might be some confusion. The continuous form shows more than one record. It currently displays 18 records but the user has to scroll to see more than 6 at a time. This is a duties task list that provides the user information on the status of a task. That's why I want more than...

It would be the easiest way! I'm building a status bar that shows what is going on and I need to have numerous records showing at once.

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

This worked perfectly!!! Thanks for your help. This place rocks! Jason

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

pbaldy, I figured it out. Thanks again for all of your help! Jason

I'm sorry pbaldy. I am completely lost! That must mean it's Monday! I hate to even ask but is there any way you can help me with this? Jason

pbaldy, Thanks for your response. Now I feel like I am getting outside of my knowledge of Access. I would like for it to automatically add a date for all duties without user input. You are saying that I make a module in a separate database with the code you posted. Then, I use a macro...

Where would I insert that code?

I know better than to use the word "Date" as a field. I had a brain fart. I didn't know about the table lookup field. Would I just write code to pick the employee? The code looks like it would do what I want. I don't want the user to input dates. I'll give it a shot. Seriously, I really...

pbaldy, I sent you a pm. Here is my db. Thanks, Jason

Ok. I think I have most of it figured out. A few more questions: Each task has whether a technician or pharmacist is required for the task. If the pharmacist is checked yes, I want a command button for a pharmacist check to show for that task. If a pharmacist is not needed, the command...

Ok. If I understand this correctly: List all Daily tasks in one table: TaskID Task What would go in the activity table? Date Completed and Employee? Would I have to go into the db daily to update the tables so the form will show the current day's duties or can that be automated? Thanks for...

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

that worked perfectly!!! Thank you so much!! I appreciate it!! 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...