A Simple Way To Keep Track Of Incoming Invoices
I need a simple way to keep track of incoming invoices in Access 2000. I don't work in the billing dept., but I am an assistant that has been given the job of listing bills as they come into the office. I want to be able to type in the company's name and relevant information one time and then enter all invoices from that company in table format so that when I print a report, all invoices that are related to each individual company are listed accordingly. I'm new to working with Access. Can anyone help? Thanks.
I need to add some code to our access 2002 database to test incoming files for bytes, zero byte files in particular. Our system will then pick out the zero byte files for emailing to our customers. Can someone provide code for testing for bytes or provide me some direction on this matter? Thank you!
i am trying to develop something for my business to organize job cards and invoices.
so far i have done the following:
a table that has the following format:
job cards|Date|Client|Start time|Finish Time|description|status
i also did the queries that search for clients job cards and dates.
i also did a report that shows all the above information for different job numbers.
I want to do the following:
when i choose which job numbers i want to print to have a print botton that does that then a message box to appear asking to confirm the printing of the job cards and then update the status field to printed.
Also i want to be able to calculate the time spent of each job and then add all the times together for each client separately so i can calculate the time that we spend on each client each month.
also i want to be able to create a table that has each client and the month and the time that we have spent there in hours and minutes.
Also i need to be able to update that table every month to see if we still owe the client any more hours.
all you help is appreciated.
Thank you for your time.
I want to set up an automated recurring monthly invoice for clients in my database.
I know this is possible but I am having trouble finding the solution and in fact having problems how to search for a solution.
On the 1st of every month I would like to have a query run that inserts a new row into my invoice table for all current clients invoicing them for that month.
Please please help. Invoicing one at a time using a form is taking far too long each month.
I have a table called vendors in that table is Company Name,
address, city, state and zip. I also created a form called vendors same information. On the form i have a combo box called bill to party which selects the name that will print on the invoice.
Ex Company Name ABC
Address What Ever
City State Zip
Billed to party (here is the combo box on the form)
However when i select the bill to party on the form from the combo box it is only showing the name of the billed party on the invoice and not the address city and state.
I dont want to create extra text boxes on the form so when i chose the bill to name on the form will fill in the text boxes I dont want to do this. All i want is to select the bill to party from the drop down menu and when i view the invoice it will automatically show up on the invoice.
I have a report that produces invoices and gets its data from a multi-table based query. The query has multiple lines for each customer and the report groups and totals them. How can I have the invoices numbered sequentially? Any help please?
What Im trying to do is make invoices that I have in to data base...
reason for it is to keep a close watch on the price fluctuation since the stuff we get are from different country. We don't really need it but this is my own little project just for myself...I have all the tables made and form ready but I have couple of problems.
1. How do I calculate and save it in the table? I Know this violates 3rd normalization but I need to do this since the price will change almost every week. basic calculation which is total price / quantity.
2. How do I get the previous record on the form automatically? lets say that the date I put in is July,4,2005. How do I get this to show up in form for the new data input? and keep that date until it is updated using form.
3. Since I'll be getting same stuff lots of times, and since they all have item number, How do I get it to auto fill? lets say that I input a item number and rest of the form automatically fills in the rest of the values...and updates are saved to the table and next time I input the same item number updated data will automatically fill in the rest.
Thanks in advance. This is my first post so, please go easy on me...:)
I also search the forum but couldn't find anything that I understood...
Is this a project too advanced for newbies? As I have stated earlier, I have everything layout but I'm just trying to make it easier inputing new data.
and all the codes that are here, I'm lead to believe they are Visual Basic.
and good book for newbies on VB?
Thanks. and sorry for the long post...
I'm sort of new to Access, but over the past few months I've been able to develop an inventory database for my work which turned out quite nicely and does everything I need it to, except for one thing.
I want to also create invoices for my customers, and after looking at examples I understand that most people link the "order" with the invoice, so that there is one invoice per order. However, I need the ability to combine many orders into one invoice. That's where I'm stuck.
I don't know how to arrange my relationships and forms so that I can "pick" the orders I want on my invoice, and not at the time of the Order, but at some point after. Basically my orders will be established, but their allocation to invoices won't, until I come along and put them into their rightful bill.
Does anyone have any thoughts on this? I'm pretty stumped.
Thanks a lot for your help.
I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details are required.
I'm unsure of the correct procedure, all I can think of is to create a separate table for cash sales??
I have a table with every invoice I have raised to my customers on it (160,000 records so far). Every record identifies the customer and the date of the invoice. I would like a query that returns details of the last 4 invoices raised to each customer based on the date of the invoice. So, if I have 100 customers I would expect 400 records returned. I have spent ages searching and reading the forums re this and have seen several post that I "think" are similar, but I think I'm too daft to understand the solutions put forward. I "think" this involves a module to count but as I have never written a module in my life am a bit confused. Any pointers would be greatly appreciated.
Is there any way we can convert the amount in numeric form to text format Eg: $ 1000 as Thousand Dollars.
I need this for generating invoices.
Thanks in advance for the help...
I am looking to create an Itemized invoicing system within my Access database for my small business. In concept, I will need two number fields that update themselves for each new entry (using the d(max) function for the primary key or Invoice ID number, I have learned the hard way autonumbers are not good for this) and another field for the Item numbers. Some invoices may have 1 item, whereas others may have 12. My question is, how do I create a field with an automated number that will return to the number 1 for the next entry in the table? For example, Invoice Number 1234 has 5 items, and they are numbered 1-2-3-4-5.. then Invoice Number 1235 has 7 items, numbered 1-2-3-4-5-6-7. I'm sure this has been asked before so I do apologize for being unable to find this. I have looked. Thank you for your help!
Is there a built in control in Access 2003 to enable batch printing by date?
or is there a query to send invoices to a batch file to be printed at one time rather than one at a time?
I sell products for a large company that is located on the other side of the country. I don't invoice my customers but rather make up the invoice and send it to head office, who then send it to the customer. Sounds rather cumbersome, but that's the way they want it. My problem is that I would like to send between 10 to 20 invoices a week via email, but because each invoice (report) has the same name (rptInvoice), but a different number and contents, using the SendObject method only allows me to send one invoice. Even if I use separate emails for each invoice, it will always send the same invoice, the first one. Is there any way I could send different versions of the same report in one email? Thanks in advance for your help.
I have downloaded invoices in XML form from a web trader portal, I've
attached an example XML file and the associated dtd file.
I can import the xml file into Access but the following, very
important, bit of info, gets left out:
<odn num="508001475889"> which is the invoice number.
Is there a way to get that into Access as well?
We have a billing scheme in which we partial-bill ceratain customers based on certain events: 30% when they sign the contract, 30% a number of days later, 30% when we ship the goods and the last 10% upon installation. This is a common process, known in many indistries as 'progress billing.'
What I am trying to do is compare the collection performance on the invoices based upon which trigger sent them. For example, I'd like to find the average and standard deviation (plus some percentiles) of the time it takes to collect invoices that are sent... when we ship, let's say.
I have a table that shows order number, invoice number, invoice date, amount and payment date. So, I can have the order number show up to 4 times with a chronology of invoice dates.
My question is this: How do I group for analysis all the FIRST invoices, the SECOND ones, etc...?
Thanks for any help! I can do this in excel... but I was given this extract of 100000+ lines, and hope to do it all in Access. Thanks again.
This is an example based on the NorthWind example using the Invoice report.
I created a form to select the Invoices you want to print. There is a "Select All", "Unselect All", and "Print Invoices" buttons.
To make it work I had to add one field to the "Orders" table. Then I added the field to the query form the Invoice report.
Hope you find this useful.
Hoping someone out there can help me with a seemingly simple task, although I'm drawing a blank.
I would like to set up a "print queue", where the user checks off invoices that are ready to print at a later time or date. I put a checkbox in the table with the invoice numbers which is on my form. I created a query to pull up invoice numbers that are "ready to print", which runs fine.
How do I write a DoCmd.OpenReport line in my button that will open the report (same report for all invoices), but will only print the invoices selected in the query?
Right now, I'm trying this line:
DoCmd.OpenReport "WorkOrder", acPreview, "qryStatusPrintFile", "[WorkOrderNum]=" & Me![WorkOrderNum]
but it keeps asking for parameters for "tblWorkOrderNumbers.Filed?" and "tblWorkOrderNumbers.StatusPrintFile" which are two checkbox fields in my query (the invoice has to be current i.e. not filed, and ready to print)
Thanks! I can provide other information if need be.
I have tried creating new forms which work fine but as soon as I try to pull them up in reports they disappear. I have tried deleting older invoices but nothing has work so far. The last invoice that my reports successfully printed was 1633. Is there some sort of limit?
As you all know, in the Northwind sample database there are the Invoices and Invoices Filter query. The Invoices Filter query adds a criteria to select only items that belong to the current order. OrderID is integer.
However, if I change OrderID to Replication ID, it stops working.
Any idea how to make it work? Currently I work around this problem in my DB by adding a criteria to filter by Date and Customer ID, but IMO this is less than ideal.
Hey guys i have a question about correctly formating spacing with customer's info. I currently create invoices to send to customers but the problem is, when the name and address are displayed the spacing all "wacked" out for example.
FakeDale_____ Apt. 11
New York_____ NY 10001
The spacing doesnt change for each customer, so sometimes i have all this space between names, and then sometimes for long names and addresses it gets cut off. I do know about exporting to microsoft word, or using the mircosoft word mail merge, but it seems to be haphazard when using that. If anyone has any suggestions.
Edited by: JonGen on Thu Oct 25 23:43:39 EDT 2007.
I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it.
So for this reason i need to create a logfile to determine what are all the changes made in the data in the database with the user who uses that.
(I need to create a history and save it.)
is that possible in MS ACCESS? if so can anyone tell me some suggestion
Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments.
My tables are
Products (A,B,C) ( A customer can only purchase one product)
PaymentSchedule (Annual, Quarterly, Monthly)
Annual Product Fees
Quarterly Product Fees
Monthly Product Fees
Am I doing ok so far? I wasn't sure How to make my tables since the amount payable is dependent on both the product type and the payment schedule. Any suggestions?
What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
Hi, I am trying to figure out a way to keep record of store hours, and days open for lots of different restaurants. The only thing I could up with is the following. I'm not sure how to keep track of store hours, or even the best way to make a table for hours. Any help is appreciated, thanks.
Hi. I have a form with many fields. I want to track changes av 1 field to know the field value has been changed or not. I know about onchange event, but this only works when user inserts or changes the value. My form is being updated by macro/visual Basic. Is there any way to fin out if the value of a field has been changed automatically?
Thanks for any help!
hello all... i tried to search an answer for my questions but i couldn't...
what is the easiest way to track users and their login time???
Is it possible to identify the user and date of a change made to a record in an Access 2003 Database retroactively the built in securiy features were not turned on?
I thought this was posted here in the past, but I can't find it. I need a way to track when users log into an access database (username and time).
Is there an easy way to do this?
Im fairly new to MS Access and have recently created a simple database to track the details of people in my department.
The database is on a shared drive and the idea was that when the details of the individual change, they open the database themselves and edit the appropiate field.
However, is it possible to track the changes that people make over a certain period (ie every month).
Thanking you in advance,
I'm interested in tracking monthly utility bills....monthly charges, units/volumes, costs per unit and so on, by monthly date. Would I be OK using a single table for my data, since it only involves gas, electric and water each month? How would I chart the data, so I could see trends (i.e., cost per volume, etc.)
Are there any sample projects out there that I might be able to adapt to what I'm interested in?
I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!
I have been wondering about how I'm going to keep track of revisions for one of my databases.
Currently, I have the database split into a Back End (BE) and Front End (FE). In the work environment, the BE sits on the server, whilst all other 4 machines get a local copy of the FE. All table data in stored in the BE and linked to the FE.
I have recently got my act together and started documenting all the revisions I make to the BE and FE of the database. To do so, I created two tables with the following fields:
RevID (PK Auto increment),
I called them tblRevisions_FE, tblRevisions_BE. I placed both tables in the BE.
Whenever I make changes to BE / FE, I record it in the appropriate table.
However, because I often work on the FE of the database off site, I don't have access to the BE table (tblRevisions_FE) to record the new changes for the FE.
One alternative I thought of was just recording the revisions in a text document, and asking the client to manually record these in the tblRevisions_FE (via a FE form).
I did have tblRevisions_FE located in the FE, but when each db user got a copy of the FE, there would also be 4 copies of the table floating around.
Does anyone have any suggestions about how to manage documentation of FE revisions in this situation?
I have created a database that I am happy with, and I am about to receive information to populate it with. I know I am about to be asked to about security and logging of changes made to the data, which I know nothing about!!
As a result before I get into this part of my project I would like to know myself what is and what is not possible!!
Currently I have 2 tables and 3 forms, one of which is a sub form........ All changes will be done via the forms, adding new records, editing existing records or even deleting obsolete records.
•Is it possible to record any changes made to the live data?
oFor this to happen I presume that I need to setup users and access rights?
•What type of information can be saved if any?
oWhat form would this be saved in and where (a temp table?)?
While typing this a change of plan – if it is possible I am going to start building it regardless, as it will enhance my database.