Transport Managment Db

May 24, 2007

Hi People, great forum and loads of info to keep me going.

just a quick question

i have created a vehicle managment db, with a list of all our vehicles and there information such as tax due date, MOT Due date and copys of log books and MOT Certs,

what im wondering is, can i create an alert so it will alert me either by email or by a pop up box or maybe a printed document telling me a few weeks before the MOT or tax is due, i'm only really basic with ACCESS and im using the new 2007 version, the forms etc work fine and i have no problems with trying things out

maybe one nice person could point me in the right direction

thanks

Stu

View Replies


ADVERTISEMENT

Designing A Stock Database Managment System (DBMS)

Nov 18, 2007

I am student, in high school, and I have to make a stock database, for ITGS, so as to receive my IB diploma.

I have created forms so as to enter stock information, and customer information, but I have no idea, as to how to connect them, so as to create an order summery and invoice. I started by creating 2 tables, one for the books, and one for the customers. I then made 2 other tables, one being an order table, and the other the linking table between the order and the books (see relation.jpg). I created a form so as to input information, but I can’t seem to get it to work, (see form.jpg)

Ideally, I would like the end-user, to select the customer's name, from a drop down list, and then for the rest of the customer information to update automatically, then, for the end-user to select a date, and finally the end-user to select books from the stock. Once the end-user has finalized the selection, they would ideally press a button, which would automatically print out an order summary/invoice (Maybe a report?)And that would also automatically reduce the quantity of the books in stock by one.

I have no idea as to how to do this and I would really need someone’s help, seeing as I have less than a week to hand this in by (The deadline is Monday 16th November 2007)

Here are the images
form.jpg - http://img30.picoodle.com/img/img30/5/11/18/f_formm_78d6ea7.jpg
relation.jpg -
http://img03.picoodle.com/img/img03/5/11/18/f_relationm_6280f62.jpg

Thanking you in advanced
CJ M

View 1 Replies View Related

Modules & VBA :: Possible To Transport Variable From Access To Excel?

Aug 7, 2015

I have some shapes to be automated in powerpoint (Tables, Pictures and Charts). Each and every shape has to be created on basis of some reports (all excel files with a Dyno-Static Filenames: "Some Bond TE 1-29-2015.xlsx", "Scenario Analysis GSB 28th Feb 2015.xlsx"). Dyno-Static Filename: Filename having some part static and some part variable in it.

So I created a table with a list of file names (report names) with wild cards on it. Like "Some Bond TE*.xlsx", "Scenario Analysis GSB*.xlsx". I am opening these files using the following code from Access:

Code:
If Not IsWorkbookOpened(Dir(CurrentProject.Path & "Received FilesFiles" & SlideNshapes!Shape_File)) Then Set SourceFile = Excel.Workbooks.Open
(CurrentProject.Path & "Received FilesFiles" & Dir(CurrentProject.Path & "Received FilesFiles" & SlideNshapes!Shape_File), ReadOnly:=True)

There is no problem in Access Part. Now I come to my current problem. I am planning to have an attachment field (excel file) to store a table layout model identical to the powerpoint table (shape) to be automated.

Suppose:
The powerpoint table is like the following:
Rates Wtd Dur
US2Y 0.34
The Attachment Layout:
Rates Wtd Dur
US2Y =FilepathfromAccess!Sheet1!M24

There are so many cells to lookup on different excel files. The Following are the questions:

1. how to passs an access variable to a formula in a excel sheet?
2. How to refer only the opened sheets in an excel formula?

View 1 Replies View Related

Queries :: Getting Transport Rate Based On Date Ranges Due To Fuel Price Floats

Jan 1, 2015

I have tried search through some forums and but still not able to get desire results.

Table Customer Agreed Transport Rate
Customer > Eff Date > Route > Rate
A > 1 June 2014 > AAA > MYR 99
A > 15 Aug 2014 > AAA > MYR 88
A > 1 June 2014 > BBB > MYR 77
A > 1 Sept 2014 > BBB > MYR 66
B > 5 June 2014 > CCC > MYR 88
B > 20 Oct 2014 > DDD > MYR 100
C > 1 Oct 2014 > EEE > MYR 222

If there is order from Customer A for Route AAA loading on 2 July 2014, I can easy to get answer "MYR 99".

How if I wish to make Route as primary key? (as I understand, Primary key must be unique and no repeat).

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved