Search results for query: *

I am new to frontpage. I would like to create an online test. After the user answers the question, I would like a page to appear to state whether they answered it correctly. What would be the best way to do this? Also, I need the results of the test sent to a database. Any information will...

Thank you so much!! This is great. [thumbsup]

I have an access report that I email in outlook everyday. Is there anyway to automate this process without human intervention?

I copied this into NorthWind database. It does great! However the NorthWind database does not have the time and date together in one field. Am I missing how this applies to my situation? I appreciate your help.

I have a field called LoggedAt. It has the date/time people connect to our system. It is in this format, 4/15/2002 1:34:00 PM. I need to do a query, where users may sort by date. For example, someone may want to know everyone who has connected to our system for 5/1/2002. How do I do this?

I'm new to using front page. I have created a form with questions for users to answers. I have chosen to use radio buttons. The radio buttons need to be larger. This is being used on a touch screen and some are visually impaired. I thought I should be able to "stretch" the button...

Thanks, the light bulb finally came on. I really appreciate the instructions.

Under the tblModels you have CompanyID - Integer/Foregin Key from tblCompanies. What is a Foregin Key and what option under access do you use to create it? Do you mean to use the look up wizard? Thanks.

I have two tables. A printer inventory table and a printer model table. The printer model table has the company name and printer model. How can I set this table up to have one entry of the company name with many models under the company? Then when users enter a new printer into the printer...

I have a query with a field in a file called account flag. This is a numeric value. In another file, called accounting flags is a field with the numeric value and another field called description. From a query I would like for the user to see the description rather than the numeric value. (I...

No it doesn't answer my question. Do I enter the "select" statement in the criteria portion of the query?

I have created a query in Access 2000. The field name needs to be different than what is displayed so it will be understandable to the user. Under properties for the field name I entered a name in the caption. When I run the query, the caption does not appear, the field name does. Example...

Thanks, I appreciate your help. It's working.

O.K. I've tried both of these suggestions (not at the same time.) Syntax errors occur with the SQL idea. Beth, Regarding your suggestion, it still wants to print every loan that a particular laptop has ever had instead of the most current. I really appreaciate everyone's help. Do you...

I'm not familiar with SQL. Where do I put the above statement SELECT TOP 1 [Laptop].[SerialNumber], [Laptop].[Model], [Laptop].[Modem], [Laptop].[InventoryDate], [Loans].[LoanedTo], [Loans].[Service], [Loans].[LoanedDateTo], [Loans].[LoanedDateFrom], [Loans].[WorkOrderNumber], [Loans].[Phone]...

Yes, I am linking two tables; one is the laptop loan information and the other table is the laptop information (this includes the model of the laptop etc.) Yes, there is data from both of these tables that need to be displayed in the loan agreement report.

Yes, it is. I could add a field to the laptop loan table called uniqueid and let it autonumber. But then how do still get this accomplished?

Every laptop has a unique serial number. However, that same serial number may be in the laptop loan table multiple times depending on how many times it has been loaned.

I'm new to access and I'm stuck. I have created a database of our laptops and when someone borrows a laptop. Created a query and a report with the necessary information for a person to sign accepting responsibility when using a laptop. I need to be able to print out the loan agreement for the...

I'm new to using Access. How do you know and where can you find your "linking field"?