Search results

  1. C

    Payments and Running Total

    Hi Everyone, I'm quite new to access and a bit of a newbie when it comes to databases in general so your help is greatly appreciated. I work in Medical Tourism and I am designing a database to collected enquires, bookings and payments and then automate the invoice. I have numerous tables but...
  2. C

    Filter combo box values based on checkbox value?

    Ah, I hadn't thought that far ahead. Makes perfect sense and will save me a lot of time redesigning forms in the future. Thanks John
  3. C

    Filter combo box values based on checkbox value?

    Thanks for your help John I have three variables that I want to filter in the combo boxes. User will select: Country they wish to visit Region they will be staying Hospital they want to visit There are a number of regions and hospitals but only three Countries. I could use a combo box for...
  4. C

    Filter combo box values based on checkbox value?

    Thanks John I hate to be a pain, I'm very unfamilar with building the code, how would this work if I had three checkboxes and wanted the values of the combo box to change depending on which check box I selected? Cheers, Cathal
  5. C

    Filter combo box values based on checkbox value?

    I know it is possible to have casscading combo boxes, is it also possible to casscade their field values based on the selection of a particular checkbox? How do I do this, I am very new to access and databases so your patience in explaining to me is greatly appreciated. Thanks Cathal
  6. C

    Selecting values from two fields and saving in one

    Hi Everyone, I apologise in advance if this question has been asked before, although I can find no threads similar to my problem. Any help you can offer would be greatly appreciated as I am not very educated when it comes to acces and sometimes struggle with some very basic stuff. I am...
  7. C

    Import Excel to existing table without duplicates

    Hi John, Thanks for you help, I'm not very familiar with working with DB's and a bit of a newbie. Can you attach the DB and Spreadsheet you mentioned in your post? I really appreciate your help. C.
  8. C

    Import Excel to existing table without duplicates

    Hi Everyone, I have a an excel sheet of member details pulled from another system. When new members are added I want to import these into the same table. If I do it creates duplicate values for members that were already existing. If I link to the excel sheet I get a criteria mismatch in my...
  9. C

    Problems exporting query to CSV

    Thanks DCrake, that makes sense, just didn't realise, bit of a newbie
  10. C

    Problems running query in form

    Hi Everyone, I have a table consisting of Name, Total amount spent and Total amount earned. I want a form that will query the amount earned and show all customers that have have over that amount. I then want to export to excel for upload to a bulk email system. I have done this with other...
  11. C

    Problems exporting query to CSV

    Hi Everyone, I am trying to export a query to a csv file for upload onto a bulk email system online. I have read the other posts here regarding how to do this and am familiar with the DoCmd.TransferText function. However I seem to be having problems creating the export specification. When I...
  12. C

    want to remove year of birth

    Hi Namliam Sorry I'm only getting back to your response now, the project had fallen off the radar due to other commitments. Thanks for the reply, it worked a treat and I now have everyone birth date separated in this years week number. Much appreciated, thanks C.
  13. C

    Export Subform to Excel

    Thanks MStef, took me a while getting there but it worked like a Gem in the end. Thank you so much! :D
  14. C

    Export Subform to Excel

    Please excuse me everyone for posting a question on a topic I know has been answered many times, I have read the threads but as I am new to Access and Code I'm finding all the advice a little confusing. Can anyone help me please... I have a members table containing the usual details including...
  15. C

    want to remove year of birth

    Want to sort by week of birthday date Thanks for your help Namliam, I have kept the original Year of Birth but wanted to order by week of birth, so have formatted the DOB field to display dd/mm. The problem I am having is that when I format into week number using DatePart it still takes into...
  16. C

    want to remove year of birth

    Thanks Bob, I'm quite new to access and wasn't familiar with the date part function so your link really help me understand some of the options available to me when working with dates. I have sorted all birthdays by week number. Next step that I have difficulty with is that I would like to...
  17. C

    want to remove year of birth

    I'm building a customer database and I want to directly market customers based on their DOB, i.e its your birthday next week, why don't you book your party with us. Year of birth is irrelevant so I want remove completly. How can I remove the year to enable me to sort by day and month without...
  18. C

    Export Report to Excel

    Thanks for you feedback
  19. C

    Export Report to Excel

    Hi All, I have a report that opens with filter criteria based on drop downs options on a form. Is there anyway to export that report to excel by using a button? I can export the original report based on the query but this is not filtered based on the criteria selected from the form. This...
  20. C

    Open report button

    Thanks Patty Thank you Patty, but this is not quite what I was looking for. Your code opens up both reports based on the employee and date. Which is helpfull, but I'm still having the initial problem with my date range. If I select range 03/03/08 - 04/03/08 it displays all the results...
Back
Top Bottom