Search results

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

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

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

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

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

I am trying to count the amount of records that have been updated from an update query.. ss = "UPDATE flights SET flights.departairport = [Forms]![flights]![txt_depart], flights.arriveairport = [Forms]![flights]![txt_arrive], flights.duration = [Forms]![flights]![txt_duration]...

hi, i keep getting type mismatch on the following code whilst trying to set a recordset as a query... is this possible or have i just got the wrong syntax ?? Dim rst As DAO.Recordset '(DAO.Recordset for 2000) On Error Resume Next Set rst = "SELECT ([flights].[departairport]...

Hi Rich ( or anyone ) can you please see previous message.. http://www.access-programmers.co.uk/ubb/Forum3/HTML/002304.html I was wondering if you could help again.

hi, i am using the between function to pull records from my rates table between txt_date and txt_date_to. It therefore finds all those records ok and displays them on a form, with "warning, you are about to overwrite exisiting data below". Hit the Proceed button and i run a delete query based on...

Hi, i am filling data between dates on a form. i.e. enter date from, date to, other data => fills table with 1/1/01 other data 2/1/01 other data 3/1/01 other data etc etc Someone ( Rich ) kindly showed me the best way of doing this with the following code. My problem is that if data already...

Hi i have a dataset of Counrties, Resorts in country, Hotels in resort. I have multiple entries for hotels in resort as each hotels' prices on a particular day are stored ( hotelname, date, price ) i.e. Alicante hotel 01/01/01 £99 Alicante hotel 02/01/01 £89 Alicante hotel 03/01/01 £59 When i...

Hi, I am trying to insert a set of data which is entered from an unbound form into a table. I want to enter a From: date and a To: date and the by calculating the difference in days between the 2 dates, loop through an insert statement to enter the same data, but just adding 1 day to the date...

Hi, I am trying to insert a set of data which is entered from an unbound form into a table. I want to enter a From: date and a To: date and the by calculating the difference in days between the 2 dates, loop through an insert statement to enter the same data, but just adding 1 day to the date...

Hi, sorry if this is really basic to you all, but i am stuck and have searched and searched but to no avail. ( it would probably help if i knew exactly what to search for ! ) What i am doing is adding data to a table when a button is pushed ( code bound to button ) i have 2 unbound text boxes -...

Hi, I am running an SQL statement in VBA so that when a button is pressed, it takes the values from 2 text fields and puts them in a table in the correct fields. I can do this fine with 1 statement ss = "INSERT INTO [resorts](resortname) VALUES (txt_resort_name)" but this only inserts into the...

Hi, I am trying to add data to a table from a text box..i.e. enter the name into the text box and click the 'add' button - this adds the data to the table. It has to be an unbound text box, so it has to take the value of the textbox ( NewCountry ) and add it into the countryname field of the...

Hi, brain meltdown so help would be really appreciated !! I have a form with a single combo box on it which selects different countries. This form ( frm_countries ) has a subform which displays the data of all the resorts within that country. ( countryid, resortscountryid are linked ) fine and...

Hi, brain meltdown so help would be really appreciated !! I have a form with a single combo box on it which selects different countries. This form ( frm_countries ) has a subform which displays the data of all the resorts within that country. ( countryid, resortscountryid are linked ) fine and...