Search results

Recently I have heard from a forum member that one should not mark a table field as "indexed" before adding a query that selects records based on said FK field, claiming that Access will (sometimes?) create a duplicate index (if you create the relationship before marking the FK as indexed or...

Good day all, I am making a personal investment recording/stat database for myself. I want to make a form that 'browses' the transactions, so I can easily and quickly verify that my database is working properly. I have a transactions table, a table for the long text descriptions, and account...

Hello, I'm trying to write vba that copies fields across TableDefs - I just want to be able to do that, as a learning exercise. I have written the following code to do so, but I get Error 3367: Cannot append. An object with that name already exists in the collection. In the line...

Hi, I just ran into the situation where I may want to pass a couple of recordsets to a function/subroutine. Pardon me for asking, but when I google this I get hundreds of misses on the hits. When you pass a recordset to a function/subroutine, I understand this is a copy, not a single shared...

Quick Q: Why is my vba recordset not sorted? I am doing some pretty advanced data validation and error-correction using multiple vba subroutines (let's not get into that as it will take MUCH too long to explain). My subroutine works most efficiently if the recordset data is sorted according to...

Hello again, I am making a database for a institutional reporting and error-finding tool in a Sharepoint table. I have a complicated vba query that runs on several thousand records (currently, and will grow with time) and a few dozen fields per record. I have ran this before successfully, but...

Hello, As some of you might have noticed a few months ago, I have a very complicated and automated multi-institutional database. Here is the problem: I have a form and subform that selects a person's record, to fill in that component of another form. Sometimes the button works, and other times...

Hello again, I have a split database on an institutional network, a very complicated front-end with dozens of forms that interact, many interact with each other via vba. I am using a method that implements 'live search' technique in the affected form. The problem is, as soon as I click on the...

Hi again, I have been having some trouble with improving my 'live search' form, where it shows results as you type search criteria. Because the "requery" function interferes with the cursor in the criteria input textbox control, and I have to transfer the .Text contents into another control for...

Hello, I am trying to manipulate data from an Access table linked to Sharepoint, in a new database in Access 2016 or Office 365 Access. I have the link working successfully. In particular, one field that I have to do some conversion on to convert it to a numeric value. Unfortunately, it is a...

Hello. I have been redoing some of my old fieldnames in Access, there is several of them I want to fix capitalization in. I have fixed them in the forms, tables, and queries. But when I go into the visual basic editor and attempt to fix the capitalization, the editor keeps undoing it, even...

I have vba code, in a form, that opens another form in add record mode, that works fine until I try to add "Option Explicit": DoCmd.OpenForm stDocName, , , , acNewRecord, , StOpenArgs It doesn't like "acNewRecord". The problem is, looking at the OpenForm syntax, I cannot find an enumeration...

Hi all, I now have a very minor issue with my database. It is a large split-database, on an institution server, with two front-ends for two institutions who share the back end. I have completely reworked and improved the front-ends, adding a lot of functionality and procedure checks. Only one...

Hi, I am working on a mass-record maintenance/modification form, within a FE, to enhance old records to add field information and correct the current information on past entries with typos (hundreds of records) for an institution. The main form does not have any associated "source," and all...

Hi, I am new to Access forums though I have been programming complex vba into Access databases for an institution for several years. I have been using Google searches to help me with my bugs, and so far have always been able to either find the solution or a (better) workaround. I have created...