Search results for query: *

I fixed it!!! A previous programmer added a second "OrganizationName" field to the main form which was the cause of all the issues. I didn't see it because it was layered beneath another subform. THANK YOU FOR YOUR HELP!!!

Many people have worked on this database in the past and used a number of methods I would not have chosen myself. The Organization name is the primary key for the main table (tblContactTable). This works since each organization's name is unique and duplicates are not allowed. That tables...

Then I am confused too, because I have the Link Master/Child properties set on my subform, but the values are not being automatically entered into the subform.

Sorry, I am using a Master/Child properties to synch the fields, but that requires the fields to be populated with information. I don't want users to have to retype the org name into the subform, I want it to autopopulate. The tables are: tblContactTable Contact The forms/fields are...

The form / subform relationship is based on the OrganizationName field. The contact subform filters all the records so that only the records with an OrganizationName that matches the current main form OrganizationName field are listed. The users do not see the OrganizationName field in the...

I need the "Organization Name" field to save the org name from the main form's org name field to the subform's org name field. I can get it to work, but I then recieve the following message when I try to create a new record: Field 'Contact.OrganizationName' cannot be a zero-length string. If...

I have a form which has a number of subforms. Speciifically, I have created a subform form called "Contact Log." The contact log is an area in which the user can enter a new record for each instance of contact made between our company and another organization. The main form and each subform...

It would be great if I could just export it as a query, but this table is designed for the purpose of filtering by the user. Each user filters the table (which is not editable) to show only the records they need. There are limitless possibilites when it comes to filtering the table, therefore...

How do you export a table that has been filtered to excel? Everytime I attempt this, the entire table is exported rather than just the records that remain after the filter has been applied?

No, the client number is a plain text box field.

I have an MS Access 2007 form that has unique ID numbers but has an additional identification field that can be the same for multiple records. For example, each record has an order number and a client number. The order number is unique, but the client number is used for every order made by...

I have a report that is run using a command button in a form. The report is populated with information from a query. Is it possible to notify the user if certains fields in the report are left blank becuase the field is null OR can the query require a user to complete null fields? For...

Actually, I was able to pull the employees names directly from the employee table rather than from the "Assigned To" field on the client table. Then I used an Alias for the employees' First Names and Last Names and updated the expression, so it works now. THANKS for your idea about using an...

Thanks for the idea, but after creating an alias and running the query again, it still populates with employee's ID number rather than their name.

I have a query that pulls data from a number of tables and combines the data into sentence structure for a report. For example, the query takes a clients first and last name and combines it with a salutation such as "Dear John Doe," The error I get is when I am added my employees name into a...

I have a data entry form with eight subforms. When viewed iusing Microsoft Office 2003 all the data in all the subforms is correct. When the same data entry form is viewed in Microsoft Office 2007, one of the subforms does not populate.

Can Microsoft Access read Binary Large Objects and usea report to create an output for the Blobs?

I have a number of check boxes that a user can choose. Currently, to activate the check box (select "YES") the user can click in the check box itself or on the label for the check box. I want to require that the user click in the check box only. I do not want the check box to be activated by...

Thank you all for the great suggestions. I ultimately went with Hap007's suggestion to create a shared shortcut. Although this is not the best method, this data base is only a temporary database interface with 3-5 users (at most 2 at any given time) that was created to operate for about a...

The database is already split, the back end is located on the server. If I place the front end on each persons PC it allows multiple users to work on entering data at the same time, but that is where my problem occurs. I do not want to place the front end on each persons PC, I want the front...