Search results

  1. L

    Data portection on querry subforms.

    I have a form with a querry as a subform, I only want the user to be able to edit 2 of the 4 items shown on the subform, but I can not find a way to protect data in a querry. This form is for teh mamager to approve multiple records on a single page, so the querry subform is the easiest way...
  2. L

    need sql query to show 1 of each different item

    I have a table that I am using as a lookup for a set of list boxes. the list boxes will cascade from 1 to the next. the first list box i need to only show each catagory once. the table has about 150 entries. but there are only 6 diferent catagories at this time. so i need to know how to...
  3. L

    can't change a field data type

    I need to change a field data type but when i try it tells me that i need to delete a relationship in the relationships window. but when i open the relationships window it doesn't show any.
  4. L

    using VBA to write information into an embedded word document in an access field.

    I have a table with a field that is an ole object and has a embedded word document in it. I am trying to import archival data into the system and need to write information to that ole object word document. after the new systems goes "Live" the data will be entered into the embedded word file...
  5. L

    Merge tables.

    I have 2 tables, 1 contains a document number and several fields, and the other contains the document number and about 40 other fields. I want to merge the 2 tables so all the information is in 1 table. I have googled this but only seem to find cases where both tables contain the same...
  6. L

    Is it possible to define a default font & color scheme for an access database?

    Is it possible to define a default font & color scheme for an access database? Something like a theme in frontpage I want to set a font, default font color and default background color for the entire database. The goal is not to have to set this information every time I create a new form...
  7. L

    Lock fields in position to background image on data input form

    I am creating a data input form in access. I am trying to minimize the learning curve by displaying a form that the users are used to as the background image and placing the fields on it in the design view. But when I display the form, none of the fields match to the background. Is there a...
  8. L

    The OLE object is empty

    I am new to VBA for access. I have done a small VBA project with excel but this my first attempt to do anything with access. I'm getting "The OLE object is empty" and I understand why. what I want to do is avoid this by automatically creating a word document and embedding it in the field in...
Back
Top Bottom