Recent content by Sillygirl

When I try to add a treeview control to MS ACCESS 2007, I get the following error: "There was a problem accessing a property or method of the OLE object. " I have tried everything to correct this issue - any one have any suggestions would be greatly appreciated!

When I try to add a treeview control to MS ACCESS 2007, I get the following error: There was a problem accessing a property or method of the OLE object. I have tried everything to correct this issue - any one have any suggestions would be greatly appreciated! [hourglass]

Thanks all - solved it myself! [cheers]

I have an old VB6 program that is being updated to use ACCESS 2007 database. I'm getting this error "Method or Data Member Not Found" and it's highlighting ".Edit" and have no idea what is causing it. Could it be the references? If timecheck!Runweek <> Runweek Then timecheck.Edit...

SOLVED!! DoCmd.RunSQL "INSERT INTO tblRptDates(INDIVIDUAL_DATE,INDIVIDUAL_DAY,str_Individual_date) VALUES('" & holdDate & "','" & strDateDesc & "','" & strholddate & "');"

I am converting a MS ACCESS 2003 DB to MS ACCESS 2007, within the loop below, I'm setting holddate to a date the user selects. I am then counting up to a week within the loop. Meanwhile I'm taking that same date (holdDate) and extracting the day and inputting the values in a table. It works...

HERE is my query: qry& = SQLExecQuery(id&, "INSERT INTO PRODUCTION_COUNTS_LOG (Timestamp,Shift,Hour,Motor,Cartrac,Body,Trim_Prod,Chas_Prod,Ship) VALUES ('&CSTR(now)&',CUR_SHIFT.VALUE,HR_CNT_HR.VALUE,MOT_CNT_HR.VALUE,CAR_CNT_HR.VALUE,BDY_CNT_HR.VALUE,PNT_CNT_HR.VALUE" &_ "&...

I'm trying to print a line using Printer.Print commands. Here is a sample of my code: Printer.Print "Vendor "; Trim$(txtVendor.Text) Printer.Print "Sid # "; Trim$(txtSid.Text) Printer.Print "Size "; Trim$(txtSize.Text) Printer.Print "Received "; Date...

I'm trying to determine that a record on a form is in a another table. However when I run a command, I know that the record is not in the table, the msgbox says it exists. My question is - 1. Is this code correct for the DLookup, can you check more than one value for a record? Criteria =...

Thanks so - much for your help. However, how would you put the single quotes in if they comment out the line? Thanks in advance.

Basically, I'm trying to pull information from a table and compare it to the form values. Can someone help me with this error? Set DBs = CurrentDb() Criteria = "SELECT * from tblEX2MFRAME WHERE Forms![frmP6ABViewActive]![subfrmP6abViewActive].Form![GMIN] = [tblEx2MFRAME]![GMIN] AND...

This is probably a simple one - but I'm drawing a blank. I have a make table query. SELECT tblP63Active.NAME, tblP63Active.APPL_DEPT, tblP63Active.APPL_CLASS, tblP63Active.A_R, tblP63Active.APPL_DATE, tblP63Active.CURR_SHIFT, " " AS TYPE, " " AS FILL INTO tblP63Export FROM tblP63Active; I...

Zarkon 4: Thanks for your reply - do you mean you cannot use printer.print with VGL also - if so you are wrong with that however with ZPL - you are probably correct - however the printer is a networked printer not attached to the local port... and the IP address could change. So what would I...

Been there done that. I have coded in VGL/PGL before - have no problem - just what is the conversion - how to put ZPL which is the printer language for Zebras into Visual Basic 6.0. Thanks.

I am converting code from IGP to ZPL and I wanted to know if anyone had any kind of code samples for me to look at. Here is an excerpt of what was coded in VB to a printronix printer. What would it be like in ZPL? Printer.Print "^PY^-" Printer.Print "^PY^-" Printer.Print "^F^-"...