On a separate screen the user inputs search criteria
and the records are displayed in a listview. Then the
person chooses a record to view on this screen. The
SQL and the itemindex are passed to this screen.
This screen creates a NEW recordset with the same SQL
as the prior search criteria...
I have two databases originally written in Access 97 which I converted to 2000 and now 2003. One contains the code and forms and the other contains only the data. The data is linked. We have converted the two files and they work fine in mdb format, but not when running the mde. I have...
I've got a program I'm writing which brings up a Corel 8 file for dialog about a family (it could be pages long). This file is linked to a family which has a sequential number so the file is named something like fam01, fam02, etc to correspond to the family. When accessing this file outside of...
I have a form that performs a search based upon various criteria. Multiple searches may be performed one right after another. It searches on name, social security number and / or date of birth. The date of birth is a TMaskEdit. It works fine if there is no data put into the DOB or if data IS...
I've created a Query which I plan to expand to use 2 databases using thread 102-383313 as my model. I'm getting errors and trying to track down from what so I've simplified the SQL to what you see below which only uses one database. When I remove the:
from ":DVFacts:caa44240"...
I'm using a TQuery for the Lookup AND Data. I tried using FAQ102-1212. In FAQ102-1212 the only reference give to using a SQL is the SQL:
Select OrderNo, CustNo, EmpNo, SaleDate, ItemsTotal from "Orders.db" Orders.
It worked fine with the Lookup as a Query, but won't work with the Data...
I've got some DBLookupComboBoxes that I'm using to add new records. When I close the form used to add records, next time I open up the form the old values are still there. When it's used the first time, it's blank and I'd like one to come up blank and one to have a default value. When I've...
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.