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!

Register Log in
  • Congratulations Chriss Miller 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: tar28un
  • Order by date
  1. tar28un

    Multiselect list box

    hi there many thanks for reply
  2. tar28un

    Multiselect list box

    Hi there, I have a form which has a multiselect list box. now the rows in the multiselect list box are filtered from a table based on a parameter. Now that is working fine. Now i want to filter the data further and want to have two parameters instead on one. the first parameter value is...
  3. tar28un

    IMPORT XML

    Many thanks It is working
  4. tar28un

    IMPORT XML

    Many thanks It is working. I have one more question if you can help with. When I import any file manually , I have one option to choose to say to append the data in the existing file. How I can use that with importxml command. thanks
  5. tar28un

    IMPORT XML

    ..."C:\Year 4 Results 850" & i & "new" & s & ".xml", acStructureAndData Next If i > 2000 Then str = "insert into result select result1.* from result1" DoCmd.RunSQL str sql1 = "drop table result1" DoCmd.RunSQL sql1 sql1 = "" End If sql1 = "drop table aspect"...
  6. tar28un

    IMPORT XML

    Hi there, I am trying to import nearly 150 xml from my folder to an access database. For that I have written a code to import the files in . Now as the files names contains no. and they are next to each other. Now suppose if the file names are 1, 8, 45, 78 and 90. I am running a counter from 1...
  7. tar28un

    importing xml files into access

    I m using access 2003 and I have found a method to import data. It is via using ImportXML method. Many thanks
  8. tar28un

    importing xml files into access

    Hi there, Can somebody help me with importing xml files into access via some vb or sql code. I have 300 files to import in access. Many thanks
  9. tar28un

    importing xml files into access

    Hi there, can somebody help me with importing xml files into access database via some sql or vb code. I have nearly 300 files to import and its hard to import them one by one. Many thanks
  10. tar28un

    Exporting into Excel

    Hi there, I am trying to export an access query into excel. If I try to do via File -export, it works fine as I can select the save formatted check box and it saves all my formatting into the excel file. But If I try to do it via VB code and use. DoCmd.Outputto command, it dont save my formats...
  11. tar28un

    openrecordset

    Hi there, I tried your code as well. But now I m getting the error: The expression you entered refers to an object that is closed or does not exists. I m not sure where I m going wrong
  12. tar28un

    openrecordset

    ...for the reply My code now looks like this: Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim qry1 As String Set dbs = CurrentDb qry1 = "select * from pupil where((pupil.provider) = " & InputBox("Enter the Provider Id") & ")" Set rst = dbs.OpenRecordset(qry1, dbopendynaset) Set...
  13. tar28un

    openrecordset

    ...I am trying to run the following code Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim qry1 As String Set dbs = CurrentDb qry1 = "select * from pupil where(((pupil.provider) = [Enter the Provider Id]))" Set rst = dbs.OpenRecordset(qry1, dbopendynaset) Set Me.Form("subf").RowSource = rst...
  14. tar28un

    Importing excel files

    Hi there Many thanks for the reply. I will try that Thanks
  15. tar28un

    checkboxes

    Hi there, I have been given a problem to solve in a database. I m not sure which way to proceed , so I am posting this in the forum. My department looks after a lot of nursery providers in a specific area. Now after every 4 months we receive a form from them saying the no. of children they look...
  16. tar28un

    Importing excel files

    Hi there, I am trying to import excel files in access via the following code: CD.DialogTitle = "Select any one of the NOR files and press OPEN" CD.ShowOpen FileName = CD.FileName DoCmd.TransferSpreadsheet acImportDelim, , "tbl_Nursery_Schools+Units_FT", FileName, True I am running this code to...
  17. tar28un

    How to Limit the no. of pages a report should print on

    Many thanks Tom, I will give it a try and see what comes out. Regards Sarika
  18. tar28un

    How to Limit the no. of pages a report should print on

    Many thanks for the help I would be very grateful for the code
  19. tar28un

    How to Limit the no. of pages a report should print on

    Hi there, I am creating a report which is grouped on some provider no. and based on these provider no. its picks up the details of pupils who are attending that provider,s nursery. Now for each provider the no. of pupils who are attending the nursery is different. Some has got 15 but other...
  20. tar28un

    Layout of the report

    I am very sorry. I actually want to say report. Is it possible to refer to particular field values in a text box or label in report

Part and Inventory Search

Back
Top