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 | 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 May 27th, 2006, 04:17 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 Data updating in Table & reflecting in report

Hi ,

 I got an DB which is created by my colligue earlier now my boss told me to updated the DB. The Details are below..

 DB Name :Computer & Accessories Database Managment
 Discription :DB to Account Computer & it Accessories
 Table :Main table of Equipment name , make , Modle so no...
 Query :To get the data by Equipment name wise
 From :To enter the full data
 Report :1. Total Report & 2.Base on the Query.

 What was have observer is the data's have been update in the from once the equipment arrive to my office i.e. if printer arrive then it ill enterd so no...

 Now i want to add the some data (i.e. new arriavls) and i want to change data (i.e. shift for computer from one room to another).If i did any correctoin in the data is doesn't reflect in the report
i.e. while iam taking the report in equipment name wise the is sl.No. is colapesing bcs of this continous updation & altertion

 what i did was i had given sorting & grouping option in the report but no result..

 what i want what the serial no may be data store but when iam going to take the equipment report it should shows continous ... 1,2,3,4,5,6, like this

 * Note iam sorting the datas Room number which iam entering in the from....

Pls help i not to understand pls rpl..
thanks in advance...
Reply With Quote
  #2 (permalink)  
Old May 28th, 2006, 01:22 AM
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

 Certain possibilities....

1. Make sure if the data is storing into the correct table once you updated thru form. (I doubt..). check the VBA codes that written behind the save command button (Incase SAVE button is placed on the form)

2. Check the form's data tab in the property if it is set appropriate. (All addition = yes/no etc..) This may be one of the reason.

3. Check the criteria in query that is set with report.


.....


Displaying of records in ascending or descending manner should be set from the query itself.

The counting of records on the report can be obtained thru "count" reserve words in Jet engine keeping into a unbound textbox on the report. Like ;

=[Count]-30

where as you will have to play with the integer part including arithmetic operator (Only + or - ) according to the page length and then finally it will produce the result 1, 2, 3 and so on.

Hope this help.
Ashfaque
Reply With Quote
  #3 (permalink)  
Old May 29th, 2006, 05:00 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

hoo ash,

 I don think so . pls try to clarify me again..

bye

bye
------------------------
pap...
Reply With Quote
  #4 (permalink)  
Old May 29th, 2006, 08:51 AM
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

Which part from the above is not "UNDERSTANDABLE" to you ?

Ashfaque

Reply With Quote
  #5 (permalink)  
Old May 31st, 2006, 01:23 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

Ashi,

   Let me explain data field which iam having is Room No, Name of the Equipment ...etc.. The iam Sorting with room no.. ok . Then the Equipment will be differed as Computer , Laptop , Server , Printers , Scanner , ect and the data lies on the equipment name .. i want to take reportview equipment namewise .. and i did the report for that . when i run the query it ask me the equipment name and when i entered the equipment name then the report will appear what i wish.. its show's room no. , Equipment name in the Header , Model , Make PRice Who's having etc.. now what i need is an addition field which show the serial number before ..it is possible for me ]
pls explain & iam very tried to write this mess....



bye
------------------------
pap...
Reply With Quote
  #6 (permalink)  
Old May 31st, 2006, 03:57 AM
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

As I told you before add a unbound textbox to the detail section of your report and write the following into it.

=Count-30

Where as you can change the intiger part according to the length of the report. Alos in the property of ths text box goto Data---Running Sum and select Over Group (If you are grouping).

This will produce the result you wish to. If still doesn't work ....send your db file to me in ZIP mode with minimum records. I will see and let you know.

Regards,
Ashfaque

N. B. Field Names should be always WITHOUT any space.


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
Updating one table with data from another table dirtdog22 Access VBA 1 January 21st, 2008 04:41 PM
Updating data from a report ? palli BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 May 28th, 2007 12:34 PM
Updating data from a report ? palli Reporting Services 0 May 28th, 2007 12:32 PM
Updating data table vaidyapragati ASP.NET 2.0 Basics 4 May 11th, 2007 11:52 PM
Data report & date problem ratheeshpkr BOOK: Beginning Access VBA 0 April 6th, 2005 08:02 AM



All times are GMT -4. The time now is 07:29 PM.


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