Search results for query: *

Hi all, I have a dataabase that contains orders of products. I have a report that will show for any given month the number of order and deliveries for each day. To do this I have seperate queries that count the no of orders, deliveries and cancellations on each day. I then pull these queries...

I will try and make this as clear as possible. Basically I have a databast that tracks orders and ultimately deliveries. I would like a query to show the activities on a range of dates. My orders table holds the order date and the delivery date. However I need to produce a report that will show...

Help please! I am trying to create an application for our organisation that will allow people to book onto various courses. I have created following tables; 1/ Employee records 2/ Courses - courses that are available, date, time, location, MAXIMUM NUMBER OF SPACES 3/ Bookings table, contains...

I am using the code below to run a report every wednesday, I would really like the report to run every Wednesday and Thursday at say 19:00 hours. Any help as to how to ammend this code would be helpful. dim MyDate,MyWeekday static bSent as boolean MyDate=Date MyWeekday = Weekday(MyDate...

I have a database that links across our network into other databases. It links to the same table in each 'networked' database so therefore I have eight linked tables in my master database. Each table has exactly the same properties and field names. My question is this: Is there anyway that I...

I have a Control Tab on a form that has three pages on it. On my first page I have a check box that is called finance, I also have a corresponding page on the tab control called Finance. Basically I want to make the finance page become enabled or disabled depending on whether or not the finance...

I have a form where the user has to pick out a salesreps code. I have the combo box working just fine so that they can do this, I would like to create a text box next to the combo box that will display the reps name rather than the code. I imagine I would have to use some form of lookup but I am...

Hi, I am trying to create a report that will need to pull data from two queries. Basically the report is monitoring the results of enquiries made to our business. I have two tables one table contains details of the original enquiry ie what product they were interested in etc the second table...

I am trying to setup an apllication that allows users to make reservations to one of two bays on a certain date from a set number of time slots. I have a table containing customer details and one which contains details of bookings. I am trying to create a form where new bookings can be entered...

HELP! I am trying to create a database that deals with reservations. Basically I have two bays that can be reserved at different times of the day on different days. I am not sure how to handle this so that a user can see current reservations and is prevented from making a reservation where a...

Can anyone supply with me some code that will enable me to send an email to a supplier when the suppliers email is held in a supplier table - Basically i want to put in the supplier code in the orders table - hit a button and the data shown on the form will be sent to that supplier.

I am building an application that logs calls. I have a form where individual calls are logged as and when they are taken. I need to somehow get the application to e-mail the person who has logged the call with all the details that have been logged. Ideally I would like this to run off a button...

I am building an application that logs calls. I have a form where individual calls are logged as and when they are taken. I need to somehow get the application to e-mail the person who has logged the call with all the details that have been logged. Ideally I would like this to run off a button...

I would describe myself a somewhat of a novice to Access however i think I can do the basics(tables, queries etc.) I would like to start learning how to use more VB code in my applications and was wondering if anyone out there can recommend a book that would be suitable for somone of my level? Mike

Help, Is there a way of e-mailing an individual record that is currently being displayed on a form? Mike

I have a report that is based on a query that I need to be mailed to different individuals based on criteria held with in the query. Is there any code that will enable me to send the e-mail basing the code around an if statement? Mike

I am looking to use a Crosstab query as the basis of a report - however I am worried that the form will not show all the data(particaularly the columns) when the query has run and an new column has been created - is there any way around this?

I have a table where calls are logged - it has a Unique ID no which is set as the Primary key - I would like this or another field to be of a certain format made up of the Month number and the ID - so for example a call in January would be 010001 or in December 120010 etc etc id there anyway of...

Can anyone help?, I am trying to run a macro in Access that will automatically send an email every Wednesday only once. I have written the following code to run the macro however I am stuck trying to automate it. Dim MyDate, MyWeekday MyDate = Date MyWeekday = Weekday(MyDate...

Hi, I am trying to get Access to send an e-mail on a certain day of the week automatically. I have written the code as follows; DoCmd.SendObject acSendReport, "Support Request Log Query", acFormatSNP, "Mike Harris; Julia Berry", , , "Pending Report", , , False...