Search results for query: *

My SQL is a little rusty. Table 1 (High School) contains High_school_Id and High_School_Name. Table 2 (High School Students) contains student records with High_School_Name duplicated. I want High School to contain a list of unique high school names. I tried the following with no success...

I have a table with a field, DOB, defined as a number. This field is date of birth. For example, the data appears as 19860302 - I need this to be 03/02/1986 in date format. Any ideas how I can accomplish? Thanks in advance.

We have developed an application using Access 2002. Our user community has mixed platforms; some Win 95, some Win 98, and others XP. What's the best way to deploy? Thanks in advance.

I have a project report by resource that shows the tasks a resource has worked and the status. The task table for a resource resembles the following. 1. Resource A -- 8/1/03 -- Status In Progress 2. Resource A -- 8/8/03 -- Status In Progress 3. Resource A -- 8/15/03 -- Status Completed. I'm...

I have a project tracking database where resources enter activity for project tasks in a task weekly tracking table. Here's the data entered: date of entry, status, and comments. When project managers review these resource entries, they want the option to indicate that the entry is approved...

I have a report which prints data produced by a query. One field from the query needed by the report is a memo field. The query will not produce more than 255 characters of the memo field. What should I do to correct this? Thanks in advance.

I'm completing a theatre attendance tracking database. The user has a requirement to send via e-mail the flyers advertising each performance. The database contains e-mail addresses. What is the best way to accomplish? Thanks in advance.

I have a project tracking database with 3 categories of users. 1 - Project Managers (can update all forms and tables) 2 - Project Viewers (can read all forms, reports and tables) 3 - Project Resources (can read all forms, reports and tables but can only update tasks that they are assigned. If...

I'm providing access to various documents using a hyperlink address. I have a subform containing 2 fields; documentation type and a hyperlink address for that document. This is ok, but the path for the document could be rather long. Is there anyway to allow a browse of drives on the...

I am developing a project tracking database where the end user can select multiple systems that a project pertains to. I want a button that opens a dialog with the list of possible systems (about 100), and then I would like to take the items selected and place them in a another text or list box...

I have a form with 2 combo boxes, Box A and Box B. Box A contains the list of Agency IDs and Box B contains the Agency Names. When the user select a value from Box A, I want to replace the value in Box B with the name that corresponds to the Agency ID just selected in Box A. I need to the...

I have a field, agency_id (exit event)with the following code below. If this error exists, I do not want to save the record. I've tried adding the code in the close, deactivate, unload events of the form. That does not seem to work. What's a good solution for preventing the save when there...

I have table containing a foreign key, contacttypeid. The table store the value 1, for example. The translation for 1 is found in Contact types table in the contactname field. How do I retrieve the value from the other table and place it on my report?