Search results for query: *

Hello all. I developed a simple MS Access 2002 database (.mdb) with a few forms that have custom code. I initially used ADO 2.7 libraries. I sent it to a person in an entirely different department who is using Access 2000. She's repeatedly getting "Method or data member not found" when she...

Hello all. I'm trying to test some code that's executed by an Access form, but am encountering what seems to be some inconsistent behavior. This form is used for data entry and has many tabs on it. The first tab has THE four required fields. When they change a combo box on another tab, it...

Hello all, We're migrating a large volume of data from an ESRI personal geodatabase stored in MS Access to a ESRI ArcSDE geodatabase stored in Oracle. The actual migration process must use ESRI proprietary objects that are necessary to ensure the spatial data and the related spatial indexes...

Hello all I'm working on a legacy database created by another person. It has a form whose record source is a select query. The form has a combo box, which is not bound to the record source, on it that can be used to 'jump' to a record in the query by typing a unique file number into it...

Hello all, I'm stuck on this query. I have a Parcels table which has a record for every parcel such as ParcelID -------- Parcel1 Parcel2 Parcel3 Parcel4 I also have a land use table that relates to the parcel via the ParcelID. A single parcel can have many land uses. ParcelID...

Hello all. I'm seeking a fast routine that will list all files (by file name) in a given directory that were created after a particular date and time. This will be run in ESRI's ArcGIS and that software has its own 'Application' object. Consequently, it could get tricky if I attempt to use...

Any free code or COM dll's out there for printing to PDFs? Ideally, it will work any printable document ... similar to using PDF Distiller from Print Menus. But I would like to be able to programmaticly specify the output directory and file name? I intend to use this for saving Access reports...

Hello all, I have a bar chart in a report that is based on a query. I manually stretched the bar chart so that it fills most of the 8.5" by 11" page (if it were smaller, it'd be difficult to read). The bar chart renders correctly, but there are 41 pages in the report, all with the same exact...

We're scoping SSE 2005. I image that SSE 2005 maintains a transaction log? Is that correct? If so, would you be able to do a point-in-time recovery of a SSE 2005 database using the FREE tools that you can download along with SSE 2005? Scenario: We have complex processes that insert, update...

Hello, We are considering migrating several of our access databases/apps to the SSE 2005 back end. The Microsoft site says that the DB size is limited to 4 GB. More literally: "4 GB maximum database size". Does that mean that one can only store 4GB of data on the database server period. Or...

Hello all. I've decided to go with the RAID0 (striped) and back up my files onto my other PC. The to-be RAID0 box has a 100GB HDD and an 80GB HDD. In the RAID set up utility, it indicates that if striping is used, I only have an effective capacity of 160GB (80GB + 80GB), which makes sense...

Hello all, My father recently gave me his 'old' PC, a VPR Matrix 226R. I have a Windows XP install disk and I've decided to completely reinstall XP since I won't be needing a lot of the software he has on the computer - I also want the improved performance that you get with a fresh OS install...

Hello all, I'm accessing data in an Access database using ADO and VBA .... something I have to do quite frequently. But when trying to read values from a recordset, I'm getting null values. I'm totally stumped. It's probably easiest to explain just posting the code first Dim GP As...

Hello all, I'm executing an update SQL statement on an Access database with an Oracle table that is linked in the .mdb file. Then I need to programatically execute a select query on updated Access table. However, the update isn't completing before the subsequent Select query is run...

....that the action is completed before the next line of code executes? I HAVE been reading the ADO documentation about this, but am having trouble following the example because I don't understand C++ very well.....hence, I'm asking here. As a part of a long series of VBA/ADO/Access code, I'm...

Hello, I walked up to our county codes office where I typically copy building permit data to a disk for use in our reporting system. I need data from last month, so I set up a make table query with the WHERE "criteria" being >#5/31/2005# And <#7/1/2005#. As the query was running, I got an...

Hello all, I'm attempting to create a VBA macro within a Microsoft Access .mdb file that is launched by clicking a button on a form. We'd like to use ADO because this database may one day be ported to a RDBMS - planning for the future. Anyhow, I'm attempting to open a recordset using the...

I'm just curious how many lines of code I've written in this project so far. Any utilities out there that will do this? - VBA only (not VB)? Thanks! AZ

Hello all, I'm developing a program that manipulates data in an Access database via ADO. This program run completely outside of MS Access application (it's executed via the VBA editor of GIS software, not Access). In her article titled Relationships: Your Key to Data Integrity in Access ...

Problem with combo box in a select query with a join Hello all. I have a table with a text field that is restricted to a value list via a combo box (I specified the “look up wizard”, chose value list, and entered two the two options that the user can choose from). When I open the table in the...