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
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...
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
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...
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...
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
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...
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
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...
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...
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...
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.