Recent content by klynch0803

Welcome aboard

Yes dbpix does solve this issue. The best I have found is I can display a still image from a file already in existence but not from a webcam. It requires vb that is only in a VB5 language that utilizes .dll and I could not get access to control that or anyone else who could as well. If you...

In the below sql statement within my query how can I set the invadjust in the first line to true when this is ran? INSERT INTO tdatInventoryRec ( RecDate, Item, Qty, invadjust ) SELECT [qdatInventoryCheckupGather Diff].InvDate, [qdatInventoryCheckupGather Diff].Item...

First Thanks for taking the time to help out. In the sql VB Code I'm trying to accomplish this in VB instead of an external Query.... SELECT [qdatInventoryCheckup Correct Inventory].InvDate, [qdatInventoryCheckup Correct Inventory].Item, [qdatInventoryCheckup Correct...

I have an error in this VB and it says Mismatch... Not sure what is wrong... Can someone please help me find the error? Dim strsql As Boolean Debug.Print strsql = "SELECT * FROM qdatInventoryCheckupGather Diff " & _ "WHERE Diff = '' " & _...

Any help would be greatly appreciatted.... I have a form that I change some records for inventory purposes and after all changes have been made it updates the records to a table. I'm going to give a short version that if you want to look at the database you can figure it out and a long...

You are correct I do have that query but I want to see what the inventory level was when it was checked ad what the difference was. Therefore I need a table in my view to derive this list.. I tried making a form to enter the actual inventory into for the items and it do a comparison and then...

Excellent Thank You so much Bob... Me! makes the differnce by telling it on the form itself... I see ... Thanks again for the help..

I can only get a False.... Maybe if you have time or get time you can take another peek at the file?? I have upladed an updated one for you to look at if you have time.. Thanks Again...

Ok So Bob I got that fix thanks so much... but now why am I getting this Syntax error when I select update? It appears all my field names etc are correct... ====START ERROR Run-time Error '3075' Syntax Error (missing Operator) in query expression "actqy' set tdatinventorycheckup.difference =...

I got you... Its 0",0",1",1",1" Thanks for your help..

That only displays the date Bob... SO would I then go to? -1";1";1";1";1";1"

What is wrong with my combobox? I cant it to display the Item int he box instead it wants to display the ItemID... I cant figure out if its in the properties or if its in the afterUpdate Event (I dont think its here)... The actual event would be you select the item and then all the other...

Maybe the easier thing would be to create an append query and then just supress messages and run from VB?

Ok this seems to be in the right path.. It tried to insert the first record but it gave me a popup window with the item name and a field to enter something.. Why?