Search results for query: *

I have a routine that opens an Excel 2003 workbook, retrieve some custom properties and loades to memory for use, then closes the Excel workbook. When there is only one workbook to check there is not a problem because when the access appliation is closed it kills the specific Excel process...

Greetings, I have an application that I am trying to create some error handlign. I raise an error 513 when the status in the properties of a particular file is invalid. And a nother error is raised (613) when the version of the template (xls) file isn't the same as the access database version...

I have a template that does some checks to make sure the user has the right version and that they are running it from the right directory. It needs to be in the correct directory because it must work with the right databse. The code in my template checks the properties to get the current path...

I have a spread sheet that I need to run some data validations for. I am checking to see if a particular column is blank or not. First tried using countA for the column but it always returns a 1 even if I add several rows of data. then switch to counting rows and trying to iterate through...

I have an Excel spread sheet which serves as a template for users to request stock codes be created. There are several combo boxes tied to some ranges which provide them the ability to select what they want in that cell. I need to write a utility that will allow me to modify the properties for...

Sometimes when a file is exported to Excel where there is a "D1" at the end of the data it is being replaced with 00 or 0. Data accessed by Access shows some stock codes as 37244D1 but when they export it comes out 372440. Numerical portion "37244" varies. Numerical value after the D varies...

I have a large database that is used by many different users at the same time. It doesn't happen all the time but is sporadic in nature. folks will exit the database but then when they try to go back into it they get an error saying that the database needs to be repaired or it is not an access...

Trying to write an update query that will add some text to beginning of an existing reocord. Brief table description: * Tags table holds material identifications that are unique, they are to be placed in a particular location inside the plant. * PO_Lines table holds line item details for...

Does anyone know the Schema for Primavera Expedition 8.02 or know of a good forum one could go to? I just took over support of expedition here at work and need to have a better understanding of the tables and how they relate. Any help would be greatly appreciated as I am not getting much...

Greetins, I am trying to build a query that displays a value based on the values of a couple of fields. Similar to: iif([Material_Type] = "Bulk Materials",iif([Material_ID] like "PVV*","Bulk Pipe",iif([Material_Type] = "Bulk Materials",iif([Material_Type] Like "FBB*","Bulk Hanger")) as "Bulk...

Greetings, I am trying to figure out how to select which validation list to use based on value in another cell. Background: I have four lists on a second worksheet in the same workbook. The first list provides names of states (Oregon, Washington, California). The second list is a list of...