Search results

This is probably pretty simple but I can't get it. I have a text box on a form called tb_Item. I simply want to go to that textbox, start typing, and if the Item exists, it will autofill the text box. Any help would be great, thanks.

I have frmInventoryDetails to input inventory items that I need to link each item to a project. The problem is, each item is used in multiple projects. Right now I have a text box on the form and I have a caption that reads; "Project Name: Please seperate project name with a comma" this is...

I know this has been discussed plenty of times here but I have searched for an answer as to why this is a bad idea with no luck. Microsoft actually has a tutorial on how, why, and when to use multiple values at table level. I simply want a combo box on my form that allows me to pick multiple...

Folks, I am trying to get a page on my form to open to a new record. I was given a couple of ways to do it, and looked a couple up myself with no luck. I have coded the event in the Forms OnLoad event. I have tried a Macro as well. The only way I can seem to make it work is to change Data...

I'm sure this is simple but, how do I change the default form opened when I start my db? Thanks

On my form, I have a inactive window that I want to display the sum of a particular part number qty. My records are as follows. Mnf Part................Transaction Qty Part 1...................transaction amount Part 2.................. transaction amount Part 1.................. transaction...

I have an inventory table. I have a form to look at the data. I want to give the user the ability to add more of any particular inventory in the "In Stock" Field of the inventory table. I realize that "In Stock" needs to be made up of two other fields which are in a table named transactions and...

Is there a way to lock down just the old records? I have a form to insert new records and I want to have the ability to see old records but not edit them. I also have an inventory adjustment page within the form. When I turn editing capabilities off on the form, I lose the ability to update my...

I have a form with a PackType and a PackQty input box. I want the boxes to update fields in a table called Packaging. My PackTypes field includes Reel, Tube and Single. The problem is that sometimes values for reel and tube can vary. Any suggestions on what I'm not doing right here? Thanks...

Folks, I could use a bit of help with my DB. I have an inventory table set up with the following basic fields. [Mfr Part #], [Qty], [Location],[Product]=(Combo Box) All was well on my reports but someone said it wasn't wise to design the table with multiple choice fields and that they should be...

Hi folks, I'm trying to build a report based on mulitple data within a field. I have option 1 and option 2 as a combo box within a record field. I have created two reports. One for a list of option 1's checked, One for option 2's checked. If both are checked, then I want them to show up in...

Hello folks, I am basically new to access. I used 2003 when I was in college but my memory fails me so sorry if I ask some pretty basic questions. Thanks for any support and I look forward to learning some new tricks as I set up my database for work.