I have a project for a movie rental company, and I need to be able to account for rentals. So, how do I create an invoice (form or report) that will show ALL rentals for a customer when they check out, AND print it? I have an invoice table, a customer table (customer ID used) and a movie list table, and that works for the form I've got, IF the customer only rents ONE movie, but what if they rent like seven? I'm not sure how to update the "invoice" table to reflect that, then get all of the information into a the required report for printing.
If more details are needed, respond and I'll post em, but I think that about covers it
thanks in advance for anyones help!
ttmmm
Hi, I have a data entry form that needs to become an invoice form. The problem I have is that the background colour prints too, tried "print data only" option, but as it says on the tin, only the data is printed. Ideally I want the formatting, field headings, but not the background colour.
Is the only option to remove the background colour? Or should I create a "print" button that runs a report for the selected record?
I want to be able to produce invoices from my client database, and be able to have more than one item on an invoice. Probably best I attach the db. frmLayClientDetails is the main form with a sub form where I want to display a summary of that client's invoicing. A button on the form footer opens another form where I want to be able to insert multiple lines on one invoice, then a summary of the invoice is returned in the main form's subform. I am getting a message to the effect that I cannot add the detail on the invoice because there isn't a corresponding invoice number in the invoice table. So I'm not sure just where the invoice number is generated. I will also need a calculated field to sum the items on the invoice, but haven't got to looking at this yet. Any help appreciated.
i was wondering if there is any easy to follow information anywhere or examples with how to do..Specifically on creating an invoice??
The form would need customer details then a subform with the qty, price per unit, extended price then a section on the form which works out the subtotal adds it to freight charges then gst and finally the total.These all automatically then being placed in there appropriate tables..i Managed to figure this out once before but i cant for the life of me figure it out again..I have spent weeks trying any clues???
I have a form with a subform. The form shows an invoice and the subform the items to be invoiced. On this form I want to have a button that creates a credit of this full invoice.
My question is now how to add the existing invoice and details again to the same invoice table (query) and same details table (query).After clicking this button in the two tables should be the original invoice/details and its credit.
I have a database that I will use for invoicing, but I would like it to automatically create an invoice for customers based on parameters set for that customer (e.g., monthly, biweekly, etc.). I have tables containing the customer information, the item they are being billing, the price, etc. I want to be able to have access automatically create the invoices and add them onto the invoice table each month.
Maybe there is a better way, but I thought that if I created a query for all people that are billed biweekly and all people that are billed monthly, that I could run the queries when applicable and then somehow write a macro that would go through the list of customers and add each of them to the Invoice table and add an autonumber. That way I could click run query, run macro, and then do my invoicing. I don't know if that is the way to go or not.
I'm trying to create an invoice system with a sub-form within the main form. The issue I'm having is that the data in the sub-form keeps getting overwritten each time a new record is created for the main form. So when I go back to edit an older record, the data in the sub-form is changed to whatever the latest record had in it. Is there a way to lock in the data in the sub-form so that it stays with it's own record?
I've created a simple database, with tables, forms etc but I've got stuck when I've tried to insert a 'Button' onto the HOME page which when pressed will display an invoice and give you the option of emailing to client or printing.
I think I've gotten messed up in my relationships or the macros which I've copied from another access template.
on the home screen, I click 'new quote' then 'view quote' when the window pops up and then when it tries to generate the invoice I get the error
I have a main form and subform. The main form is bound to a table of invoices and the subform to a table of invoice items. I'm picking up the invoice number from the form to save it to the invoice items table, so I need to save the record for the invoice before saving the invoice items from the subform.
Please suggest me how to do it.Any code or sample like this. I don't know how to add new row of product e.t.c. Please help me as I have never done any programming in ms access before (Done most of web development,asp.net,jsp,coldfusion)
I am practising making relational databases as I haven't used them before.
The mock database I am creating is based around a cleaning company.
I am trying to make a form which will display all of the bookings a certain cleaner has in the future. I want it to be able to display a booking along with the services (Windows cleaning, vacuum cleaning etc...) the customer wants.
At the moment, it is displaying each service (Window cleaning, vacuum cleaning etc...) as separate result on the form and it is not combined. They both have the same booking_ID from the booking table. How can I combine them?
It is far easier to understand what I mean by looking at the database (Attached). Take a look at the form I have created and then click the > arrow at the bottom to see what I mean.
is there any way to carry specific data entered by the user from 3 forms to one printable form which is set up like a city permit? ideally, i'd like the user to be able to click on a button to open the permit & then click print after having entered all the data into the 3 forms (1st form opens 2nd; 2nd opens 3rd). ie - a contractor comes in & applies for a permit, the user (permit clerk) enters all the contractor's info into form 1 then clicks permit & enters the info for that specific permit (there are 4 types) into form 2, then clicks payment & enters check #, fee, etc. into form 3. the permit should now be issued but only needs to have permit #, contractor name, date, location, & amount paid on it. is this possible? i've tried building a query to base a report on with the with that info but am not gettin the results i want, and i don't know how to have a report display only one permit at a time. plus, my users don't want to have to run a query & then print a report. they just want to click print after entering the data (they're very lazy, set in their ways, and not very computer literate). please excuse my dumbness but the whole application is up & running except for this last part.:o please help! thanx in advance.
I am compiling a database of my fire system 'engineers reports' by creating a form that is identical to the one that I print and give to the customer. I used combo boxes to look up system type details, from another table, after inputting the serial number. As these combo boxes can only produce one value I hid the arrows behind background coloured rectangles.
When I print the form the arrows disappear, the combo boxes expand by the width of the arrow and the last 2 digits of right-aligned numbers disappear behind my rectangles.
This form has over 200 controls (systems types, parts used numbers and quantities etc) and I need to print it on a single sheet of paper. I cannot afford to leave extra space between my controls. The only thing I can think of is setting the visible property of my rectangles to screen only, which is not ideal.
Any suggestions would be greatly appreciated. Thanks
I am trying to produce a report that shows a single record that has fields in multiple tables. When these reports we're in Word form they were about 7 pages long. I put them in access to be able to update the data in one or more than one of them at a time more effectively. But now I am unable to get them print out one at a time like they looked originally in Word form.
I don't know whether you can help :D But i am in need of some code/guidence, or a way to go about trying to do what i want to achieve.
Basically, i am creating a invoice producing software in Microsoft Access, based upon Computing parts resaleing.
Because the supplier, i use changes the prices daily, when i type the products into the Parts Table, the price being typed in will change for the next customer to have the same part.
Basically because i am using this software to produce Profit and Loss, The invoice will be looking back at the Parts table, and changing the unit costs for invoices which are say weeks old.
I am wondering whether i can "lock" the invoice so it cannot be updated from the Parts list and keep the profit the same, so i get an accruate result when i come to look at it.
hi all .. i'm new here , I'm not familier with the access so i found it's better to ask the profi. pplz and here i come to u i'm better in Excel anyway here is the steps of what i try to do and i already attached a simple example this invoice form will include the sales throught the month . so it's monthly and here is what i try to do 1-a form to Enter in it the Coustmer name | project |product descp. |measure|uni.price|total 2-i may have more than 1 item in the same invoice. 3-invoice serial no. to be like yyyymm###### i don't know is that able cause when i tried to make an invoice it make on a WEB Page and saved it in some place , i thought i can be in the program it self , and i attached also the form of how the invoice could be , anyhelp ??
Table 1: open invoices I want to use this as the base table to check against
Table 2: invoices for a month containing all details.
I want to use column 5 in table 2 to bump against 1 and matching numbers from table 2 will be returned in a query with all the column details from table 2. The problem is column 5 has duplicate invoices so it can't be set as PK. If these duplicate invoices match on the open invoice report they must be included as well...
I also ran into problems importing table 2. I had some type conversion errors when importing... I tried to change all columns to text in excel it helped a little bit.... In Access when importing the data type is greyed out... any suggestions...
Like I said I am sure this is easy for you pros...
Hi There I Have an Invoice Form Invoice Head And Subform.
Calculation In Invoice_Subform Depend On A Field In Invoice Head. I Need A Code If That Field Changes A Code Will Be Triggred To Check Every Row In The Subform And Change Calculation According To The New Condition
Thought I had sorted this, but now experiencing another problem. I am creating invoices from my db, invoices may have more than one line. So I have set up a form with client name, invoice number, invoice date on the main part of the form, then the invoice lines as a sub form. The two parts are not synchronising. I want the combo box to find the client for me. I suspect I have something that is really quite simple but fundamentally wrong with this combo box. And I may well have made a mess of it because I have fiddled with it so much. I am attaching the db so someone can take a look. My invoice form is frmInvoicehdr. Thanks in anticipation.
Since I posted my system last time I have started my system again because it was seriously messed up. I have now come to a point, like last time where I have a problem with the total on my Invoice/Order form and also i dont know how to use all the data from a 'created order' and make it into a report invoice to print off. Any help appriciated.:)
My system: Gamez New System (http://www.savefile.com/files/6286869)
OK OK I know this should be simple but as a self taught db person I cannot manage the simplest of forms. The problem is I cannot get my customer address to automatically fill in the spaces once I type or select customer from cbo box.
I am totally frustrated as this has taken 6 months of trying to work this out I have copied the Northwind invoice but that does not link in with my tables. I have studied Virginia Anderson The Complete Reference until some of the pages have fallen out, same for Access Inside Out. But none actually tell me step by step how to create an invoice form. Maybe I am thicker than two short planks!!!!!
The next problem is even if I forget the address part and just want to record the customer I put in the plant ordered details but I think I have missed out something as no details appear.
Could someone please look at db attached. Orders table will eventually be deleted as I did not have the foresight to look into future and this covers 2004 only. Once I get a form and table working correctly I will copy this info over. Itemsale table is something I copied from MYOB trying to link something up by using the exact structure of MYOB. Need to work on this further as I need to export info to MYOB.
ANY HELP (incluing psychiatric) would be appreciated.
Could some one help me attach file, it is too big even though compressed
I have couple of problems I need to be resolved and I hope someone here can be able to help me. I have an estimate (all form designed), that when I click the button export to internal invoice, I want the contents of all the estimate moved to the internal invoice and display the invoice, without getting an error cannot delete invoice because they are in a relationship. Does anyone know how to do this? Second then I am having a problem is when I click the button Display report for an invoice I don't want it to display ALLL THE REPORTS of the all the invoices in the database, just the current report for that invoice. This way for example, when I am in invoice number 2130, I don't want too, when I click the button Display Report, to scroll all the way to report of invoice number 2130 to print the invoice. That would be a big problem. Can anyone please help me?
