Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Lxmm
  • Order by date
  1. Lxmm

    Help with SQL

    Many thanks for your help.
  2. Lxmm

    Help with SQL

    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...
  3. Lxmm

    Enable datagrid row

    Hi, Is there a way to enable a particular row in datagrid for editing? Also is there a way to enable certain cols. of the selected row? Thanks
  4. Lxmm

    Help with SQL Select

    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...
  5. Lxmm

    Vb.NET Crystal Report query

    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...
  6. Lxmm

    Unable to connect to any secured access database

    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...
  7. Lxmm

    UDL/Access 2000 Error

    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.
  8. Lxmm

    VB Crystal Reports and Access 2000

    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...
  9. Lxmm

    Open Access table Exclusively

    Many thanks for the info.
  10. Lxmm

    Open Access table Exclusively

    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
  11. Lxmm

    Crystal reports database path

    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 -...
  12. Lxmm

    Crystal reports database path

    Hi, Is there a way to configure crystal report to work on any machine? (how to get machine or db server name to crystal report dynamicly)
  13. Lxmm

    change rteport path in vb.net

    Hi, Is there a way to configure crystal report to work on any machine? (how to get machine or db server name to crystal report dynamicly)
  14. Lxmm

    Drag and Drop

    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...
  15. Lxmm

    DataSet, DataTable and DataGrid

    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...
  16. Lxmm

    Table to XML

    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
  17. Lxmm

    DateTimePicker Question - pls 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...
  18. Lxmm

    Listview row colors

    Thank you.
  19. Lxmm

    [b]Access Index field[/b]

    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

Part and Inventory Search

Back
Top