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 strongm 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: *

  • Users: rjm13
  • Order by date
  1. rjm13

    Linking through ODBC

    Problem solved! Re-linked that last table! Thanks for helping me through this, I owe you a beer RJM
  2. rjm13

    Linking through ODBC

    Hey Darrylle The Subform/Table setups are the exact same. Here is another twist. If I look at the table entries in ACCESS the records are there, If I look at the table in MySQL the records are not. And this is a linked table! How is this possible? Thanks again, RJM
  3. rjm13

    Linking through ODBC

    Hey Darrylle, Thanks for getting back to me, I am linking to mysql with an ACCESS front end. I have a form that has a couple of subforms. Your suggestion of adding the time stamp field to the main table that the main form derives from helped. 3 of my subforms work and one does not, it is...
  4. rjm13

    Linking through ODBC

    You know what, I thought that would be the solution, but after working with it, I'm still having the problem, Anyone else out there got a suggestion? R
  5. rjm13

    MySQL and ACCESS

    Hi All, I have a database I set up using MySQL. In my main table I have the Primary Key field set up as autoincrement and this field is then used as a foreign key in another table there is a one to many relationship. I am working with ACCESS as a front end, I am having problems with the...
  6. rjm13

    One to many

    That works! thanks Leslie... are you a guitar player? (lespaul) Thanks again,R
  7. rjm13

    One to many

    Hi all, I have two tables I am working with, a Course table and a Targeted Audience table ONE to MANY. In the many table I have a foreign key field and a TargetAudience field. Can anyone think of a way to query this where I end up with one row for each courseID and the values from the...
  8. rjm13

    Linking through ODBC

    Hi folks, I have a database, Frontend is ACCESS and the backend is MySQL. I am having no luck with autonumber fields. Does anyone know how configure the fields in both so that autonumber fields are compatible between the two databases? Any help is greatly appreciated! Thanks R
  9. rjm13

    Requery on a subform

    Thanks REMOU! Thats what I was looking for. I was using the DoCmd Requery and having no luck at all! Your way is much easier..... Thanks again. R
  10. rjm13

    Requery on a subform

    Hi All, I have a subform, that has two list boxes on it. What I want to do is on the double click action of the first list box to cause a requery of the second list box. I am having no luck with the syntax. I have tried many combinations of the subform and object name without any luck. I keep...
  11. rjm13

    ODBC Link with access

    Hi All, I am trying to link through ACCESS 2000 to a couple tables in a foxpro 2.6 database. I'm getting a message that I don't have the right driver. Does anyone know what I need to do to make this connection? Any help is greatly appreciated. R
  12. rjm13

    Query Criteria

    Thanks Greg, thats what I needed. R
  13. rjm13

    Query Criteria

    Hi all, I have something I think should be simple, but I can't figure it out. I have a query in access that I developed in the query grid. For the Name field I have criteria that checks a selection made on a combo box on a form, that works fine, the problem is that I want the query to return...
  14. rjm13

    Access Query Criteria

    Thank you all very much for your help. This is going to save alot of time in the future! R
  15. rjm13

    Access Query Criteria

    Thanks Leslie, What I would like to do is just be able to put syntax on the criteria line in the access query grid. the value I have in the table currently is G6*, because I only want records that start with G6 in each query. So can I reference that field in the table on the criteria line like...
  16. rjm13

    Access Query Criteria

    Hi All, I have a query in access and I am having trouble with the syntax for the criteria. What I want to do is reference a field in another table. The table only contains one row with one value (I have about 20 queries and want to be able to just change tthis value once in the table and have...
  17. rjm13

    Running a Make table query

    Hi all, I usually don't use macros and therfore I am not too familiar with them. I am trying to create a macro that runs several make table queries. Is there any way to have the macro say "Yes" to delete existing table, and "Yes" to I want to paste however many rows to the table, without having...
  18. rjm13

    Combining records in a single table

    Thanks PHV, with a little tweaking, that worked out just fine. Thanks again R
  19. rjm13

    Combining records in a single table

    Hi All, I have an issue that I don't know how to resolve (and don't know why it was done this way originally). I have a table with an identifier field (contract number), Service Category, a value field, and then a field that has a value of either "clients" or "Encounters". What I need to do...
  20. rjm13

    Reports formatting

    I moved everything into header 1 and 2 and took the check out of Keep Together. It helped but really still does not work. Header 1 and header 2 are separated on a number of pages. Is there anything else?

Part and Inventory Search

Back
Top