Issue displaying data in table or form

[issues]

Hi all,

I was not sure which forum to put this under as it kind of covers all of them so i thought best to put it here.

My issue is that i have a database that has alot of different tables forms etc (its for a company i work for) and we use a frontend form to fill in all the data etc, but we have a specific field (Credit Note Value) that will display the figure in the form, but it does not display it in the table. Now the Odd thing is that it displays it upto a certain point (upto June last year) and then it just stops? its is very strange! i have looked at it from all possible angles and tried everything i can think of, can anyone make any suggestions of some things to try please? my level is access knowledge is of an intermediate level so nothing to hardcore and an explination would be appreciated i have attached some pictures to show the different problems of where the value is not showing and where it is showing.

http://img193.imageshack.us/i/creditnotevalue1.jpg

http://img194.imageshack.us/i/creditnotevalue2.jpg

http://img256.imageshack.us/i/problemrecord.png

 

[alktrigger]

you've attached nothing. Try to re-attach since that might make it much easier to diagnose your problem.

 

[issues]

I tried again but the images wont show so i have just put the links in instead. Thanks for noticing

 

[alktrigger]

Check your links because they don't work for me.

My first question, "Credit Note Value" is that generated then automatically put in the form, or does the user enter it into the form?

If the user enters the value into the form, I would double check the query that reads off of the form, make sure that it has the field required, and is reading correctly. In that query you should have a column that reads something along the lines of "CNValue: [Forms]![frmCreditNote]![txtCNV]". This will most likely be a append query, unless you have another query reading from the aforementioned query. If that's the case, you should make sure that the field remains in each query until it is added to the table as a record.

If the value is automatically generated, I would also check that the query that is should be appending the CNV is seeing it, if not, work backwards from that query until you find a query that can read the value.

 

[issues]

Thanks for the reply. I have checked and the value is pulled from a number of fields using a calculation which the value is then displayed in a different field. I have another question, it has been a long time since i used access, is there a way to see what is linked to what? i.e. form to querie etc?

The thing i find funny about this issue is that there is a chunk of data showing the values then all of a sudden it has just stopped!?!?

If this "[Forms]![Quality Problem Record]![txtCNV]" (the "Quality Problem Record" is the name of the form, also i did not make this database which is why i dont know my way around it )is not shown where would i put this in the Querie?

 

[Galaxiom]

Does the value show when the form is filled out but is not being recorded in the table when the record saves?
This would mean it is not shown when the record is displayed again in the form

Or do you mean the value shows in the form when loaded with historical data even though the table field does not appear to have a value for that record?

 

[issues]

Il break it down of how it goes

We fill out the form, then when you look at the table where the data goes, the credit note value does not appear, but if I go into the form it will display in there. And like I said some of the older files from June last year show in the table and in the form, but anything after than just does not show.

Hope this helps

 

[alktrigger]

is there a way to see what is linked to what? i.e. form to querie etc?

Nothing that simple, unless the designer did a fantastic job with the Relationships Table. My approach would be to go to each control and check for either vb code or a macro that it uses, or data that it references. Your best bet would be to check the command boxes first since they tend to do much of the grunt work. go through the code and see what queries are run, then open those queries and see how they are generated. If you're going to be working on this database, getting to know how it works will make your life much easier.

If this "[Forms]![Quality Problem Record]![txtCNV]" is not shown where would i put this in the Querie?

You would make a whole new query and save it somewhere else, or add it to the query that appends the table.

 

[issues]

I looked in the VB code and found a line for "Form_Quality Problem Record" and it contained the following text, if you look right at the bottom that is the only part i can see that has anything to do with the Credit Note Value. Could you have a scan over the rest and see if i missed anything? i also looked at the relationships and couldnt see anything linking to any relevant queries.

Thnx

_________________________________________________________________________
Option Compare Database
Option Explicit

Private Sub butPageDown_Click()

End Sub
Private Sub ActiveXCtl82_Updated(Code As Integer)
[Location].SetFocus

End Sub
Private Sub Command75_Click()
On Error GoTo Err_Command75_Click


DoCmd.Close

Exit_Command75_Click:
Exit Sub

Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click

End Sub

Private Sub Command158_Click()
On Error GoTo Err_Command158_Click

Dim stDocName As String

stDocName = "Credit Note Request"
DoCmd.OpenReport stDocName, acPreview

Exit_Command158_Click:
Exit Sub

Err_Command158_Click:
MsgBox Err.Description
Resume Exit_Command158_Click

End Sub
Private Sub Command159_Click()
On Error GoTo Err_Command159_Click

Dim stDocName As String

stDocName = "repQualityProblemRecord"
DoCmd.OpenReport stDocName, acPreview

Exit_Command159_Click:
Exit Sub

Err_Command159_Click:
MsgBox Err.Description
Resume Exit_Command159_Click

End Sub
Private Sub Command163_Click()
On Error GoTo Err_Command163_Click

Dim stDocName As String

stDocName = "repQualityProblemRecord"
DoCmd.SendObject acReport, stDocName

Exit_Command163_Click:
Exit Sub

Err_Command163_Click:
MsgBox Err.Description
Resume Exit_Command163_Click

End Sub
Private Sub Command164_Click()
On Error GoTo Err_Command164_Click

Dim stDocName As String

stDocName = "Credit Note Request"
DoCmd.OpenReport stDocName, acPreview

Exit_Command164_Click:
Exit Sub

Err_Command164_Click:
MsgBox Err.Description
Resume Exit_Command164_Click

End Sub
Private Sub Command165_Click()
On Error GoTo Err_Command165_Click

Dim stDocName As String

stDocName = "Credit Note Request"
DoCmd.SendObject acReport, stDocName

Exit_Command165_Click:
Exit Sub

Err_Command165_Click:
MsgBox Err.Description
Resume Exit_Command165_Click

End Sub
Private Sub Command166_Click()
On Error GoTo Err_Command166_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Suppliers"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command166_Click:
Exit Sub

Err_Command166_Click:
MsgBox Err.Description
Resume Exit_Command166_Click

End Sub
Private Sub Command171_Click()
On Error GoTo Err_Command171_Click


DoCmd.Close

Exit_Command171_Click:
Exit Sub

Err_Command171_Click:
MsgBox Err.Description
Resume Exit_Command171_Click

End Sub
Private Sub Command250_Click()
On Error GoTo Err_Command250_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "AnalysisCodesList"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command250_Click:
Exit Sub

Err_Command250_Click:
MsgBox Err.Description
Resume Exit_Command250_Click

End Sub

Private Sub CreditNoteValue_BeforeUpdate(Cancel As Integer)

End Sub

 

[Galaxiom]

This code only appears to for buttons to open or send reports and open forms.

Incidentally it is horrible code. They have used the default names for all the buttons and the code is littered with junk variables. Its form is designed using a wizard by someone who either doen't know better or doesn't care.

 

[issues]

The guy who did it was paid alot of money but someone who would just nod and agree, so im guessing he dosent care so is the problem not in this code then? whcih means it must be in one of the very many queries lol.

 

[issues]

Sorry all but i still dont have a fix for this, can someone else shed anymore light on the issue?