Search results for query: *

I have a combo box that looks up a contact from the contact table and then fills in the contacts name, address, etc. on the form. Pretty standard. The primary key on the Contact table is ID, an auto number. The foreign key on the Meeting table is ID, a number Relationship is From the Contact...

Here is a good site that explains how to pull records sets using a query parameter. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00e19.asp

Hi, We'er expanding a local db to more users on the intranet. I'm to set this up and haven't done it before. I know I will have to set up work groups, permission levels, etc. How do I split up the db so the data (tables) are on the data server and the forms are on the general server? How will...

I have come up with this Function, but it works only with a table, not a query. Anyone know how to write it so the SQL statement can have a query? SQL = "SELECT Email FROM qryProduct1;" Function Email() Set db = CurrentDb SQL = "SELECT Email FROM Company;&quot...

Hi, I have a query that pulls a set of users. I want to open Outlook and have all the emails address from the Email field automatically in the To field of a blank email message. I've use the SendObject on a Macro to send a standard email message, but this will not work as the message will...

Hi, I know how to validate if a user has left an input field on an html form blank. What I need is for the user to input the phone field in a consistant manner, xxx-xxx-xxxx. Can the input field be formated, similar to an input mask in a database field?

Hi, I have the email field properties on the form set to Is Hyperlink = Yes. Then I have this code on the AfterUpdate event: Private Sub Ins_Email_AfterUpdate() Me![Ins_Email] = "#mailto:" & Left(Me![Ins_Email], InStr(1, Me![Ins_Email], "#") - 1) & "#" End Sub...

Hi, I have the email field properties on the form set to Is Hyperlink = Yes. Then I have this code on the AfterUpdate event: Private Sub Ins_Email_AfterUpdate() Me![Ins_Email] = "#mailto:" & Left(Me![Ins_Email], InStr(1, Me![Ins_Email], "#") - 1) & "#" End Sub...

Hi, I have the email field properties on the form set to Is Hyperlink = Yes. Then I have this code on the AfterUpdate event: Private Sub Ins_Email_AfterUpdate() Me![Ins_Email] = "#mailto:" & Left(Me![Ins_Email], InStr(1, Me![Ins_Email], "#") - 1) & "#" End Sub...

Hi, I know you can cancel a report if there isn't any data by using the On No Data event. Is there anyway to cancel a query if there isn't any match to the parameter criteria? Thanks

Hi, I have a staff table - staff_id, staff_name, etc. instructor table - instructor_id, instructor_name, etc. course table - course_id, title, etc. Staff may take courses - I have a staff_course table, fields staff_id and course_id. Staff Form has the main info from staff table with a...

Hi, I have a staff table - staff_id, staff_name, etc. instructor table - instructor_id, instructor_name, etc. course table - course_id, title, etc. Staff may take courses - I have a staff_course table, fields staff_id and course_id. Staff Form has the main info from staff table with a...

Hi, I have a staff table - staff_id, staff_name, etc. instructor table - instructor_id, instructor_name, etc. course table - course_id, title, etc. Staff may take courses - I have a staff_course table, fields staff_id and course_id. Staff Form has the main info from staff table with a...

Hi, The search is a parameter query. Typical set-up, when the user hits the command button for the search they are asked to enter a value, they then can hit OK to run the query. But if they hit Cancel the database closes. Is there a way to just take the user back to the form if they hit...

Hi, I have the following code on an unbound form, on the lost focus of a combo box. This works fine the first time the db is opened and user does a search. Pull down works, goes to correct record on the staff form, but if you go back to the find form to do another search, the combo box no...

Hi, I had set a specific form on the start-up menu and some how must have clicked to turn off the tool-bars. Now when the db opens I don't have the Tools, etc available. How can I get them back? CDWD

Hi, I've got the following code to underline a label to note that it is a link when user mouses over it: Private Sub lblReturn_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) lblReturn.FontUnderline = True End Sub Is there a way to remove the unerline when the mouse...

Hi, I know how to do the standard look-up to auto-fill in data on a form. This is the problem I have now and am not sure of the best way to do it. Staff may sometimes teach class or someone from the community may teach. I have created an instructor table and a staff table. I want to create...

HI, For no apparent reason I've started getting the following error message when I open a db I've been using for some time. : An error occurred while loading 'form name'. Do you want to continue loading the project? I get an error message for each form in the db. I hit'Yes' each time in...

Hi, Is there a way to over ride Access' automatic error message when a user types in a combo box that is set to Limit to List? I want to create my own error message for the user