Search results for query: *

hi there many thanks for reply

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

Many thanks It is working

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

Hi there, I am using the follwing code: For i = 2000 To 4000 On Error Resume Next For j = 1 To 50 If j < 10 Then s = "00" & j & "" Else s = "0" & j & "" End If ImportXML "C:\Year 4 Results 850" & i & "new" & s & ".xml", acStructureAndData...

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

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

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

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

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

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

Hello Many thanks 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...

hi there, 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...

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

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

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

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

Many thanks for the help I would be very grateful for the code

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

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