Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kellyputty

    Look Up table Parameter for a report

    Is there a way to have the parameter for a report be from a dropdown box of predefined values? For Example, When opening a report I want an input box to display a drop down box populated with: Carpenters CDLS Electricians Thanks, KellyPutty
  2. kellyputty

    Enable/Disable controls w/o new record creation

    I would simply like to enable/disable controls based on whether a checkbox is checked. However, the following code creates a record even before the actual update. For example, if I check the checkbox, then change my mind and uncheck it, there is a blank record inserted into table...
  3. kellyputty

    How to prevent psuedo-orphaned-foriegn keys?

    When using a form wizard. Psuedo-orphanded-foriegn keys are created when appending a new record across multiple tables. Is there a way to prevent this from occurring in the first place? Extra Info: All relationships across at most 3 tables are one-to-one. Cascade updates and deletes are...
  4. kellyputty

    Can Update and Delete records can't Insert new ones???

    Wonderful, I thought it might be something like that. However, I created this form thru the form wizard. How does one do the above via a form generated by the wizard. Best, KellyPutty
  5. kellyputty

    Can Update and Delete records can't Insert new ones???

    Yes, ClientID is autonumber and the foriegn keys (ClientID in all other tables are number, long integer)
  6. kellyputty

    Can Update and Delete records can't Insert new ones???

    SELECT Clients.ClientID AS Clients_ClientID, Clients.LastName, Academics.ClientID AS Academics_ClientID, Academics.CurrentlyEnrolled, Tribals.ClientID AS Tribals_ClientID, Tribals.TribalAffiliation, Vocations.ClientID AS Vocations_ClientID, Vocations.Carpenter, Carpenters.ClientID AS...
  7. kellyputty

    Can Update and Delete records can't Insert new ones???

    For some reason when appending a new record, if I don't add a value to every table involved with the form. The empty tables when later given data will cause the tables that were given data previously to contain a Null value fortheir foreign key field. This is why there are issues appending...
  8. kellyputty

    Can Update and Delete records can't Insert new ones???

    Why if your query can perfectly update and delete records would I have problems inserting a new record. (multiple tables, all one- to- one relationship)
  9. kellyputty

    inserting records from a form "how-to" update foriegn keys

    I think I have to write some code to get my form to automatically enter the correct foriegn keys in my tables. I am new/rusty on VBA. Is there a built in way to do this? If not, does anyone know of an Access VBA online (free) tutorial?
  10. kellyputty

    Update Query across 3 tables (one -to - many)

    The following tables: Clients: ClientID(P autonumber)*** LastName FirstName SSNum AcademicEducations: ClientID(F , number, long integer)**** HighestObtained AcademicEducationsID (P autonumber) Institutions: ClientID(F , number, long integer)**** Where StillAttending InstitutionsID(P...
  11. kellyputty

    Advanced Access Tutorials

    Anyone know of a site with free tutorials preferribly at the intermediate level?
  12. kellyputty

    How to Validate DataGrid cells?

    I am displaying records using a data grid from VB6. I allow the user to edit individual entries. I would like to add user error control so that: Record: Field1: Account Field2: Balance Field3: MinBalance If the user wanted to edit the Balance but put in an amount lower than the the...
  13. kellyputty

    VB6 w/ Access: Error Question

    Never mind, in another area I closed the connection and that is why I was getting that error. Oops! Thanks, Kelly Tessitore
  14. kellyputty

    VB6 w/ Access: Error Question

    sure: Private Sub Form_Load() Set conMB = New ADODB.Connection Set rsCustomer = New ADODB.Recordset Set rsCustomerAccount = New ADODB.Recordset conMB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Persist Security Info=False;Data Source=" & App.Path & _...
  15. kellyputty

    VB6 w/ Access: Error Question

    I get the following error message from my VB interface when attempting to change an entry in a textbox (Balance): Binding Collection Error: Field not updatable, Bound Property Name: Text, Field Name: Balance I think it either has to do with the text box itself (it is not locked) or the...
  16. kellyputty

    .Move or some other method to a specific recordset?

    Is there some sort of move method in which I can move the pointer to a specific record at run-time? Here is my problem: Table1:Customer CusterID LastName FirstName ..... Table2:CustomerAccount AccountID CustomerID Many-to-Many relationship: Many customers can have Many accounts...
  17. kellyputty

    filling a data combo control from database table at run-time

    I am stumped. If I use a literal string in my SQL query below I get the correct result. If I use the value in a textbox, I get nothing. Not sure why. Below: if instead of what I have in bold I insert 1001009, my dbcAccountID populates correctly, but not with txtCustomerID.text. Any...
  18. kellyputty

    VB6 Crashes once w/ every compile --then works

    Nope. -KellyPutty
  19. kellyputty

    VB6 Crashes once w/ every compile --then works

    My program crashes once with every change I make but then seems to work fine until the next change??? Any thoughts? KellyPutty
  20. kellyputty

    Custom datat types with ACCESS and VB6

    Skip this last question, I took out all formatting in Access. It doesn't belong there anyways. Kelly

Part and Inventory Search

Back
Top