I believe my situation is similar to thread767-1136986. I have a cross-tab that is giving me the status of records in a special sort order (@my order) that I made; and I want only one status, that is DISPOSED records for the last year only. Here is what I have so far; the last else if gives me...
Would like to create a catalog of items in db where total items are in excess of 13,000. For instance, inventory database lists all computers within department. Would like to make a catalog listing of particular types of computers and the total count of each--ie, Dell Optiplex GX450 is a model...
Being new to Crystal Reports I am trying to understand what was just said:
If I want a total count of records instead of any details contained in the records themselves, which formula would I use? For clarification, I have 13,0000 records that contain information by region and status. I want...
You Said--You may need to upgrade the MDAC components--Howq or where do I go to update the MDAC--and did you say that will cure the problem or Access2000 is the problem regardless and updating MDAC won't cure the problem?
Okay--I think I understand better now--I have two separate tables, one named Tech and one named Vendor. The database in each table is named the same also. The Combo box is in two separate frames--cboTech and cboVendor. In Frame 1- Clicking on cboTech--you get a drop down list of all our tech...
Single table-Access 2000;
DAO control; followed coding from address/phone book.
Here is code:
Private Sub cboTech_Change()
datTech.RecordSource = _
"SELECT * FROM Tech WHERE TechSupport ='" & _
cboTech.Text & "'"
'datTech.Refresh...
I designed it full screen not realizing about resolution settings, etc. It is a one page purchase order form. I can break it into two or more forms--one for vendor's address, one for ship to address, etc., but don't know how I would keep that data together and then have a "preview"...
I have a combo list box (vendors names) that when vendor is selected would like remaining data from database (address, phone, city, state, etc)., to fill in labels on form for thaqt vendor. Have looked at a few other and "made" my dat the same,etc, but it just doesn't seem to work for...
Loaded Crystal Reports that came with my VB for the first ime (didn't know it was there--VB6). Opened it up to "get a feel" and tried to load a couple of Access 2000 db that I have for other projects in the report wizard--it asks me for the db password--none of these db's are password...
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.