473,320 Members | 1,977 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

First Record is not correct

While performing a fill() method, the first record NEVER shows the correct
price of database item. The 2nd record and every record that has a price
will show the correct price. If I open the Access DB through Access, the
price is shown correctly in the table. I have double checked my
DataBindings but it always shows $0.00 in the UnitPriceTextBox.
Private Sub FormProducts_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Try
Me.Cursor = Cursors.AppStarting
Me.CategoriesTableAdapter.Fill(Me.Inventory_manage ment_databaseDataSet.Categories)
Me.Inventory_TransactionsTableAdapter.FillByTransa ctionDate(Me.Inventory_management_databaseDataSet. Inventory_Transactions)
Me.ProductsTableAdapter.Fill(Me.Inventory_manageme nt_databaseDataSet.Products)

Me.UnitPriceMaskedTextBox.Text =
Format(Val(Me.UnitPriceTextBox.Text), "C2") 'Update text box with
currency format
Catch ex As System.Exception
MessageBox.Show(ex.Message, "Error Loading Records")
Me.Cursor = Cursors.Default
Finally
Me.Cursor = Cursors.Default
End Try

End Sub
Tony K

Aug 14 '07 #1
0 955

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: KJ | last post by:
We use a third party software package for acctg that limits us on field size - as a result, we at times have to enter an item into the app multiple times in order to get all the information. I...
3
by: Jason A. Thompson | last post by:
Dear Access Gurus, I have a database which I hoped to use to administer questionnaires, or rather that someone who knows nothing about Access could use to administer them. Each q'aire item is on...
6
by: neptune | last post by:
I must be missing something obvious. I have 3 fields and sample data. 7890 26592 7/15/2003 7890 13645 10/6/1999 7890 58741 6/21/1992 I...
0
by: James | last post by:
I have a bound combo using a lookup table which is behaving as expected with the exception of the first record. In the list of rows for my combo, the first is '.'. This is because of another...
22
by: RayPower | last post by:
I'm having problem with using DAO recordset to append record into a table and subsequent code to update other tables in a transaction. The MDB is Access 2000 with the latest service pack of JET 4....
0
by: byuphil | last post by:
My subform is displaying records from a table. Using the master-child links I am able to pass all of the necessary keys to show the correct information. When I try to select any item from a...
6
by: zack | last post by:
This query has been driving me crazy, and would be grateful for a nudge in the right direction. Still pretty much a beginner using Access 2003, I just cannot figure the solution to the following in...
2
by: John Sheppard | last post by:
Hello there, I have a report with a subreport on it. The subreport is meant to show multiple child record for each master record. But it only shows the first record. When I open the subreport...
1
by: Henry Stockbridge | last post by:
Hi, I have a main form (bio info) with a tab control containing three pages (employment, financial and dependent, respectively.) When I move record to record on the main form, the correct...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.