Search results

I've built this SQL using VB: INSERT INTO tblTemp2 (Contract) SELECT PHT_CONTR_NO FROM VB22.PRICHIST_TRUCK WHERE PHT_CONTR_NO = 'LPS790848'; When I execute it it returns the following Err.Description: "SFHOFFM.TBLTEMP2" is an undefined name. SQLSTATE-42704 I can see that the issue is...

Is there any way for me to bypass the DB2 Connect prompt for Logon ID and Password? I'm creating an application that needs to access a DB2 security table that the users are not allowed to view. I'd like to be able to write a piece of VB code that passes a Logon ID and Password to DB2...

Here’s the problem: When I execute the following line of code: Format(X, "000000") Where X = "0S111", It returns: 0S111 Which is what I want. But... When I execute the same line of code where X = "0E111", It returns: 000000 Which is NOT what I want. I wanted it to return: 0E111 Any...

When I try to import an Excell 2000 spreadsheet into my Access 2000 application NOTHING happens. In other words... I click on: File / Get External Data / Import - The Import window opens. I highlight the Excell spreadsheet that I want to import. I click on the Import button - The Import...

I'm in the process of converting a bunch of my company's Access 2000 databases to Access 2007. One thing I've noticed that is going to be a HUGE problem for my users is that the hourglass and status bar do not stay on continuously from start to finish when pressing a command button that runs a...

Last Friday one of the users of a production Access database came to me saying that the database was empty. I checked it out and it was missing all the tables, queries, forms, marcos, etc. Later that day I found another Access Database in the same condition. We had some network problems...

I was inside the workspace trying to open a query in design view. It came back with an error message "Disk or Network Error". Then when I tried to get back into the workspace it said that I needed to repair the database. I tried to repair the database and when it was finished it said that...

When I try to compact and repair my ACCESS 2000 database I get the following error mesaage: "The Miscosoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time." All of my tables are local and I am the only one using the...