The reason I had to store the invoice total as a calculated field was because I had a query, which identifies the income for any given month. I can't total that income if the invoicetotal is unbound. It can display the calculation on the form, but it wont show that value in datasheet view.
So the only way this will work I guess is if I create a report? Or a form? But even so, how can I add up the total for all jobs in a month if totalrate,...
antheana
Last Activity: Jan 20 '07, 01:53 AM
Joined: Nov 20 '06
Location:
-
-
Sorry, I should have said the InvoiceTotal textbox is bound.
So what you're saying is that I should create a prcoedure (maybe a runCode macro?) to perform the calculation and for each textbox (rate/expenses/no of days), I should call the afterUpdate(cal culate total or whatever) procedure?
Well that was what I was hoping to avoid, but looks like I do have to call something to perform that calculation each time. Fair enough....Leave a comment:
-
MS Access 2003 - Refresh a textbox's calculation
Hi there,
I have a job details form - on that form I have fields to store the job rate, expenses and number of days this rate/expenses applies e.g. rate £150, expenses £24 for 3 days.
I have 2 unbound textfields:
TotalRate (rate * no of days)
TotalExpenses (expenses * no of days)
This then calculates the invoicetotal:
...Code:Me!InvoiceTotal.Value = [TotalRate] + [TotalExpenses]
-
Managed to get this working, so thanks for your help!Leave a comment:
-
Hi there,
Thanks alot, that does make sense. One slight problem, I have NO idea where to put that first bit of code. I managed to find the references and select the Outlook option you mentioned.
But if I am to 'bind' globally (this is what I got from your post), I wasn't sure where to put the code:
Dim objOutlook As Outlook.Applica tion
Set objOutlook = New Outlook.Applica tion
...Leave a comment:
-
Problems with copying sample codes (MS Access)
Hi there,
I have a specific problem, but also wanted to guage everyone's thoughts on copying codes. For less knowledgeable people like myself, I sometimes find i difficult to write code from scratch, but now that I've been developing a database (with your help!) I'm starting to see how the code is working.
However, I recently copied some code to create an appointment in MS Outlook and adapted it to use existing data... -
Hi there,
Sorry about the delay, I meant to reply sooner. Thanks for your advice. One job can be assigned to one person and one invoice will be sent for that job. I've now expanded things a little now anyway, managed to get the invoicing working (I put the jobID in the Invoice table) and have used this site to work out how to display an invoice for the current record - gotta love the scripts!
More problems are on the...Leave a comment:
-
Invoicing for a job help
Hi there,
NeoPa and mccarthy have helped me with some table design advice previously, but I made a bit of a boo boo. It is with regards to invoicing for a job.
tblJobs
tblInvoices
Now, I have a form called frmJobs that allows me to display everything related to a job e.g.
JobID
JobRef
...
EmployeeID
...
ContractID
ClientContact
...... -
OK I obviously didn't read it thoroughly enough...
tblMembersInter ests will contain the name and email address of each member and there will be a separate record for them for every interest they have e.g.
Jason; King; jking@hotmail.. .; new services
Jason; King; jking@hotmail.. .; new courses
Andrew; Jones; andrewjones@aol ...; special offers
So I just need to create a query each time I want...Leave a comment:
-
Hiya, thanks for your replies, unfortunately it's still a bit unclear. There's no need for a priority - it's just that I know how frustrating it is to receive newsletters with things that dont interest me, so want to only send newsletters to those who have opted to hear about certain things e.g. new courses.
So the plan is to create my mailing liste members table, then create an interests table, then create a members interest table...Leave a comment:
-
Thanks alot Mary, that's helped alot. Have a great evening.Leave a comment:
-
Thank you both for your replies.
PEB, I didn't really understand that. Would the 3rd table display each interest and wihtin that each member who has selected that interest? In which case, how do I link the two?
NeoPa - that was what I was thinking of doing, but the problem is that say I end up having 15 interests, if a member was only interested in 1, then it would mean 14 blank records wouldn't it? I was just trying...Leave a comment:
-
Allowing multiple selections in a list box for mailing list
Hi there,
I am trying to create a tblMailingList, but am a little stuck on multiple selections. The people that have opted into this mailing list will be given a list of different interests they want to be kept informed about e.g. services, special offers, 3rd party services etc.
At any given time, If I create a newsletter for services, I want to run a query to extract everyone who has said they want to be kept up to... -
Thanks for that. I'll have a read and see how I can restructure. I didn't want you to tell me the actual structure, just some advice, so I'll look at how I can simplify it all.
I think my problem is that I am trying to automate too much. I'll have a rethink about what information is absolutely vital and can be generated and what can be inserted manually.
ThanksLeave a comment:
-
MS Access 2003 - Table Design Advice
Hi there,
I am currently redesigning a database, which includes a contracts table that captures information about each contract e.g.
ContractID (PK)
ContractReferen ce
ContractTypeID (FK)
DateCommissione d
JobTitle
StartDate
FinishDate
ContractLength
Rate
RateTypeID (FK)
Quantity (hours/days)
Expenses
ExpensesType (FK)
... -
Thank you very much! I definitely need to read up on Access event procedures as I tried that several times and it still didn't work. I did a small bit of VB in college, so came up with this:
And that somehow worked! Basic I know, but...Code:If [JobInvoiceDate] <> "" Then [JobPaymentDate] = [JobInvoiceDate] + 35 - Weekday([JobInvoiceDate]) Else [JobPaymentDate] = "" End If
Leave a comment:
-
Hi there NeoPa,
Geeeenius! Thanks!!!! That worked, but like this:
The second line didn't seem to work, so I had to leave it as a comment - what is it supposed to do?Code:[JobPaymentDate] = [JobInvoiceDate] + 35 - Weekday([JobInvoiceDate]) 'JobInvoiceDate (7 - Weekday(JobInvoiceDate)) + 28
Also, is there a way to set a if JobInvoiceDate = Null then set JobPaymentDate = "" and...Leave a comment:
-
Thank you NeoPa,
Do you have a 'writing code for dummies version'?
I'm not sure where I am supposed to be putting this code. I initially placed it within the OnOpen routine for the form and that didn't work. I ied to insert it as the Control Source of the textfield and that didn't work either.
Should I even be trying to place this on the form? Or should it go on the table etc?Leave a comment:
-
28 days from end of week?
Grrr I just lost the post so have to start again, I hope I don't miss anything!
Hello!!!
Ok, so I have a database (MS Access 2003), which has a Jobs table and has information about the client, client contact, job descriptions and most importantly:
InvoiceDate
InvoiceNumber
JobRate
JobExpenses
JobPayment
PaymentTerms
PaymentDueDate
InvoiceSent (checkbox)... -
Complete and utter genius!!!
Thank you all for your help - problem solved. I added -1 to JobStartDate and with the dates (jobstartdate) 17/11/2006 and (jobfinishdate) 17/11/06 the joblength came back as 1 not 0.
So thanks again. It is much appreciated :)...Leave a comment:
No activity results to display
Leave a comment: