461 Posted Topics

Member Avatar for IT_Student_604

What is the exact syntax error? and what input are you entering into the textbox?

Member Avatar for Mike Askew
0
198
Member Avatar for m16piggy
Member Avatar for chanthung

"Data type mismatch in criteria expression." is an error relating to your SQL. In this case you are putting '11' around the number 11. When using numbers in the SQL you should leave out the ' ' :)

Member Avatar for chanthung
0
1K
Member Avatar for Mike Askew

My project I am working on is a product location system for a large supermarket. My current issue is that the map I am using to display the product location is assembled from rectangle objects which I will then change the colour of when required. The array storing the locations …

Member Avatar for Mike Askew
0
211
Member Avatar for Mike Askew

Not entirely sure if this is even possible as have yet to find a solution anywhere for this but here goes. The form currently looks at a database and pulls a text name from location: [CODE]DS.Tables("Location").Rows(0).Item(4)[/CODE] The resultant text entry from this location, for example: "loc_fvh_Flowers", will then be compared …

0
87
Member Avatar for Mike Askew

The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and …

Member Avatar for Mike Askew
0
150
Member Avatar for DCYPHER

Solving your first issue with mishandling of the calculation. This is because of how the add subtract multiply divide buttons are coded. Your program will currently take the 4 when you press and store to mfirst, then overwrite mfirst with the 3 because you only have one primary storage variable. …

Member Avatar for kleva
0
3K
Member Avatar for Mike Askew

As the title suggests, i am trying to pull a bitmap image stored in a table location with an OLEObject type to my picture box on the form. The code i am using is as following: [CODE=VB.NET]img_ProductPicture.Image = DS.Tables("LocationInfo").Rows(0).Item(5)[/CODE] The error i am receiving is an InvalidCastException: Unable to cast …

Member Avatar for Mike Askew
1
867
Member Avatar for cs_tx_usa

Alternatively to what Mike has said, if you move your executing code (in form2) to the form "on load" section (of form2) instead of in a separate sub it will execute as form2 starts up. Is that what your after cs_tx_usa? Its a simpler way of doing what Mike has …

Member Avatar for Mike Askew
0
257
Member Avatar for whatsername97

Im guessing the diary entry is written into a textbox? Few things: 1. Whats the name assigned to the textbox storing the text? 2. Database file location? eg. c:\User\Database.mdb 3. Table name which you wish to store the information in? 4. Does the table just have one column storing the …

Member Avatar for Mike Askew
0
108
Member Avatar for deepak420

May i suggest changing your email to: ... As bots do scan forums for emails and add them to spam lists.

Member Avatar for tendaimare
-1
71

The End.