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

Thanks. The suggestion from grnzbra worked.

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

Thanks for your help. Solved the problem by removing the group by in the query.

The query truncates at 255. Is there a way to fix that?

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

Thanks. You can e-mail me at simmssx@pgcc.edu. I didn't mention that I'll need to store the selected systems in a table containing project_id and system_id for the associated project and system (multiple rows - 1 project_id with multiple system_ids if multiple systems were selected).

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

Jim, Thanks for your response. That solution worked. I agree presenting the list of names is preferable, but on this particular form the user requested the numbers. We do have several dialogs that present this list of names. Thanks again.

To simplify. Let's say the form contains 1 combo box [Agency_ID] and a text box [Agency_Name]. When the user selects a value in the combo box, I want its name to appear in the text box. The two fields are found in a table called Agency_List with Agency_ID as the key.

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?