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.
I will try to explain my problem as best i can and would appreciate any thoughts other people have on it, it is surely similar in some degree to someone elses previous work!
I need to produce management information on a monthly basis, one example of this type of work are an employees one to ones.
table121 contains following fields, ID scheduledDate CompletedDate Completed(yes/no)
My report/query needs to group records by the month (which i do through formatting date fields to display mm/yy), count the number of scheduled one2ones, count the number of completed one2ones, display a %.
I have played around and got this to work using querys with grouping and sums.
My problem is if the schedule date and the completed date are in different months then all of the statistics become out of sync, particualy when there are more appraisals taking place than scheduled. Any ideas?
I am Trying To calculate Costs for a particular month how do i do this when taking into account that the months obviously hae different lenghts? I have the overall week cost but how do i do it for the month?
I am trying to create an inventory which list sales by month. I have created a crosstab query from the detail history table which works fine except I would like a record for each month whether there was sales or not. So on the report I would have all 12 months for each item with the months with no sales displaying zero.
I am having issues trying to run a query. What we have is a private club that keeps track of its members with an access 2007 database. What we need to do is to be able to print out new members monthly for a state audit. The way it is setup now, our members reports prints all of the members since day one. For example, we have a state audit coming up next month for November and we would only like to print out members that have joined during the month of November, but our report is printing out all of the members since we started in August.
We do have a date joined query. The fields we would like to print are: Date Joined, Member ID, FName, LName, City, State
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
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.
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
Every month for my construction company, I receive a pay application that consists of the following:
1) about 100 "Line Items" (each one being a different type of work performed)
2) a Subcontractor associated with each line item (a line item may have only 1 Sub, but a Sub may be listed multiple times for different line items)
3) Amount of work performed (in $$) on that line item by that particular Sub during that pay period.
My boss wants a db to track all of this info. She thinks the best way would to create a new table for each Pay Application, every month. Basically, we would be starting from scratch every month with a blank table. But, I think it would work better if the months were linked to each other in some way.
I could have a field called "Pay_App" and enter 1 or 2, etc. on every row for every line item every month. But, then each month, I would be entering a 1 (or whatever the month is) for every single line item and that seems stupid. I want to be able to pull up the entire pay schedule for a particular Sub (all of his payments throughout the entire job). Is there a way to link the different pay application tables once the data has been entered? Or is there an easier way to do this? I would appreciate any help that can be provided. Thanks.
I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded. The only thing I can think of is to create 10 different tables one for each month but i think it won't work well when I want to see how much a specific student pays.. any ideas? the information for each month that i want to have is the student first and last name, date of payment, level, fees amount and money paid (and perhaps month name..). Thank you in advance guys!
I hope I can convey what I am trying to figure out. I am at a loss right now. I have a form where I input personnel information. One of the fields is for how many months experience they have with the program. What i would like is for this record to update itself every month. for example, if they initially had 2 months experience, I would enter 2. Every month therafter, that number with change to 3, 4, 5...etc. Not everyone comes to our section with the same experience, so most will have a different starting number.
This information would be seen on the personnel form, and in a report to show experience levels. Other than those two, it is not called upon.
I'm trying to create an expression that will calculate cumulative monthly totals but my expression seems to only calculate totals for all months e.g MonthDirect DespatchesCum Direct Despatches 2006/031580 21867 2006/0410681 21867 2006/059606 21867
The expression I’m using is Cum Direct Despatches: (Select Sum([Direct Despatches]) from QRY_DirectDespatches_ByMonth_ByModel)
The query should display the following results - MonthDirect DespatchesCum Direct Despatches 2006/031580 1580 2006/0410681 12261 2006/059606 21867
I'm using Access 2002 on XP. Can anyone please advise me where i'm going wrong?! Thanks in advance for the response
I have attatched a word document showing values and what I need. I want to create queries (monthly, quarterly, semi-anually, yearly). I am working with the monthly right now and if I can figure that out I am assuming I will be able to figure the others out the same way. For the monthly report I want to divide the quarterly amounts by 3, semi yearly amounts by 6, and yearly amounts by 12. Then I want their respective values to appear in the monthly statement. How do I do this?
