Search results

Ok, here's a more updated version with a few more logical errors removed. Still no test tables put in as yet. Also, ignore reports and Stock level stuff as this would not work given the changes made.

Yeah - I think I tackled it arse about face! The probelm is that the standard Asset tracking DB with Access 2007 didn't really do what I wanted either. It seemed at the time that the inventory one was closer to my needs. I might have to have another look at it, however, of course now I have a...

Firsly, we are a user of item rather than a manufacturer. I would also say that by tracking all individual item we are by definition keeping an inventory, so I'm not quite sure what you mean by the two being not homogeneous. In fact, I think I have the entry of the item info nearly cracked. Of...

Thank Pblady. Maintaining focus using your "change focus, then change back trick" worked fine, so I now simply blank the field and this works a lot better than trying to leave the contents selected. WRT other questions, unfortunately it is another "general" question relating to DB design and...

Man that's rubbish.

I haven't managed to get much further with this. Have any people got thoughts on how I would approach above? Pbaldy - I can get the text box to retain focus, now I want to make sure that everything in the text box is selected. Although I written code to do this: With ScanItem...

Hi all, I have an Access 2007 DB that I will eventually publish to a SharePoint site for general use, however for the moment I'm just wanting to work on it locally. As I have published the DB as a SharePoint file in the past it now continually asks me to re-publish the file. How can I...

There are also some logical error in the above DB, but I will work on those. The next thing I need to be able to do is to create a way of recording tests carried out on individual items. Each individual item will relate to a Product, and each product will be of an equipment type, such that...

Hi again, I have finally got to the point where we have a functional system, albeit with certain problems. As the DB was based on a standard MS one and I have played with all of the Table, Field, Query and Form names, plus added some extra tables and re-arrange relationships, some of the...

Hey pbaldy, Thanks for this. I was indeed looking at ADO to loop through certain fields to add them as default values for an entry of a new record. My methodology: - Open transaction form and automatically go to a new record. Scan in an item. If the user has not selected a previous...

Thanks very much for this. I completely redid the data structure today as it wasn't making sense. I have one more issue again I suspect it is relativly stright forward. Sorry to be a pain. I want to copy the last record in a form/recordset to a new record in the same form/record set...

Cheers. All is now good and although I got both yours and my method to work, I think yours is much neater. I have another seemingly 'simple' question. How do I maintain focus on the text box after it has been update using the carriage return? When you hit return the focus shifts from the text...

Ok, getting there. During my code execution, I setup an ADO recordset that is based on a query using the scanned bar code and selected product of the Transaction. If no product is selected and no serial number is matched (i.e. and empty recordset), I need to ask the user to select a...

Hi pbaldy, its Ok for the mo, I often use the forums to blow off my own thought. I find it useful to try and discribe what I need to do to people who have not clue as to what I'm up to. At the moment I and looking at VBA code to select records and manipulate records. I think I know where I...

To achieve this, I was thinking of using an unbound Text box (as suggested by pbaldy) on the Transactions form that ran VBA code using the AfterUpdate method. When an item is scanned or the serial in entered, there could be a couple of possibilities: - Firstly, the user may NOT have...

Slightly updated relationships with proper naming convention Also, a and updates list of things it need to do and that I would to achieve (not complete) As with the original, the DB will be based around the "inventory Transaction List". This is roughly what I "should"/want to be able...

Your right about the Quantity field. I think its nice to see how many item have been moved at each transaction, but rather than enter this, it could simply be a code updated label that reflect how many items have been added/scanned into a lining table... [Edit - updated in next post]

Yeah - I said it was awkwark. I like the second option. The scanner enters a caridge return after scanning a serial, so the code could look for that. I could have a label with a calculated number based on the quantity entered and the number of records that allready link to that transaction...

Hmm, the more I think about this the more awkward I thinks it going to be. In the "Inventory Transaction List" we have a Quantity field. Depending on this quantity, will depend on how many items I will need to individually record. If these individual items are recorded in a separate table...

Hi all, I'm looking to create a stock control log where by we can record goods moving in and out of our company. We are a Not for Profit organisation that looks after Video equipment for schools and colleges and so have many items coming for our suppliers and moving to and from various studios...