Search results for query: *

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

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

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

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

Hi there, I am wandering whethere is there is any way so that the layout of the report is designed first. Is it possible to give the textbox or a label a reference to a particular value in a coloumn say for e.g If I create 4 text boxes in a form. Can I refer the first text box to the first...

hi there, I am creating a cross tab query which is getting data from two tables . I am calculating count in my value field. Now everything is working fine except the fact that the query is not showing me the fields where the count is zero. I have used nz for that. Is there is any other way I...

Hi there I have got 3 subreports on a main report.These subreports are placed just one after another. with no spaces between them. But when I see them in print preview there are little spaces between them. I tried to put the bottom of one subreport = top of another.But it doesnt work. Can...

Hi there, can anybody help me with creating file/folder dialog box in access using VB code. IF you could help me with which control to use and how to code etc...

Hi there, I am working on a database where I have two reports. Both the reports need same type of data other then the fact that both have a different field on which they are sorted and grouped. Can I tell report1 to pick a query based on some different field and report2 to pick up some other.

Hi there, I am getting error in executing the following command .Can anybody help. I want to use the variable value as the filename. tablename = "file" str1 = "Create table" & tablename & "(URN int,Forename varchar(255),Surname varchar(255),Date_of_birth date,House_name...

Hi there, I am trying to create a small aplication which first ask the user to select some excel files which he wants to import and then import those excel files into access. My problem is that when the file gets imported into access, it dont have the proper datatypes. So what I want to do is...

Hi there, I am trying to calculate sum of two fields in a report. The other two fields are in the two different subforms in the main forms. I am wandering whether it is possible to calculate their sum into a text box into the main form.

Hi there, I am desinging a report and my page space is very restricted. What I want to do is to print some of the labels in vertical form so that they can fit in small space.I know we can do that in Excel but cant find any way to do it in access. Can anybody help

Hi there, I am designing a report in access and I am stucked on how to arrange the fields. I have got five fields. House number, extra address, street, townname, postcode Now what I did is insert all these fields into separate lines next to each. But if there is any field empty that rown comes...

Hi there, I am designing a form in access. And I want to give a message to user to Enter value if the user leave some required text box blank. Due to some reason I could not set the required property to yes. So In the lost focus event of the box I want to write code that will check for the...