Search results

I am having the same problem. Thing is i need to export the column headings to the first row, but of course do not want ' appearing at the front of every ofhter cell. Anyone know of a workaround for this ? TIA

AHA - Just realised what i have done. I am trying to compare 2 lists, but my first list box ONLY show staff selected and is based on a query. I therefore have to pull the staffid from the hidden id column and cycle through the new list and highlight the respective staff member. Incase anyone...

Wow, thanks for the rapid reply ! I am having a bit of trouble in how to do this as I am quite new to VBA. I have modified the code as follows: [code] Dim frm As Form, ctl As Control Dim vItem As Variant, thisvItem As Variant Dim thisfrm As Form, thisctl As Control Set frm =...

Hi, I have a listbox on a form which is based on a query and shows how which staff members are associated to the client. I have added a button which opens a form and would allow you to select additional staff to associate. This form comprises as multi-select list box showing all staff members...

Thanks for your response. I think i have some standard code for creating a recordset from a query, but can you tell me how i transfer this recordset to Excel. Please note I also need to be able to select a file location for this excel file. Thanks again.

I suppose on further reflection, what I am asking is: 1. Should i create a stored query temporarily, then run the outputTo command on that query. Then delete the query. This method allows me to select a filename if i use a macro to output to excel. 2. Alternatively is there a way that I can...

[No message]

Hi, As you may have guessed by the sunject heading, i am trying to output the results of a query to excel. The query is dynamic ( build by vba depensing on form entry criteria ) and what i am finding is that if i use the following: DoCmd.OUtputTo acOutputQuery, txt_exportsql...

Thank you so much for your answer - really good of you - i was tearing my hair out !! Thanks again

[code] Private Sub Command83_Click() On Error GoTo Err_Command83_Click 'Dim MyDatabase As Database 'Dim MyQueryDef As QueryDef 'Dim where As Variant Dim sectorfilter As String Dim myfiltersector As String Dim qryname As String Dim secondqryname As String Dim rannum As Integer Dim staffid As...

Hi, When i run the following query on the SQL of the query generator i get the right results. SELECT contacts.*, contacts.sector, staff_to_contact.staff_pk, staff_to_contact.contact_pk FROM contacts INNER JOIN staff_to_contact ON contacts.pk_contacts = staff_to_contact.contact_pk WHERE...

Sorry, could you elaborate a bit please. Your help is appreciated.

Hi, Thanks for this. I will try this in the morning and let you know. Thanks again, Phil.

Hi, I am really stuck with this, so please someone help! I have results form a previous dynamic query saved as 'queryxxxx'. this query kicks out the following: id name company I am trying to re-query these results to show who this contact belongs to ( can be multiple users ). The...

Hi, I have a contact database which by selecting tick boxes additional forms appear with list boxes. there are currently 2 tickboxes/list boxes. 1 for industry sectors and 1 for client relations type. Therefore if a user ticks the boxes, ( as an example ) they can search for all companies within...

Thanks very much for your reply / advice. The date time stamp is a great idea - i'm gonna do a bit of searching around now for advice. Out of interest, seeing as I will have to store the query name as a variable anyway ( so i can go back and delete it after ) - would it not make sense to just...

Hi, I am currently generating a dynamic query based on form selections. The query then opens a form showing results. The user then gets the choice to export to Excel ( using macro ). A dynamic query is generated "dynam_qry" and used to show results and later export to excel. The problem is that...

Hi, not really sure what this procedure is called, so i shall try to explain it. I have 2 forms. 1 is a Timetable form which has text boxes for every 15 mins over a period of hours. The other is a list of customers, which is a continuos form and based on a query. What i want to be able to do...

Forget it - got it sorted. RTFM !!

Jack - yep DAO 3.6 is installed. Steve - thanks, that worked fine.. Cheers Guys for your help - really appreciated Phil.