Recent content by cathalfarrell

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

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

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

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

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

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

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.

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

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

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

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

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.

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

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

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