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!

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

Recent content by magicscreen

  1. magicscreen

    Combo Box creates duplicate records in a table

    Thanks again for your help. I am in a learning curve and you saved me hours of trial and error.
  2. magicscreen

    Combo Box creates duplicate records in a table

    Thank you for your help in this matter. This is exactly what I wanted. I had some minor issue trying to place the Apartment combo box on the form with the SubfrmContact beneath it. When I went to Formview the combo box disappeared. It was too close to the top of the form. When I lowered it...
  3. magicscreen

    Combo Box creates duplicate records in a table

    I loaded a shortened version of my .accdb file into Mediafire. Folder Name" Access 2007. .accdb file in the folder. Link: http://www.mediafire.com/?49fjs6djyaeh5 http://www.mediafire.com/?49fjs6djyaeh5
  4. magicscreen

    Combo Box creates duplicate records in a table

    Access 2007 I want to populate a form with fields from a Combo Box. I have a table that has a contact list with information for an apartment in an apartment house. I have a second taple that has one record for each apartment in the house that has a problem. There are no duplicate apartments...
  5. magicscreen

    Cannot save record

    I forgot to tell you that I have a Twitter link as magicscreen2010 and this is where I think I set up the file sharing. I put the entire database in 4Shared.
  6. magicscreen

    Cannot save record

    TheAceMan1, thanks for your help. I fixed the issue with the following code: I first filled form with the the compound key fields. I then did a Refresh to save the record with key fields and another field called Hours. I then created a record set and did an "EDIT" so no new record would be...
  7. magicscreen

    Cannot save record

    I am using windows 7 64 bit 8 gigs of memory Access 2007 I am developing a tracking system I have a main form and can have one or more employees woring on the problem I created a continuous subform using a table named tblEmployeeAssignment. One of the fields on the form is a combo box that is...
  8. magicscreen

    Access 2000 Recordsets

    How do I pass a DAO recordset as a parameter to a function in Access 2000? Thanks
  9. magicscreen

    Field is not known error

    Running a report to the web using a SQL2000 query to get the information. I am using ASP to get the results to the web. It used to work but now I get the following: An Error has occured on the server in attempting to access the data source. -2147191858: This field is not known. Any ideas...
  10. magicscreen

    Passing recordsets to Crystal Reports 8.5.

    How do I set up a ttx file for Crystal Reports in order to pass it a recordset? I would like to get the data in a vb 6 program and then pass the recordset to Crystal Reports 8.5. What is the structure of a ttx file and what are the valid entries?

Part and Inventory Search

Back
Top