Search results

thanks sneuberg, I have done this, curiously that method does not work, NI have another guide which i cant find now :/ about using the create data link in labview this opens the same dialog box and makes the same UDL and works how odd. my issue now however is that in the UDL dialog you can...

well that didnt work, I linked to databases But when labview tries to pull data from it, i get an error labview could not open f:\database\infosys.accdb but my UDL points to a linked database at c:\database\infosys_ATE.accdb I guess labview is looking past the linked database and reporting...

thanks CJ that was what i was asking.

ok heres an update, after importing the data across to a new data base some of the tables got messed up, as just one example. SerialNo got replaced with ID. if i have a new database on the local drive with all its tables linked to the database on the networked drive. they would be updated...

great thanks guys and yes you are correct it does work!! but for some reason if i made a database on my pc then the UDL would not work/link, if however i made the database on the target machine then import my database then rename it to the oring and replace it on the network drive it works...

It's appears to be working, I made a blank mdb database opened it and linked the tables from the accdb. All the tables imported. Making an accdb then changing the extension to mdb is correct, I didn't see the option to change to mdb when saving. Strangely the connection from labview to the...

Good afternoon, we have a database in accdb but I'm trying to connect to the database with labview to insert test results into the database and pull barcodes from. unfortunately the mix of windows 64bit and office 32bit means the UDL doesnt work. however it does work if I use MDB. so could i...

yes it does sound that way huh. We've had this database for over 8 years without this issue ever showing up as everyone has to have word and all the other office products installed, otherwise their PC would be almost useless here. It only showed up in this case as a new A.T.E arrived which...

ah well i found an old ms word, installed that everything's ok now :)

thanks, yep just checked, missing ref is msword object library, any way to suppress this message on this one device?

We have had a new piece of hardware installed to test products. This was made by a third party and enters data into access. when ever i open access on this machine i get your Microsoft database or project contain missing or broken references to MSWORD.OLB v8.6 is this simply due to the fact...

arnelgp to the rescue again! you should have a donation button in your signature!

hey cronk thanks for your input, the issue was that it was adding an extra digit to the end of the barcode due to the use of & i changing that to + i corrected the issue :) although the part to check for values is not working If (IsNull(Me.txtBarCode) Or Trim(Me.txtBarCode & "") <> "")...

thanks arnelgp I owe you a drink :)

[SOLVED] Increment by 1 hello, I hope you can help I've made a script that takes: Barcode Part Number Recieved date quantity User inputs the first barcode '100' part number and date received followed by the quantity (10). the VBA should now make 10 entries in the table and increase the...

thought I'd update this thread It was my mistake i deleted "insert into" on this line: db.execute "insert into yourTableName ([barcodeField]) select " & _ Val(me.txtBarCode) + i & ";" This is working now! thank you I've just finished college so i can spend more time on this now. next is to...

I'm not sure what im doing wrong, I've made a form the the table. Inputting values manually without the script works fine all be it one at a time. but as soon as I put that script in I get Run-time error '3087' The mircrosoft database engine cannot find the input table or the query ' tblgdin...

sorry I meant to say that the barcodes will increment so if i scan or enter one barcode which as an example is 001 and i enter a quantity of say 5, then access will populate the table with 5 barcodes incrementing by 1 starting at 001 and ending in 005. there is 4 bits of information that need...

Howdy, I wonder if anyone can point me to an article or what not that can guide me through this. I want to make a form where I scan a barcode, each component has an individual barcode. which would start from the first one (ie) 10 components are delivered with a starting bar-code of 1001 the...

thanks for your advice. I'll take a look at the links in that post over the weekend :)