Search results

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

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

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

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

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

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

Hi All, I have searched for this on the forum and found a few threads on the subject, however I still can't seem to get this to work in my database. I would like to view a report 'DailyLog' based on criteria selected on form 'DateTrainerPicker'. I would like to search by employee name and/or...

Hi all, Is there any way to set the preview of a report so it appears as a two page view and to fit? Many thanks Cathal

Hi All I am working on 'daily register' database. I have a form where user presses a 'Start time' button and it updates the form with the current system time another button updates the finish time and the total hours for the day are displayed in a text box. Is there anyway that I can stop...

Each employee has their own database containing a table of log in and out times. The main database links to that table in each of the employess databases, a UNION query compiles all these tables. Is it possible to have a create relationships with linked tables?

Hi Everyone I'm not too sure if this request is a query issue or not so please excuse if this is posted in the wrong section. I am creating a database that picks up the start and finish time of each employee and displays the total hours worked by day and week. I would like to be able to...

Hi All, me again, now that I've got over the working hours hurdle I'd like to sum by week. I'm quite new to access so please excuse my simple questions. My fields are: LogID {EmployeeID&Now()} EmployeeName StartTime {date&time} FinishTime {date&time} I have created a query to give me the...

Hi ther, I wonder if someone could help me with what I am sure is simply code, I just can't seem to get the response I want. :confused: I am working out each member of staffs working hours for the day. [Start Time] [Finish Time] minus a 30 min lunch. I would like to display the total hours...