Search results for query: *

I have a table and one of the fields is VAT rate but access keeps rounding the number up, if i put in 17.5 access makes it 1750.00 or 1800 Looked everywhere to solve this Thanks

Hi I have a combox bow on a form, which gets all my customers account numbers from a table, want iam trying to do is when the combo box selects a customer the name and address in automatically filled in the address box, Thanks

Hi Can somebody help me out with this, I have a button on a form which opens another form what i want to do is disable this button if Comms Type = audible Is this a easy thing to do, Thanks

I have a worksheet called invoice at L16 i have a combo box that gets customer account number from a sheet called customers this works at last, what i am trying to do now is populate the address fields on the main invoice with the customer the combo box = in the invoice the address label is at...

Looking for help on the VBA code to place behind a button to print a worksheet. Thanks

Need some help or ideas, i am trying to create a new invoicing package which needs to be simple to use for me, i have created a sheet in excel which is locked and allows data to be entered, now for the hard part. What iam trying to do is have a worksheet for each month and when a invoice is...

I need to make myself a simple invoicing system, but i cant understand that if there are more than one item how you get a total for all. And then store the total and invoice number together. If that does not make sense i will post agin due to need a day away from this computer, iam going daft...

Due to the constant modifications of my db which i keep learning from the good people in here, want i thought of doing is have a field called Ver No: and the value of this field save my db as this, i am upto to 9 version in the last 2weeks and have to keep using save as, just wondering if it...

I have a idea you are all going to tell me to get Win Server but lets see. At home i have a PC thats always on and two connected via a LAN i want to be able to send and recive email at both PCs from the same accounts, and view the same inbox and messages on only PC. I have been told that the...

Hi All, Iam looking for a solution for this any ideas would be a big help. I have a access db sitting on a shared pc, all networked pc's link to this pc for the db, but on two pc's iam getting OLE Server problem due to anti virus software (script blocking) now i dont want to turn the virus...

My db in Access is just starting to play up and i have no idea what it means. " A Problen Occurred Communicating With OLE Server" This shows itself when i run a report, basically everything for my db is on a shared PC and has run fine, i have just tried to run a report from another...

I have posted before on this and get some ideas back, but never been able to complete this, i want a report to run when a date field = todays date. What i have is a table of customers and one of the fields is date to apply when date to apply = todays date it runs the report for that customer...

Does anybody know of a site where you can dowload buttons for use with access, i need one with a key on it and a telephone symbol amongest others.

I have a query that i cant get to work, so iam about to give up, any help or ideas on this would be great. I have a field called LAST_SERVICE_VISIT which displays the date a service was made on a system ddmmyyyy this works fine and pulls the information from a subform. I also have a field...

Need help with VB, i have a unbound field on my main form and have only just found out that its not updating my table. Now i need to change it to a bound box and have tried to put the following in as the control source =DMax("[Date of Visit]","[Service History]","ID =...

Somebody might be able to shed some light on this, i have the following code in the control source of a text box, it works fine, it find the last date in a subform for what ever customer is shown, but when the text box is displaying the date it does not update my table. Is this because its a...

Is there a way to have the same autotext enteries on all PCs, linked to a server. One pc has all the autotext setup on it already but other pcs need the same autotext for doing quotations, is it possible to have the autotext on the server and all the pcs use that, i have tried document templates...

I need to find a way to do the following, on a form i have a text box LAST SERVICE DATE and a field SERVICE FREQ which is a combo and can equal 12,6,3 months what iam trying to do is create a Field on my form that also is in my main table called NEXT SERVICE DUE this needs to be the sum of...

Iam putting together a simple stock/order db, is there a way off adding up in a table, i have a field called QTY and a field COST and one called COST IN STOCK the cost in stock needs to = QTY*COST i cant find a way for the table to do this. Also can the table keep a running record of toatl cost...

Iam starting to make a datbase from ordering and stock, so far i have two tables one with all the stock and another with the suppliers info, i need to make a form which i can do but this has got me, I need to make a form which will have the suppliers details on the top (done this) then a part...