Search results

Hi All I am trying to create a warehousing database ( I know i am probably biting off more than i can chew) First off i am using Access 2013 and i am a entry level user . I will have 3 tables tblProducts (all products with there codes go in here) this will be used as a lookup table with...

Hi all I have a Table with two fields on Order No and Date Received I created a form in table view that i use Every order number is bar coded, what i want to do is scan a order in then it put the date and time in automatically and move to a new line for the next order to be scanned in . It...

Hello All I am working on a warehouse database and i have run into a small problem. I am using access 2010 and 2007 depending on location. I have attached a picture of my database relation ship so you can see where i am coming from :) what i am trying to do is make a main form called products...

Hello All i have created a a database with products and locations and customer orders the problem im having is i created a form with my customer name on it and a query between orders and products. i made a form from my query and brought it in as a sub-form on my customer form so i can put...

Hi Guys i was wondering if any one can help me i have created a database with several tables in it 2 sets of many to many relationships in it. My first many to many relation ship is on inventory and location and my second many to many is on customers and orders. What i am trying to do now...

Hello everyone I seem to be on the side of the loosing team when it comes to access. currently i am using access 2007 and 2010. The problem i am having is after i have build my database i am trying to query it when i do the stock and location query every thing seems to work just fine but the...

Hi all I have Created my Database and got to the point where i have to create queries( and i thought making my tables was hard) as you can see in my attached database i have created one queries to add stock and location as per my queries that works fine from what i can see. The problem comes...

Hello All First off sorry if my questions is stupid it is a reflection on my knowledge of access please bare with me :banghead: I am trying to create a warehouse database in acees 2007 and 2010 that can track goods that come in. i have two types of goods Specials which is not on my current...

Hi All I hope im in the right forum for my question. I have a combo box that get its values from another table the problem i am having is when a user don't see the info they have in the combo box then enter the new data into the combo box field but it don't update my table with the entered...

I have been swearing and fighting my way through creating a database i could use and got to the point where i create forms based on query's i have created. The problem i have is i have a datasheet view for one of my query's and want to add a button so that people can press to go back to the...

Hello All Im a new member and also new to access looking forward to learning and growing DeonH