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]

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

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 =...

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

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'm getting the following error on the MS ACCESS REPORT #Name? Am I missing an ocx control or dll???? Please help. Thanks. [ponytails]

How do you run a DOS based app in a Windows XP environment? The application is called RodePC. It is a very old data entry application developed in early 90s. Why don't we upgrade it to something new? No money. Any help would be greatly appreciated! Thanks! [ponytails]

I am reading an integer value from a SQL Server. When printing this value to a file, I need to take up 8 positions, with the actual value (more than likely taking up 1 -3 of the 8 positions), being in the rightmost position of the 8. Is there a command in Visual Basic which pads 0s to take up...

The following code is blowing up on the Myset.Master_Flag sentence - VBA is actually highlighting the Master_Flag which is a field in the recordset it is referring to. I'm using DAO 3.6 in the reference field. How do I fix it? Dim MyDB As DAO.Database, Myset As DAO.Recordset Dim Response...

Can you find the syntax error here?? Dim externdb As Database 'this is the odtagdb database Dim sql As String Dim Rows As Integer Dim today As Variant today = Now 'update odtagdb If Not opt = "0" Then Set externdb = OpenDatabase("", False, False...

I donot understand this error message I'm simply calling a procedure and it blowing up when it tries to enter the procedure. Can someone help?? I'm getting user defined type not defined: Here is the calling procedure: Private Sub 'Maximize the windows Me.WindowState = 2 If enter =...

Can anyone tell me how to fix this? I have a VB front end connecting to a local microsoft access database which has a link to a SQL database. The DSN is all set up. I am writing to the SQL database through the linked connection in MS access. When the MS ACCESS database links were setup, an...

I am receiving the runtime error 3078 along with the verbage, "The ms jet database engine cannot find the input table or query ____________. Make sure it exists and that its name is spelled correctly. I am connecting to an Oracle database. The name is spelled correctly and everything else...

I have a microsoft Access application which I have installed on another machine. The other machine does not have MS access installed. So, I installed runtime access and the application. The MS Access App will not run on the machine. I get some bogus error which is asking for an enty, you hit...