Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 3rd, 2006, 02:43 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default IST in Access

HI all,

  In my Office there are three section which is major instead of all smaller & iam in the stores section to maintaing an database for the inventory of these three section and now i got a trouble that some of the materials are been transfer internal through the section and it as been enter in the book manually and my task is i want to do Internal stock transfer in database & i dont to change in the table by search the data in the field & sparing the time (ofcourse now iam doing like that). But i want to do as an Internal Stock transfer..

 The Table which iam having contains all the data and the data which i want to change ..

  My method is first i want to search the data by the section name & Room no. were it lise and i want to change the data room no. and section name & User name (not the material name , Invoice no. ect) is this possible ..(All through front-end by an from)

 If ur not able to understand please revert me'

Thanks & regards,
P.Anukprsanna
Reply With Quote
  #2 (permalink)  
Old November 3rd, 2006, 08:29 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

It should be possible. What is the table structure?

When you do an internal stock transfer, you should be able to just change the owner of the stock. That would require this sort of strucure:

tblSection
SectionID - PK
SectionName
etc

tblStockName
StockNameID - PK
StockName

tblStockItem
StockItemID - PK
StockNameID - FK
SerialNumber
etc

tblSection_StockItem
Section_StockItemID - PK
SectionID - FK
StockItemID - FK


This will maintain a current list of stock owners, but it will not keep a history.

Let me know.

mmcdonal
Reply With Quote
  #3 (permalink)  
Old November 3rd, 2006, 08:31 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If it turns out that you don't have this structure, you can still move the items from one Section table to another using code.

Also, to answer the first part of your question, I think, create a form with combo boxes that look up the fields you want, then open the record you want by passing the combo box selection to the next form.

mmcdonal
Reply With Quote
  #4 (permalink)  
Old November 4th, 2006, 05:18 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

mc

 let me explain Table Structure : Room No , Section Incharge , Equipment Name ect. probably these are all the main field and my idea is i want to give the IST by just an simple method..

   In an from i want to get an search options having combo box namels Room No. & Section incharge and an button to get the searched data
   Now the task i had is i want to get the search result in an sub-from and i want to chage the details which i desire ( which i mentioned as IST).

 Now u get this concept & what i need is i want to how to get the result in the sub - form .. please do the need full

Learn as you can..
------------------------
pap...
Reply With Quote
  #5 (permalink)  
Old November 6th, 2006, 08:36 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

As far as the Room No. and Section incharge combo boxes, use the combo box wizard to look up the values from those columns in your main table, if they are not already reference tables. For example, if your tables look like this:

tblSectionInCharge
SectionID - PK
Section - text

tblRoomNo
RoomID
RoomNo

tblMain
MainID - PK
RoomNo - FK
SectionID - FK
...

then use the combo box wizard to look up the values in tblSectionInCharge and tblRoomNo. If there are no reference tables for Section and Room, then use the wizard to look up values in those fields in your main table, and then select query properties, and select Unique Values = Yes.

Then create a query for your subform, and set criteria for section and room to the combo box values on your form, and then the button will requery the subform.

I think that will work. Any comments from other posters?

mmcdonal
Reply With Quote
  #6 (permalink)  
Old November 9th, 2006, 12:51 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

thats the point.

 what a Co-incidence? i have tried like the method what u mentioned and i got the result thanks for your solution mc.



Learn as you can..
------------------------
pap...
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
401.3 Access denied due to Access Control List cforsyth .NET Framework 2.0 8 May 28th, 2009 01:56 PM
SQL Access/ASP.NET data access issue saeta57 SQL Server ASP 1 July 4th, 2004 04:29 PM
SQL Access/ASP.NET data access issue saeta57 Classic ASP Databases 1 July 4th, 2004 03:32 PM
ADE file in Access 2000 <---> Access XP ginoitalo Access 3 April 14th, 2004 09:06 PM
Access XP VBA compatibility issues w/ Access 2000 bourgeois02 Access VBA 1 August 19th, 2003 04:14 PM



All times are GMT -4. The time now is 04:48 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.