Search results

Thanks for all the input working on the base design as soon as have it in place ill respond did not run away yet. :D

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...

Thanks CJ_London Appreciate your help got every thing working For some reason my enter-key behavior was set to ad new line in field that is why after every thing it did not move to next record .I set the property to to default behavior on the enter key behavior now it works like a charm ...

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...

Thanks Mailman i will give it a go on that suggestion Never surrender never give up forward is only way to end

It has 4 forms at the moment I have it open at the moment /panic

pr2-eugin I have it as follows customer --> Orders---->Order Detail <---Inventory--->Inventory Location<---Location so between inventory and location there is no problem also between customer and orders there is no problem it is when i want to use link between order detail and inventory...

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 Jdraw was Wondering if you can have a look at my current Dbase as it is evolving. i am currently stuck on the fact that i want to put a order in for the stock i have it keeps saying that i am trying to enter a null value if you would be so kind to see where i am going wrong again:o

Thank you for the information i new that the problem i am having is my doing i just did not know where to start looking for it thanks again for the insight much appreciated

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...

Thank you jdraw for clearing that up like i said in my first post please forgive me for being a bit dim i am trying to do something that i was asked to do that i do have little to no knowledge of i am trying to make the best of a bad situation and apologize for creating confusion with my questions.

Attached File shows the data model i was trying to follow but i ran in to the PF problem

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 Jdraw Is see in the link you gave me they have three types of keys for a table 1: Is a Primary Key that is a Auto number (Indexed no Duplicates) PK 2: Foreign Key that is a number field with a long integer FK 3: now i don't know how to say this because i have no idea how...

Thank you so much for your patience in the matter i will keep on building and ask as i run into a wall jdraw you are awesome.

I don't need to keep a record of the customer Address or other details only Customer Name that's why i only have that field in customer Table. As far as getting confused on product and special stock is the fact that we deal with 2 types of stock normal stock that only get booked into one...

Hello Jdraw I have taken a step back and redid my tables to include orders and customers i did use the link you send me to get to this stage if you can see if i am doing it right i would appreciate it very much Deon