User Profile

Collapse

Profile Sidebar

Collapse
Dev1
Dev1
Last Activity: Apr 10 '08, 05:39 PM
Joined: Feb 14 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Dev1
    replied to Reference Control from a different form
    I've not gotten a response. Is my question to vague?

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    started a topic Reference Control from a different form

    Reference Control from a different form

    All-

    I would like to be able to call a query from a diaglog (form) when a value is selected from a dropdown (combo box). The for mentioned form will pop up when a user selects on of three buttons. Within the onchange() of the pop diaglog box I would like to set a IF condition to see which of the buttons from the previous form was clicked. Can anyone help?

    Thank you

    -Dev1

    P.S. Do you award...
    See more | Go to post

  • Dev1
    replied to Update Foriegn Key
    HELP! Is the question that I have to vauge?...
    See more | Go to post

    Leave a comment:


  • Dev1
    started a topic Update Foriegn Key

    Update Foriegn Key

    I have two tables, Company and Opportunity. Company table has two columns CompanyID (autonumber) primary key and Company.

    Opportunity table has OpportunityID (autonumber) primary key CompanyID , Industry and Contact. The relationship between the two tables is a one to many (1Company to Many Opportunities). I appended new records to the company and opportunity table. The problem is i have is updating the opprotunity table such that...
    See more | Go to post

  • Dev1
    replied to Appending Records To Different Tables
    It was implied that the OwnerID was a column in the the table (autonumbering) . I didn't realize that I had to be so explicit. Usually that is implied!...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Appending Records To Different Tables
    Thank you for your assistence, but I was able to get the answer from another site.

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Appending Records To Different Tables
    Thank you but yes there is a Owner ID! I understand normilization. I need assistance on my original posting.

    Thank you...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Appending Records To Different Tables
    Are there any articles that someone can share to point me in the right directions?

    -Dev1
    See more | Go to post

    Leave a comment:


  • Dev1
    started a topic Appending Records To Different Tables

    Appending Records To Different Tables

    All-

    I have two tables, A(Company) and B(Owner). I want to import the excel sheet into a temp table. Second I want to write two append queries that will append records to the company table and a query to append records to the owner table the relationship is one to many. Both tables are set for auto numbering. My problem is that when I do the append and view the data through my form I'm not getting matching records.

    ...
    See more | Go to post

  • Dev1
    replied to Importing Data
    How do you send a attachment for a private message?

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Importing Data
    Janders468,

    I'm still having issues with this. Is there anyway to send you a private message with an attachment?

    -Dev1'...
    See more | Go to post

    Leave a comment:


  • Dev1
    started a topic SharePoint

    SharePoint

    I have a question regarding SharePoint development surrounding 'Record Center'. Does anyone have knowledge of the record center and / or a site where I can post SharePoint development questions?


    Thank you,

    -Dev1
    See more | Go to post

  • Dev1
    replied to Allow Multiple Users
    Scott Price:

    Thanks a bunch!! That really helps. Our network is very static so that should work great. Thank you very much for you assistance!!

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Importing Data
    Janders468:

    Thank you very much for the reply! I have found a article that illustrates just what you mentioned

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Allow Multiple Users
    Scott Price:

    Thank you for your response. That is exactly what i have designed! I have a front end and a backend. Then if the front end is stored on say 5 user machines then when the user goes to open the front end .mdb will he/she have to go:

    1. Tools, Database Utilities, Linked Table Manager
    2. Select all etc...

    each time the want to use the application? Or is that a one time deal?
    ...
    See more | Go to post

    Leave a comment:


  • Dev1
    started a topic Importing Data

    Importing Data

    All-

    I want to import excel data that is on one excel worksheet into my access database that has 5 tables in a relational format. I'm not sure how to do an import in such a way that I can import the data to the corresponding tables in access. Is there a way to import all the data into multiple talbes in one pass?

    Thank you!

    -Dev1
    See more | Go to post

  • Dev1
    started a topic Allow Multiple Users

    Allow Multiple Users

    All -

    I have an access application that I want to put on a citrix box. Does access alow for multiple users where it will lock records like in MS sql server? If so, can some explain the configuration that needs to be done to an app?

    Thank you in advance,

    -Dev1
    See more | Go to post

  • Dev1
    started a topic Text Box Conditional

    Text Box Conditional

    All -

    I have one box tha is a drop down with numeric values. I have a second textbox that has a percentage value. I'm trying to set a condition based on the first dropdown box that when the value changes, the second textbox will be updated with the appropriate value.

    Dropdown - Textbox 'Class'
    Values 0,1,2,3,4,5,6

    Textbox 'Likeihood of sale'
    Values 100,90,33,20,5, 0,0

    ...
    See more | Go to post

  • Dev1
    replied to Create New Record in Form
    One other question. If you have a relation data schema, how do you facilitate a import of data from one excel spread sheet to populate multiple tables?

    Thanks you in advance,

    -Dev1...
    See more | Go to post

    Leave a comment:


  • Dev1
    replied to Create New Record in Form
    One other question. Can I have a sql server backend and a Access Forms front end (UI)?

    -Dev1...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...