Any Help Would Be Great
Oct 21, 2005
Ok people i appreciate this might me a bit long winded but ANY help would be appreciated.
i have a table called "Customer_Details" and i have 3 other tables calls
"tariff 1", "tariff 2" and "tariff 3".
The Customer_Details table has a form with the same name and on that form there is a field called "tariff" which is a drop down box with tariff 1,2 and 3 in it.
Also on the Customer_Details form is a Balance field which is linked to the same on the table.
finally there is a table called "data_live" this is continually added to on a day to day basis, the fields are : Acc No, Cost, Prod ID.
on the tariff tables each product has a product id
Basically want i want to do is on the customer form select a tariff, then when the data is entered into data_live the correct tariff is apllied to the product (via product id) then i think i am write in saying that i will be able to create a query that sums up all the prices for that customer (via Acc No) and displays the result in the Balance field.
any help at all would be great
many thanks
View Replies
Feb 28, 2008
here is the code I put in the OnExit of the InDate
If DLookup("[BeginDate]", "GroupEvent", "[In Date] >= [BeginDate] And [In Date]<= [EndDate]") Then
It works great BUT I need to get the Activity and Number field information from the record. I cannot use another DLookup cause it pulls the Activity information from the first record and not the found record. Any Ideas?
GroupEvent Table :
Fields are BeginDate, EndDate, Activity and Number
Thanks
Ed
View 1 Replies
View Related
Jul 24, 2006
My friends,
I am trying as hard as I can to learn Access. I am developing a database for my signage design business. I've been at it for about 5 days already. I know this question would be a piece of cake for the experts in this forum.
When one of my artists finishes with an artwork, he will save this as a jpeg file. I want him to upload it to the database via a form.
1. I would like to come up with a command button that, when clicked, will open a browser on the users remote computer and enables him to find the file to upload.
2. When this file uploads, I want it to be saved in another directory, outside the db, and then linked to a field within the db.
3. And I want this feature also for mp3 files.
Can any one help with this?
View 3 Replies
View Related
Aug 4, 2006
Drag and Drop works great but how do I open a reports based on what I selected?
I have two list boxes the first is "items not selected" and the second is "Items selected" now I want to create a button that open a report showing the result from "Items selected"?? Hope someone can help I've been to ms access web site but our firewall does not allow any down loads. Thanks in advance.
View 3 Replies
View Related
Jul 15, 2005
Good afternoon, I have a form with a subform and in the first txtbox of the subform in the GotFocus event I have a little procedure which checks the txtboxs on the parent to make sure that there is data in all four of the txtboxes. This works great the first time and it pops up a msgbox and it even setsfocus on the txtbox with no data in it, but if I tab into the subform a second time and there still is no data in one of the txtboxs on the parent form, nothing happens, no message and no setting focus on the txtbox with no data in it. Does anyone know of a way to get this procedure to re-set everytime a user tries to enter the subform? Thank you in advance to anyone offering and ideas and suggestions.
View 8 Replies
View Related
