Search results

This board has a lot of posts giving examples of doing this type of thing. Just search under "Previous Record" I recommend looking at Joh K's posts on the topic for guidance. They have helped me in the past. Good luck.

I posted this a while back and it is still an outstanding item on my to do list. If anyone has experience tracking inventory cost with Access I would appreciate your insights into this matter.

I am sure this is a common problem so here is how I got around it if will help somebody in the future. I set up a third form with two command buttons that run macros to open the input form and then the reconcile form. It works but it seems like there should be an easier way.

You read it exactly right. I had hoped to open the prompt form by setting the Event of the Reconcile Form to open the prompt form On Open. I also tried the Activate or Load choices but they did not work either. I want it to open the prompt form and THEN run the query with the parameters to...

Hello all, I have not posted for awhile but this problem is annoying and I think easily solved. Here tis, I created a parameter query that retrieves client transactions from a table. The parameters are the ClientID and the StartDate and EndDate. The user should reconcile the transactions at...

I have a solution....but only in theory. Hopefully someone on this board has done something similar and can help me out. If the data in the transactionhistory table was recorded differently then writing the queries to do what I want would be a snap. A buy will always represent a new lot...

I have continued to work on this and am pretty much stuck where I thought I would get stuck. I have updated the sample database with my current state of progress. Basically, it counts the buy lots, counts the sell lots and then puts them together in a Query called LotBalance. The first...

I made a small mistake in the sample database. The Sells should be negatives in the Table. Sorry for my oversight if anyone has spent time on this.

Hello, I have an inventory tracking problem that is tailor made to be solved by a database. I just need a little help getting it together. A sample database with a table is attached to help illustrate the situation. Basically, inventory is purchased in large blocks and sold later in smaller...

I found the problem. I had a field called "Date" which of course is a reserved word. I changed that and now it seems to be firing on all cylinders. Thanks for the advice.

2 similar answers. They are probably dead on but I'm a still a little confused. The queries do get the criteria from a form (I hope). In the query's criteria field it has an expression like: Form! Between (Start Date) and (End Date) and then there is another one to enter the client. It is a...

I have a report that is based on a parameter query. There are actually 3 queries and the parameters are in the first but the report gets its fields from the 3rd query. When a user clicks on the report a dialog box Form opens so they can enter the parameters. Everything works as designed but...

My database now calcalculates a compounding value. What I had to end up doing was saving the daily percent changes to a table and then use them in a Self Join query. I was really hoping to avoid storing these calculated values as this is a big no no in databases but I could not get it to work...

Yes, I use this information in a combo box on a form. In another example I enter infromation about client meetings so I have a Meeting Type table that has 1 = Phone 2= In Person 3 = Internet etc. I also have one of these tables set up to list types of client transactions 1 = buy 2 = sell etc...

I have several tables in my database that I use as lists to select items from. For example, the Status table has two fields: An autonumber as the primary key and a Status field which can have only two values either "Open" or "Closed" So it looks like: 1 Open 2 Closed Everything in my...

I could also do this in a report. I just read a post by VJMEHRA called running sum where it was suggested that he do his calculations in a report. How would I do this? I studied a Visual Basic book at the library as well. I think since I have a column that counts for each unique client and a...

Life gets easier.............Thanks, I had to dig through the menu for awhile to find the generic printer but now I can both print preview and do the Snapshot reports.

I need to export a report so that a person without Access can view it. After researching this board I believe the way to go about it is to export it in Snapshot format and make sure the other person has the Snapshot program. Easy enough. But Access wants me to install a printer before I export...

After many hours of plugging away my head is plugged but the database is sill one up on me. I am sure I have gotten close but that does not seem to cut it in the database game. I am sure that a database created by Jon K is doing what I want my database to do. I have tried to adapt his method...

Check out the post "Increment a Field, DMAX."