Search results

  1. R

    Usability issue with Print and Export

    I have a subform that I want to print (and export to excel) and it keeps asking me to provide parameters that are already provided on the main form. I'm missing something. Here's what happens. Please reference "TheForm". When the main PCLists form is opened the datasheet view area is blank as...
  2. R

    Performance issue on Append with Data Macro

    I'm redesigning a database that had 1 master table and 5 dependent tables - all with one to one linkage. The 6 table structure was to save space by not creating rows in the dependent tables when that sort of data was absent. The queries, while not hard, were complicated in that they all had...
  3. R

    Nulls and One to One relationships

    In the simple case I have three tables. The first has 10 rows with fruits as a column as the Primary Key. The second has 5 rows with fruitsLiked as the primary key and foreign key to fruits. The third has 7 rows with fruitsHated with an index with no duplicates allowed on fruitsHated which is...
  4. R

    Question Drag and Drop between Databases

    I've been developing several databases. Some elements that were experimental are now going "live". My development environment is Access 2010 on Windows 7 Pro. The "live" environment is also Access 2010 but running on Windows Vista SP2. In development, I can drag tables, queries, etc. from one...
  5. R

    Main Form Text Box Can't reference Sub Form

    Based on earlier suggestions against Split Forms, I've converted to using a Subform. I still can't get data from the subform into the main form. The simplified main form has 3 text boxes and a Requery button (with macro). Two text boxes are used as criteria in a Query. The criteria for the...
  6. R

    Filtering in a Split Form

    I have created a query that takes parameters from a form, wraps the parameters with "LIKE (*"&parameter&"*)" to search for substrings in the underlying table. The command button on the form Opens the Query which then produces the datasheet view in a NEW TAB. I'd like to do the same sort of...
  7. R

    Roger Reinsch Intro

    Hi, I've been working with Microsoft Access 2010 for about 4 months. In a prior life, I lived near San Jose, CA and worked on development of IBM's DB2 SQL product for mainframes. I now live in Prescott AZ. We're Arizona's mile high city (actually 5300 ft - but who's counting) so the weather is...
Back
Top Bottom