Recent content by rmcmorris

I tried using both a wizard and coding a button on my own with the same problem. I was able to fix the problem though by changing a setting in the data environment. Apparently, if the "OnetoMany" setting for the relation of the link between the parent and child tables is set to...

I have a form containing two tables linked as one-to-many. The form contains some fields from the parent table, and a grid from the child table. I would like to include navigation buttons which move the parent key. However, the nav buttons (using skip function) seem to only advance through...

Interesting tool, but not really what I had in mind. That tool would search for something, but we are trying to develop an informational tool which allows users to drill down into the data. We would accomplish this on a web server by running a query and building a web page depending on which...

>>Could you use a microsoft access db on a cd then query it with client side programming? << Query it how? You certainly can do that with ASP, but ASP requires a server to generate the HTML to be displayed for your query results. You could develop an Access application, but that would require...

We would like to develop a CD containing HTML pages with information about our services. Is it possible to use client-side queries to a database all on the same CD? I know how to create ASP pages with databases, but I do not think you can do that on the client-side. Other CD's we have seen...

What I have found is that the error occurs only if the search field is the first index key. If I remove all indexes from the Paradox table, the query will correctly return all matching rows. If I add a new key as the first key, then the query will also work correctly, returning all rows. For...

Hard to tell sometimes, but the quotes are correct with the apostrophe then the quote.

I have a VBA module in Excel where I am returning data from a Paradox database using ADO. Previously, the query would match a number variable. This worked fine and returned all of the records. Now I am changing the code to match a string variable instead on a different database field. When...

I have a VBA module in Excel where I am returning data from a database using ADO. Previously, the query would match a number variable. This worked fine and returned all of the records. Now I am changing the code to match a string variable instead on a different database field. When using an...

Actually, the connection works through Jet40. This is then integrated somehow through the Jet 40 Paradox driver with the Borland Database Engine (BDE) which is the control for Paradox tables. In the old Jet3.5, you needed to specify the location of the Paradox Network locking file, but...

I am attaching to a Paradox table. The search values all match exactly, there are no spaces. The query works correctly if I link to the Paradox table from Access and perform an Access query on the string field using the &quot;=&quot; operator. The query has the same problem using DAO rather...

I have a VBA module in Excel where I am returning data from a database using ADO. Previously, the query would match a number variable. This worked fine and returned all of the records. Now I am changing the code to match a string variable instead on a different database field. When using an...

I am running into a very similar problem. My query is only returning the first record, even though there are 30 records. I have found that in my query, if I use a numeric field, all of the records return, but if I try to match a string field, only the first record returns. I have found that...

Mike, My OS is Win2000 Pro. VFP 7.0 SP1. This most definately works on my system: RUN /N C:\Program Files\MyApp\MAIN.EXE Absolutely no quotation marks involved. In fact, If I had single quotation marks, and try to execute, I get this error: &quot;Run|! Command Failed.&quot; If I use...

Mike, Not using any quotes with the space also works for my system. I am using VFP 7.0 with SP1. Regan