User Profile

Collapse

Profile Sidebar

Collapse
jl2886
jl2886
Last Activity: Aug 2 '07, 03:43 PM
Joined: Mar 26 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jl2886
    replied to Query Question
    I do not want them combined to one field, sorry.
    Here is what the query looks like now:
    Case Number 5 Fields from the Many Table 20 Fields from the One Table
    507-111
    507-111
    507-111
    etc.

    The 5 Fields from the many table are different for each case number, but the 20 Fields from the one table are the same for...
    See more | Go to post

    Leave a comment:


  • jl2886
    replied to Query Question
    There is no grouping involved.
    I have two tables:
    Ex)
    Main Table
    Case # Other Fields
    112-112 blah blah blah

    Other Table
    Case # Other Fields(not the same as the main table)
    112-112 blah
    112-112 blahh
    112-112 blahhh
    112-112 blahhhh


    I want to then want to create a query that looks like this:
    Case # Other Fields ...
    See more | Go to post

    Leave a comment:


  • jl2886
    started a topic Query Question

    Query Question

    I have a 2 tables. They are linked together by the primary key of the (one) table and one of the primary keys of the (many) table. When I bring the two tables in the query I get separate entries for each of the lines in the many table, but I would like for the fields of the "many" table to be added horizontally to all of the cases in the "one" table. Does anyone know of a way to do this?
    See more | Go to post

  • jl2886
    started a topic Build Query from One to Many Relationship

    Build Query from One to Many Relationship

    I have a 2 tables. They are linked together by the primary key of the (one) table and one of the primary keys of the (many) table. When I bring the two tables in the query I get separate entries for each of the lines in the many table, but I would like for the fields of the "many" table to be added horizontally to all of the cases in the "one" table. Does anyone know of a way to do this?
    See more | Go to post

  • jl2886
    replied to Table Relationship and Form Problem
    I need 4 tables because there are too many fields for one table...
    See more | Go to post

    Leave a comment:


  • jl2886
    started a topic Table Relationship and Form Problem

    Table Relationship and Form Problem

    I have 4 tables that are linked by a unique indexed case number. I want to have a form that allows you to create a new case and enter information to one of the tables, but still create a new case number in the other 3 tables.
    I have tried creating a relationship-one to -one between the one table and the rest (Case Number to Case Number. )
    I then created a query that brings them all together, but there are 4 different case numbers...
    See more | Go to post

  • jl2886
    replied to Problem with Macro RunSql Statement
    Thank you, but I get a syntax error when i place the statement in the macro run sql action?...
    See more | Go to post

    Leave a comment:


  • jl2886
    replied to User Defined Date Range
    Is this a filter criteria for the form, or is it a query def form?
    See more | Go to post

    Leave a comment:


  • jl2886
    started a topic Problem with Macro RunSql Statement

    Problem with Macro RunSql Statement

    I would like a all records from [Master Log] (a table) where [Master Log].[Disposition]="Rejected" and input those records into the [Rejected] (a table). Both tables are exactly the same as far as structure. I have created a macro with one RunSql Statement.
    [Code]
    INSERT INTO [Rejected] SELECT ALL FROM [Master Log] WHERE [Master Log].[Disposition]="Rejected"
    [Code/]
    It says there is a syntax error,...
    See more | Go to post

  • jl2886
    replied to Automatic Backup
    Hmm, maybe I want it to back up every day. and save to a different folder on the server
    See more | Go to post

    Leave a comment:


  • I think I will want to use SQL and select records from the table based on certain criteria, then append them to the new table, then delete them from the old? is this right
    See more | Go to post

    Leave a comment:


  • jl2886
    replied to Automatic Backup
    Might you illucidate how? I don't know how I want to do it because I don't know what my options are?
    See more | Go to post

    Leave a comment:


  • Create Macro that deletes from one table and appends another

    Is there a way to create a macro that, based on certain criteria(dispos ition status and date received), removes a line from one table and adds it to another.
    See more | Go to post

  • jl2886
    started a topic Automatic Backup

    Automatic Backup

    Is there a way to automatically create and save a backup database?
    See more | Go to post

  • haha, that's what I did...thanks!!...
    See more | Go to post

    Leave a comment:


  • Reference a field that is not in form, but is in the same table

    Can you reference a field from the table that a form is based on, if the field is not located on the form?
    See more | Go to post

  • jl2886
    replied to How to break up table?
    Does anyone have any advice?
    See more | Go to post

    Leave a comment:


  • jl2886
    started a topic How to break up table?

    How to break up table?

    I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
    I want to improve speed.
    So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. ...
    See more | Go to post

  • jl2886
    started a topic Handling Nulls in a String

    Handling Nulls in a String

    I have a button that when pressed on a form, automatically reads statments and inputs a text sentence, based on other fields on the form. However, the variable only gets assigned a sentence if something is true, but null if it is not true. The below code sits after all of the criteria statements. The problem is that when the first four statements are null, the field has four spaces before the sentence. This is obvious because of the " "...
    See more | Go to post

  • jl2886
    replied to Mousewheel DLL not functioning
    Perfect, thanks a million
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...