Search results

Please ignore the properties of the way the table is set up as this is a simple broken down copy and sample data of the table I am using to show as an example. Is it possible to run a query to show the following: I want to know any names who have done "FirstAid 2" and / or "FirstAidOS2" but...

Is it possible to have a form that when the user clicks on a button it looks up a column in a table of email addresses and sends the email without the use of Outlook or other email applications? I am after a form that when the user inputs in fields e.g. subject, the message itself and then...

I have a form that shows the start time and finish time (timesheet) as well as other information. The question is, how do you make a textbox calculate the total number of hours worked? I have manually entered the number of hours worked, but just need the report to show the grand total of the...

Hey all... In Access 97, is there a way for a command button to have a link to a record? I have a command button that shows another form and when clicked, the user selects an option from a drop down list, which then takes them to that record. What I want is for the user to click on the command...

To All, Made an OutputTo action which uses a report (Mostly text and 1 image), a button which prompts the user to save the location and file type and then loads the program to edit/view (Which is Word). However, it all works fine apart from when the user views the document in Word, all the text...

When opening a database what does this message mean: Compile Error Can't find project or library. It then hightlights a line of code (Date) Cheers

Can anyone help? I have a table with the following: Booked with a y/n field Person Name with a text field So... Yes(True) Jim Yes(True) Jim No(False) Jim What I need is to be able to show a query that shows if the checkbox is ticked (True) and the Name is Jim total up how many true items...

Is it possible for a textbox on a form to show a result of a query? For example a query has a sum result and that can be shown in the textbox on the form. Also can you show any result in textbox from a query? Cheers

Hello all. Is it possible for a check box within a subform to make that entire row turn into one colour when selected true? What I want is when the check box is selected (True) that one row and the rest of the row turns into a colour e.g. red and become disabled? Any ideas? Cheers

Im new in using Access 97 and would like some help. Basically I have two combo boxes on a form - one containing Months of the year Jan...Dec that I have typed in manually and the second one containing years 1999....2006 (Also manually typed in). On a table I have got data on food and one of the...

Does anyone know why when you click on a command button that loads a report it shows it in a print preview mode and then when you click close it closes the report window and changes the form that you were originally on to a much smaller and condensed view instead of being maximised? All the...

Would this work: Having a command button that opens another database. Cheers

How would I go about doing this: I need to show two different forms one after another. For example; a menu screen (1st screen) with a command button that will pop up another screen (2nd screen) for the user to enter details about themselves. After clicking on the command button (On the 1st...

How would I got about with this problem. What would the code be for this command button. I have got two combo boxes that contain Month(cbo_Month) and Year(cbo_Month) and located in them are month names and month number e.g. Jan 1 Feb 2 etc and year 2002 02 2003 03 etc in 2 columns. These are on...

Hello, How would I go about in making a command button bring up a report to show a result of items for the end of the month? For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the...

Does anyone know how to do a query so that the user can find all the things that will expiry at the end of the current month? The user will click on a command button and it will show the results of a product that will expiry at the end of a current month. Have tried with parameters to which the...

I wonder if you can help. I am trying to make a combo box with peoples ID numbers in which links to a table with that persons details. I have made the combo box with the names in but now trying to link the table to it. For example: Fred is in the combo box with ID number 1 and the user selects...

Hello. Can someone please describe what an Automatic Counter is on a form? How do you set one up or input one on? Cheers :confused: