Microsoft Access / VBA Forum

New to using VBA in MS Access, please be nice. When the user click's a button, I need the button to move only that row onto an existing table. Example, something needs to be recycled, user clicks the recycle button and it moves that row of data to a recycle table that holds all the recycled rows. I've spent 2 days working on this new...

Introduction By default VBA makes direct file I/O very hard to find. So much so that many will swear it isn't even supported. It is. AND, it does the job extremely fast. This Class Module handles direct file I/O as well as buffering. It even provides a routine for searching through a file for a simple string, as well as a simple string...

Greetings... I'm looking for help; is there a way to allow "certain" duplicate entries in an Access table and still be able to restrict others? I have a entry access database for tracking visitors. On the access table itself, there's a column for a visitor badge numbers. However, since that column is indexed and won't allow duplicates. How...

I have 2 tables, one called Reminders and the other one is named Preset Events. The tables are not joined. The Preset Events table mirrors the Reminder’s table except it does not contain the Date field or the Person’s ID associated with the event. The Preset Event table contains default values for a given event, i.e. for a wedding anniversary, I...

As the forum has apparently gone into hibernation recently, I've got two questions that I will post and hopefully wake things up again... As part of my work on making Access apps as secure as possible, I already have code to detect the state of various properties and where these have been changed, the application quits automatically. For...

This is a curiosity I discovered by accident several years ago. I've raised it at several other forums since that time but never had any response to the question. Perhaps this time will be different If you open the VBE and press Ctrl+T, a Components dialog appears with two tabs: Controls & Designers. ...

Loan amount of 20000 was given out to be paid in 4months, 5000 each The first month 5000 was paid, but the second month was not paid. So how can it be done such that the 5000 for second month will appears as OVERDUE. which query can do that?

hi buddies. i am working on MS Access Purchase system . i made a form with a subform name PurchaseForm contain ID, ItemName, ItemQuantity, ItemPrice, TotalPrice and i made and Item Listbox name ItemBox contain items names. i want to click the item name in listbox and it fill into subform itemName. as i click the item fill in box and another...

Hello, access 2010. I would like to enter the serial number following criteria: year (21) month (xx) 0000 (progressive). It must automatically generate it in the order form. Thanks so much

This isn't so much a question but information about an obscure bug in Access ...and a workround Last year, a fellow Access developer reported this to me as I work extensively with what I call 'deep hidden' tables using property dbHiddenObject (MSysObjects Flags=1). If a table containing data in attachment or multi value fields is 'deep...

{This thread has been created as an offshoot of Adding Time in Calculated Time Fields returning as Strings} I have gotten a bit of user feedback, I have a question I would like to ask. If I wanted to set the form fields to unbound and use a button to append the resulting info to a table, how would I write the append expressions in VBA? MON:...

For starters, I'm not asking the usual question about how to link the records in a subform to the main form. I know how to do that by linking Master and Child fields. The problem I'm trying to solve is that Access won't allow split form view on a sub-form. A scenario: Assume there are two tables, like this: Table1 - Invoices InvoiceNumber as...

Hi I need to edit a specific record on a main form using a popup form. this is the code: Private Sub resetThisForm(strAction As String) On Error GoTo ErrorHandler Dim rst As DAO.Recordset Select Case strAction Case "Swap"

Hi. I am using Access 2010, I have a table like below. In a form, I have a combo box linked with the NAME field and have a buttonm, COPY next to it. ID NAME NUMBER 1 BACH 1-1212 2 MOZART 2-2323 3 BEETHOVEN 3-4343

hi friends. how we can print barcode copies. for example i have one item like Tea mug quantity 20 how i can print the 20 barcodes copies on one report.

(@niheel - I love the new UI!) Friends, I have a tiny little FE that manages some data updates that I receive from various places. Because anyone could use this FE from anywhere and access the files from anywhere, the FE needs to find the files, and then link the data tables to itself. All this work perfectly. However, I have noticed that...

Hi, I have an access database that handle sales and shipping. In the shipment form, user can click a button to take following actions. 1. Check largest invoice number in the order table then add 1 as new invoice number to be assigned to current order record. 2. Add new record to two tables associate to invoice payment: and . There is...

The annual Access DevCon event will this year take place on 22/23/24 April. As was the case last year, it will be a virtual conference and the programme has just been released. Full details of the conference agenda can be found here. Registration and pricing is available here. As always it is likely to get fully booked quickly

Hello Friends, 'Tis me again, with what might possibly be a very simple question, but one I just don't know where to start searching. I will begin with an example that should make sense to everyone, then describe what I am trying to do. First, a common example. Let us say we are working with an object. An object has properties, some of which...

I am needing to evaluate a record set and remove records. My table has multiple Records with Unique Effective Dates by Action. I need to compare each record to the next record and remove the record in the table if the Action in the record below it is equal. I started with a simple OpenRecordset for printing to identify database and record set...

i created an append query in which i need current to be append into another table. SQL INSERT INTO PaidFeeT ( FacultyPaid, MonthYearPaid, SecurityFeePaid, AdmissionFeePaid, TotalFeePaid, SR ) SELECT FeeT.Faculty, FeeT.MonthYear, FeeT.Security, FeeT.AdmissionFee, FeeT.TotalFee, FeeT.ID FROM FeeT WHERE (((FeeT.SR)=!!)); from the form its...

On a form, I have a combo box with list of tables using 'msysobjects.name'. I want another combo showing list of fields of the table name selected in first combo. How is this possible? Please help me. Thank you.

Hi, I am trying to create a form, that will randomize data from a table. For example, I have a table called "tbl_master". It has 3 fields, sport, athlete, speed. I would like the form on a button press to take one random entry from each field. I have managed to do this with one field, but cannot figure out how to do it for all 3. What i have...

I have a table with 169 records and created a form. I wanted to add another field to my table to also show in my form. When I could not see the new field in Form Design view I went to Properties, Data Tab and changed Data Entry to Yes. After that I saved the form and went back to Form View and there was only 1 record and it was totally blank. ...

is it possible to get the search feature to function if an entry matches more than one category? We built a data base for contacts and many contacts match more than one of our categories. We are finding the search box no longer works once we entered contacts and matched them up to multiple categories. As an entry person, I am at a loss...