Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Ms access: Fields not taking the data properly

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-02-2011
Member
 
Join Date: Jan 2011
Posts: 78
Ms access: Fields not taking the data properly
  

Hello friends I have been selected in a company that mainly requires creating a database and maintaining information and that is why most of the work is needed to be done using the MS Access. But the problem that I am currently facing is that when I try to make a new raw material through a form "add new raw material item" and when I select the vendor from "vendor" fields it saves the record but instead of vendor name it puts the vendor id that is there is some fluctuation in the data fields of the table, So can some one help me to know what is the problem about and what should I do to solve this problem.

Reply With Quote
  #2  
Old 06-02-2011
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: Ms access: Fields not taking the data properly

I think mostly this kind of problem occurs when there is some kind of error in the relationship of the fields or even the data type that you might have given to the particular fields. I would request to check the data types of your fields carefully and see if you are able to get the problem solved from there. If that doesn?t solves the problem then I would suggest that you should check out the relationship with the entities that you are facing the problem, may be from there you might be able to get the problem solved.
Reply With Quote
  #3  
Old 06-02-2011
Member
 
Join Date: May 2008
Posts: 913
Re: Ms access: Fields not taking the data properly

Hey I would want to know that, where are you trying to view this data that is are you trying to view the report or are you trying to view that on a particular form. If you are trying to view that on a form then I think that you might have done some mistake in the query that you have used to collect all the data that display on the form. Check out the query properly and then see if you are able to solve the issue. Also, if you are trying to view the data on a report then I think that there could be a problem with the fields that you have selected to view the data on a report. Make sure that you first correct all these basic mistakes.
Reply With Quote
  #4  
Old 06-02-2011
Member
 
Join Date: Jan 2011
Posts: 37
Re: Ms access: Fields not taking the data properly

I am also facing some problem with the MS Access recently as when I am trying to create an invoice I do It successfully , but after creating it when I try to print it, I don?t get the printing to be done in a manner that I would want .So I would want that to be printed in the same format that I have but the print command prints the invoice is some other way as it wants, so how can I be able to overcome this difficulty that I have been facing. Please give quick suggestion as I would want to get the work to completed early so as give it for submission.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Ms access: Fields not taking the data properly"
Thread Thread Starter Forum Replies Last Post
In MS access fields are not accepting data properly UTTIYA Windows Software 3 10-03-2011 07:37 AM
How to Auto fill certain fields In a Access 2003 Rebella Software Development 3 24-09-2009 12:52 PM
How to add two fields in ms access? lootera Windows Software 3 03-09-2009 09:18 PM
How to Automatically access the fields of an Access 2007 forms Corona Software Development 3 25-06-2009 12:54 PM
Access does not allow Primary key with two fields Reckon Networking & Security 2 16-06-2009 03:48 PM


All times are GMT +5.5. The time now is 12:04 AM.