Search results

I can't fathom this one. I have a field called Current Status in a table. When I run a query I want to rename the field like this STATUS:Current Status No matter what I do, the field remains Current Status. I have tried putting square brackets around like this STATUS:[Current Status] but Access...

I have a table with two fields. Disp_Num represents the name of a parcel of land and PPID represents a unique parcel of land. Sometimes, there are duplicate PPIDs with different Disp_Num. These would represent overlapping areas. The PPID field is sorted alphabetically. Disp_Num PPID S-140651...

Somewhat of a problem: I have a mdb containing a number of tables, queries etc. The total size is about 40 Meg. when compacted. One of the tables is reasonably large. Only two fields, both text but only 12 in size however 400 thousand rows. Open/close/query etc no problem. About 20% bloat after...

I have a table that I'm trying to sort into different new tables or at least new fields. The original is like this: A B B C C C D E E and I'm trying to output this: A B B C C C D E E Is there a way without using vba to iterate through the table?

I'm not really looking for code, just a clue as to what to read up on as I have been beating my head against the wall with this one. I can do it in about three steps but I am trying to do it in one. :confused: The first table1 is like this: id Field1 Field2 Field3...

I can run this sql from another db in the 'access vba enviroment' and it runs fine. There is a function 'GetOwners' used in the query. If I try within the 'arcgis vba enviroment', the function isn't recognized. Any thoughts? This is the query Public Sub MakeSearchBook() Dim Mydb As...

I am making a dbf file with code under a button on a form in arcview with the data for the dbf coming from a query in Access. If I have Access open the routine runs fine. If it is not open, I can loop through the table names and delete a table. Things come crashing to a halt however as soon as I...

This runs fine within Access from the design view but has a syntax error when running from witin vba. Any eagle eyes? strSQL = "SELECT AllDisp.[Disposition Number], [lsd] & "-" & [section] & "-" & [twp] & "-" & [rge] & "W" & [m] AS lands INTO tblCreateNewLands " & _ "FROM AllDisp INNER JOIN...

I have a table that has mainly text fields and a few number fields. These number fields are simply a code to joined tables that contain repetitive text. I want to export the data with the text instead of the number code. The query runs fine and has the text where it should be but the export just...

We got told this morning that A97 is out and AccessXP(2002?) is in. I converted the mdb. Once the reference to DAO 3.6 was added, all seemed fine until I tried running a query that uses this function. ' Use this one in queries Public Function DAmountApplied2(Dispos As String) As Currency Dim db...

I'm trying to update a db by copying new tables into it. Actually I've already got them in there, I just have to dance with the names.What I have is five tables in three flavors: newtablename - just imported to become current tablename - the table that was current tablename-bkup - the...

Our department is switching from a DOS based Q&A database to Access and we have to run both concurrently for the next year til they get some confidence in the new db. Virtually all the fields are text in the Q&A. I've managed to make the transfer of text data reasonably smooth. The only problem...

I have a form with a sub form and sub-subforms. My main form's recordsource is simply a two field table. A keyfield that is 1-1 with the subform keyfield and an autonumber ID field. This was so that I can do an editable qbf on bound fields in all forms/subforms. This works fine. I need to track...

After crawling through the labyrinth of subforms, synchonization, querydefs (three levels of them) to arrive at the promising land of a functional database with multiple subforms complete with cascade update and delete and even an on error or two, I ventured further and struck out for the...

I want to use a user defined function in my query. This is the function. Public Function GetOwners(Dispos As String) As String 'MAKE THE OWNER string Dim qdfGetOwners As QueryDef Dim rstGetOwners As Recordset Dim strSQL As String Dim strOWNERS As String Dim db As DAO.Database Set db =...

I have a form with several subforms. Each subform has its' own associated table. The subform tables are in a one to many relationship with the main form's table. I'm doing a QBF from a single form with unbound text boxes. The plan is to to create a filter for the key field that I plug into the...

I have a problem with using filter by form in my access db. My db has a main form with two subforms. Everything works as it should until I use the filter by form button. My criteria are accepted on the form, the records are filtered and the correct number of records are listed in the record...

I'm very slowly making headway with a db that is tracking property titles among other things. The problem I'm having is with a method to "ditto" certain fields as I enter new records. The main table holds a number of fields with DispositionNumber as the key. A second table holds property holder...

I have a form with a subform. The main form has a bunch of data in one table and the subform has more specific info. The tables are joined in a one to many relationship. When I delete a record in the main table from the form, I want the related records in the other table also deleted. I tried...

A variation of the carry forward exercise. I have a form that handles land parcel information. I have two tables, unique information and multiple information. The unique information would be something like area, parcelID, renewaldate etc. The multiple information would be something like...