Search results for query: *

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^-"...

I'm receiving the following error, I have tried to re-compile the MS Access database, however it has not fixed anything. This application works on all different kinds of PCs except one. It is written in MS ACCESS 2000. I checked the references and none are missing. Any ideas? The...

I figured it out!!! With the application open - click on tools, options, security, select low, and then close application, restart application and he haw - there we have it!!! #NAME? went away!! Thanks everyone.

Yes. The frmCRI is open when the report opens and populates. Everything on the report populates except for anything that references any textboxes on the form.

It is a text box with this control source. =[Forms]![frmCRI].[objReportProfile].[FromDate] Thanks!

Thanks Jeff - but that doesn't give me a clue. This access program has been working on my pc for a very long time. The references haven't changed and it works on other peoples machines. All function calls are correct and all spelling - is correct. Nothing has changed. Thanks.