Search results

Hi! (SKIP - this part if your not into 'the story') It has been a while since I last posted. Thanks to the help of the forum members I've been successful in implementing a supplier invoice management database AND an operation management system. Both have been in play for well over a year now...

Your telling me! :D :banghead: I am trained on SageAccounts, but thought I would give this a shot so I can design my own interface and documents. May have to deal with Sage and its boring look ha

Will try the multiple criteria but I have a feeling I will need to re-organise my records for future usage. Now I am involving more complicated functions im finding it hard to do the task based on this very simple database build. With that remittance its not as easy as just including the...

With all this now sorted. Is there anyway I can choose to select other records out of the query criteria that I can have listed on my report? My criteria selects the correct records to be listed so I don't want to change it. But I may wish to include other records that do not meet the...

Thanks very much for that input! It worked and now my Remittance (report) now shows ALL invoices (matching query criteria) along with matching credits to listed invoices! Shows how easy it is when you know what your doing :rolleyes: Now going forward with the upgrades on my database. Im sure...

Could you describe further sorry. I didnt understand that. Youll have to excuse me im self taught and i know hardly any terminology. Thanks

OK, Sorry about that. So my report is based on the below query. The criteria relates to invoice 'status'. Which picks the invoices which are 'Due' and lists them in the remittance. All i want to do is add [CreditDate], [CreditNum], [CreditAmount] to the remittance. Not all invoices will have...

Hi, I'm hitting that never ending brick wall again! :banghead: So my database is coming along nicely. Until a credit controller threw a spanner in the works and asked that i include partial credits into a remittance (using a report). Now this wouldnt be a problem if i knew exactly what im...

SOLVED - thanks

Ill look into it thanks! But it still leaves the original question unanswered. I will continue on my own, this is just frustrating getting a straight forward answer. Thanks again Minty.

Just want to say thank you to everyone who posted a reply. But this topic will be taken no further as im not staying on a forum full of stuck up access sadbags with more time to argue about a topic that is not up for discussion than helping with a basic issue mentioned! From another thread*...

What a waste of everyones time. Thanks Minty for your suggestion.....this unlike others had an explanation behind it rather than a total disagreement and 'b**ch fit' about how I choose to work. Stuck up IT people with no social skills outside a chatboard/forum is pathetic practice. P.S Ill...

I didn't know I could set 4 forms each with its own default supplier. That would solve the problem of the 4 separate databases! Thanks! This database is literally being used by myself to hold invoice information for viewing by me only and was originally created for the sole purpose of having...

Thanks for all the replies guys! I will read through them all shortly and reply.

I have put some thought into the whole 4 vs 1 DB issue, and I fully agree. But at the moment I'm happy with 4 DB choice. I wont be in time, I understand that but the simplicity of the database at this stage justifies my choice - in my eyes :eek: The entry of records has to be manual as they are...

I have not had time to check my previous thread regarding this DB - this was a quick posted thread for help with a specific form problem. The original thread will be tidied in due time. In answer to your question - The previous months of the year running up to todays date were/will be...

:( I know, its going to be incredibly hard to maintain! I don't have an acceptable answer to this. My only answer is simply: Laziness. Using one database for ALL suppliers would mean I would have to include a table for suppliers and include a look-up field in my invoice table to include...

Hi, I recently created a database to be used to store incoming invoices. We have 4 suppliers which supply the same material and wanted each supplier to have its own database. I began by making a database which included all the key tables, forms, queries and functions I would need to then save 4...

Apologies, didnt explain myself properly there. Invoices are issued by one supplier. I will begin to input them as recieved into my Invoices table. By 'my' invoice number i mean the supplier invoice number. Each invoices entry row starts with the ID field - i just wanted to know if i should...

Hi, I'm currently working on a short project to create a database for accounts payable. The main use of this database will be collecting all details from invoices and credits from a particular supplier and print reports of invoices due etc. It shouldn't take me too long but I wouldn't mind...