Can someone help me with the following query please?
Sample data
product date cat1 cat2 cat3 cat4 cat5
============================
00001 1/1/05 T F T T T
00001 1/1/05 T F F F T
00001 2/1/05 F T T T T
00001 2/1/05 T T F F F
00001 2/1/05 F T F F T
I want different counts of each...
Hi,
Can any one help me with the following query please?
I have 2 tables in my access table to store student admission and result details as follows
Master table
StudentID Name DateOfAdmission
==========================
000001 A. Jones 11/11/05
000002 J. Martin 12/11/05
000003 B. Norton...
I have a problem using parameters with Crystal reports.
I have a report based on Access query which is similar to something like following
"SELECT * from StudentMain where StudentID=ParaStudentID"
I have a crystal report which is based on the above query so that my users can print...
I'm having a problem with VB.NET and Access 2000 database. I cannot seem to connect to database if it has a database password. I try to connect through different ways with no luck.
First I created a UDL file and select Jet 4.0 as the provider. Then I pointed to the mdb file and typed the user...
Hi,
I'm having a problem accessing a secured access 2000 table.
Anyone know how to setup a workgroup information file as UDL file does not seems to accept the userid/password I set for the database.
Thanks in advance.
Hello all,
I'm having a problem with Crystal reports to produce reports from an Access 2000 table.
I have created the report within vs as follows.
Add new item -> utilities - > crystal report
Then I select my database using OLEDB(ADO) byselecting Jet.4.0
When I get to the connection...
Hi all,
Is there a way to open an Access 2000-2003 table (not the database itself) exculsively so that only one user can modify records at a given point.
Thanks
Thanks for your input.
I'm not sure how to create a generic ODBC entry - can you let me know how to do this please?
When using this method, can I use the reports as follows
lets say db and cr reports are stored on the file server
User 1 - db/report path mapped as F:\MyData\Reports
User 2 -...
Hi,
Can anyone help me with the following please?
I have a user control with few properties. In my form I have added this control 60 times.
Each control has a itemname, Item Location (1-60) and itemID properties. I want my users to change the location of items my dragging and dropping into a...
Please can some one help me with the following?
On my form I have a dataset which I want to use to store subset of 4 tables.
I have a DataGrid on the form which is bound to one of the tables in the dataset.
DataGrid1.DataSource = ds.Tables("mASTER")
How can I highlight the...
Hello,
Is there a way to create an XML file from VFP6?.
As far as I know there is no command to extract table into XML in Version6. However, I can create a EXE in version 8, but I'm not sure to called VFP8 exe from VFP6 application. Do I need VFP6 & VFP8 runtime libraries in such case?
Please help
Hi,
In my VB.net form, I have 4 DateTimePicker controls.
2 of these used to capture dates and other 2 to capture times.
i.e.
Start Date
Start Time
End Date
End Time
1. How can I set this control to capture times? I have changed the format property to 'time', but at run time, it shows as...
Is there a way to use an MS-Access index field in VB.NET?
I want to search the database (based on an Index field) and return record(s) if a specific record was found.
Thanks
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.