Recent content by fleurette

Hi Billmeye any comments on my sample database? I attached it a while back.

Oh dear! :( I will do that, but does that mean that I have to scrap the work that I have done so far? Or am I able to tweek it from there? Thanks Richard.

Thanks Pat for the tip. I will try to see if I can draw my calculated values from the query into the form field. Currently the calculated values are in the form field itself and I suspect maybe this might slow down as there are more data? Or does it not make a difference at all? UPDATE: I...

Hi billmeye Thanks I really wanted some of the features into the database (which I thought was simple to do using wizards since I know nothing about coding). - automated invoice number - able to print a particular invoice for an instalment when it is due instead of a whole string of invoices...

Hi AccessBlaster thanks here's a sample framework. Thanks

Sorry I wasn't clear. I used a report wizard to add the fields I want for the invoice. They are fields from 2 tables. So I have customer name, address, order number and invoice number and some other details. Everything is showing up but my invoice number. It used to show up but now it's just...

Hi I had created a report format. However, the data is now showing on the generated invoice. The rest are showing up but one. I went back to the tables to check and there is data present. It used to work until recently. Seems like somethings in access are intermittent? :confused: Can...

Hi bulldogs thank you! It has been a painstakingly slow process trying to create something on access. Your invoice looks nice!!!! I think part of the complication is that I have order number and then I have a few instalment invoices relating to each particular order. So I have have a main...

Thanks I tried the code in the link you provided but can't get it to work. Is the lingo "Me.Dirty" in the code standard language to use :eek:

Hi, this is very helpful as I am wanting to create a combo list based on a selection of particular record like what is described here. I am on Access 2007 but I am unable to find the last option in the picture you posted above. I only have the 2 options to select. Am I missing something...

Hi I have used a report wizard to create invoice format. Currently, when I run the report, it will generate all the other invoices continously (a bit like a continuous long roll of of toilet paper:D). However, I only need to print a particular invoice at a time. 1. How do I only print a...

Hi billmeye thank you very much. I did try using an unbound control and to type in an expression, but a #Name? error came out and I was unable to solve this the whole day. All the field names look correct but it still does not reflect the calculated results. As for your suggested formula, do...

Hi Pat Thanks for your reply. The calculated fields are current in my form. They appear in the subform field when gross income and brokerage percentage are entered. But they do not update the tables with the calculated results which I need. Is Access 2007 not able to do that? Previously I...

Hi, I have created a form and subform using form wizard where users could enter the data of a new order. In the form, there are some expressions where it does a computation of the fees that the company earned for each order. This is a percentage of the gross income. The subform expression...

I tried using the above e.g. in my situation. Expr1: DMax([Serial Number],[Policy Information])+1 but I am getting an error message. Serial number has data like, 0001, 0002, 0003 and policy information is my table. any one can help with what's wrong with the syntax? thanks