Recent content by bali3377

which will the database save : the coded 'Yes' or my input of 'No'

The Value is for a field called 'HasEUVATno' in the Orders Subform and the Master field is EUVATno in "SupplCustForm' The question is: what will happen if i need to override the default with an occasional No. Ie: someone with a VAT no decides to buy something quickly online with Debit card...

that is very neat!! I will have a go thanks

Hello, Does anyone know if it is possible to add anything other than simple text or numbers to default values on form fields? I have a subform for orders on a Form for Customers. I would like to put a default value on one of the subform fields that equalls one of the fields on the customer...

I want to build a rolling cashflow with a forcast element. I am thinking having a pivotal "This Month" field then fields named like "ThisMonthplus1" ; "ThisMonthminus3" ect up to 12 months behind and 6 months in front. If I set up "ThisMonth: Format$([DatePaidDue],"yyyy mm"; and Start the...

The boolean field as an indicator sounds interesting. I am not a programmer in as much as I just use the MS manual for Access - I could do SQL if its just copy and paste jobs - can you further explain this function or is it not suitable for my level.

Is there any way I can lock all records made before a certain date (in this case my year end date) so that accidental changes cannot be made.

UnclCrs: Sum(IIf([TaxYrPaid]="2011" And [BankRec]>"0419",[AmountPaidDue],0)) This query field works as it stands however I want to add another element : The BankRec should be 0419 OR Null. I dont know much on the SQL front I use the Access front to build, so any ideas have to be in this...

In the transactions table I have one field for VAT. I want to show the VAT on sales as well - is it good practice to use the same field for incoming VAT and outgoing VAT - obviously the Amount paid or Amount recd will decide whether the VAT is incoming or outgoing.

PS I have used listbox on the lookup tab on tables but if I wanted to change or add to the list I found myself having to fish around in the design view of the backend of the database and I agree for that reason they are not that useful normally.

Thank you Agnieszka for your indepth response regarding F Keys and Primary Keys. I started off using just autonumber for ID keys but quickly found them a pain in the neck. For instance Transactions Table (Main Table) Payment Method (normalization Table) If I use the autonumber Id. and the...

Thank you Robbie, I believe if lookup fields on tables are removed and put on the queries or forms it speeds up the the database. So I am going to have a shot at it.

Hello I am new to this thread, but I have been reading up on lookup fields in tables and want to remove some of mine. I have heard that removing them can cause bugs and lots of updating of forms and queries. I dont mind replacing the fields in the forms and queries because they simply wont...