Search results

Hello, I think I am sorted for now. I used DoCmd.TransferSpreadsheet instead. I will look into using OUTPutTo some other time. Thanks a lot. TY

Hi Trevor, I have tried what you suggested but I just got an error message saying "Microsoft access can't find the field "|" referred to in your repression". Where do u think this is coming from? thanks. I've checked everywhere but cant figure it out. thanks

yes i have used the wizard. and what i want to do is to send the subreport to the worksheet. the main report just houses the sub report thanks

Hi Trevor, I am exporting just the main report name. am using a query to feed the report am not using a macro. the code is just behind a command button and my version is 2003 thanks

Hello all I have a report with a subreport which I want to export to excel. problrm is, it is exporting just one line of the data. When I preview the report, it contains all the information I need but in the excel sheet, it contains just the first line of the firstpage of the excel sheet. Is...

Hi i have modified the code as follows and now works fine...cheers Dim strIn As String Dim rst As DAO.Recordset Dim strSQL As String Set rst = Me.RecordsetClone Do Until rst.EOF strIn = strIn & "'" & rst!ChildHSReferenceNumber & "'," rst.MoveNext Loop If Right(strIn, 1) = ","...

Hello All, I am trying to run this code: Dim strIn As String Dim rst As DAO.Recordset Dim strSQL As String Set rst = Me.RecordsetClone Do Until rst.EOF strIn = strIn & rst!ChildHSReferenceNumber & "," rst.MoveNext Loop If Right(strIn, 1) = "," Then strIn = Left(strIn...

Thanks BOBLarson. I have tried to use this code but i am getting an error message: "Too few parameters. Expected 14". my Query has pulled up 14 records so I guess that where it gets that number from. What should i do? Thanks

Hi, messing with the system registry is quite scaring to me as I have not really worked with hardware for a while. I'll see what i can do anyway. I have read about setting the security level to low. whats your take on that?? I know it says not recommended unless you have virus scanning...etc...

no each user doesnt have a copy of the front end. they are accessing it from the shared drive. Guess i should do that right? I'll get back to you

any help on this pleeeeeeeeeaaaaaaaase??

yes i have done that

hello all, I am building an application that is supposed to run from a shared server. I am about to conclude the development but I am not sure how to release it for use. I have created the startup options and copied the application to the shared server but when the other users open the...

yes. I have selected some records from by table to display on a form based on some criteria. then I want to check all the checkboxes for the records on the form. or if easier, update the particular field in the table to yes for all the records which have satisfied the criteria and showed up on...

Ok I reran the query and it works a bit now. however, it will only check the box for the first record shown. how can i make it loop thru and check all the records selected by the query? thanks

Re: check box problem... The check box is bound. however, it only checks the first check box if there are a series of boxes to be checked. how can i make it check all the boxes for all the records selected by the query?? Many thanks

Re: check box problem... Brilliant thanks. i place the same code in the check box click event formerly. now i've put it in the form's current event-- works perfectly. thanks a million

check box problem... Hello all, I have just hit another problem. I have a checkbox on my form which I am using to set the back colour of a label on the form to specify some information. when I click the check box on one record the same back colour shows thru all the records whether the check...

yeah thanks. did some thing like that already, but didn't use a macro. thanks a million

Hello All, I am working with a form which has a combobox with which I display all the addresses on my system. The user is able to search thru to find an address. If the address does not exist, the msgbox pops up asking if the user want to add the new address. If the user says yes the a new form...