Search results

I haven't had time to really look into it yet, but I just found out there's a ' WHERE EXISTS' function in access that I didn't know about. I think this may hold the key to solving our problems, but like I said I haven't really looked into it yet.

But wouldn't that only work for missing values in a field, and not for 'missing' records? Or am I mistaken?

I think I have a very similar problem so I hope you don't mind if I explain mine in the same topic. I have a database that keeps track outgoing money per category, incoming money per category, and budget per category per year. I want to calculate remaining budget by calculating budget - (sum of...

I don't think I explained the problem well enough, but by now I found the answer. I found out Access automatically selects the correct/current record when you place a button in the details section of a form. I assumed I somehow had to tell Access which record I wanted the data from so I was...

Hi, Each table has it's own autonumber as ID. I'm not storing any 'real' invoice numbers because it's not for business purposes.

Hi all, I have a form with 2 subforms, each based on their own table. One displays categories of invoices (e.g. rent, electricity, etc.) including some details like monthly costs. I would like users to be able to select one of those categories and copy this to another table, after which they...

I'm currently in the process of pasting the controls and fields but it's a pain in the butt. I also seem to have lost the stacking property of my fields, so first I have to make them stacked, then change the padding between them, add a field, copy 3 controls back in and re-align them with the...

Hmm, actually I just noticed something else keeps going missing: a few text fields that I added at a later stage than all the other text fields... the buttons were also added at a later stage... I can't put my finger on what's going on here. :S

Hi all, I'm trying to export a form to another database. I've tried both simply copy/paste and using the export function. In both cases the form is copied to the other database, but my buttons go missing. Is there a way to move the form to another database and keep it intact?

Thanks for your help though. :)

I think I finally just solved it myself. I was making two mistakes. First of all I should have put the fields with the details in a sub form rather than on the form itself. I already tried that before but with no results. The second thing I needed to do was give the sub form a 'where' clause...

Do you mean that I shouldn't add more criteria as I go to the next combo box and then the next? So in stead of saying combo box 3 needs to take box 1 and 2 into account, it should only take box 2 into account? If that is what you mean, that does make sense and is good to know, but I don't see...

Hi all, I'll try to explain this as clearly as possible: I have a database consisting of 4 tables, each containing items of a certain type. I also have a 5th table which is a join table, because different combinations of items have specific properties (e.g. 1 item is 50 cm long, the other is 60...

Thanks it worked! I still don't know why Dlookup didn't work but I learned something new and it gets the job done! :)

Hi all, I've never used DLookup before and I can't get it to work for me so far. I have 1 table which contains products and different properties of each product, such as the weight of the product. I have created a query which sums the weight of all products, but only for those that have a...

Hi guys, Thanks for your replies. I'm taking it one thing at a time so first I'm trying to redesign my database based on Mihails advise. I'm wondering though with this new way of keeping track of transactions: how can I still keep track of which customer places which order, and optionally which...

Hi all, I have an inventory database with a few tables: 1 with product info 1 with customer info 1 with incoming stock 1 with outgoing stock (orders) I also have 3 query's: Total incoming stock per product Total outgoing stock per product Total current stock per product (based on the 2...

Thank you both for your feedback, I'll get to work on it and see how far I get. :)

Hi all, I'm quite new to Access and am just working on a little practice database where I keep track of sales of a product. Basically I have a table keeping track of the different types of products, a table keeping track of customers, a table for orders and one for replenishments of stock. I...