Microsoft Access / VBA Forum

{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:...

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...

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

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...

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?

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. ...

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...

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...

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...

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...

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...

Hello Everyone! My EmployeeData tbl contains a field PPID_Data (number field). I am using this field to lookup values from another table called PayPeriods, which contains all the data for the year 2021. SELECT PayPeriods.PPID, PayPeriods.PP, PayPeriods.StartDate, PayPeriods.EndDate FROM PayPeriods ORDER BY PayPeriods.PP; ...

Dear Bytes comunity... I'm trying to speed-up the way I'm interacting with big strings. I have an string with more than 2M caracteres and would not like to use the function mid$ to read, and change a specific character. I'd like to use VARPTR or STRPTR, but I could not understand how to access the memory to get the content of a character...

Hi was wondering if this filter is ok to be shortened this way: Month()=1 AND Year(DateProcessed)=2021 OR Month()=2 AND Year(DateProcessed)=2021 OR Month()=3 AND Year(DateProcessed)=2021 changed to Month() IN(1,2,3) AND Year(DateProcessed)=2021 Thanks

I am using access for storing records for our cemetery. I have a form to enter information for new interments. I would need to have a button that will take the user to the file location of the headstone picture (jpg) display the picture and save it on the form. I know next to nothing about coding so something I could copy and paste would be...

I have a form that is used for creating orders of products on my database. My goal is to subtract the order.quantity field from the stock.stock_quantity field through the use of an update query. In order to target the specfic stock record, when the customer picks which stock they want in the order form, I use the order.stock_id field to pick which...

Hi, would like to filter a form with a form filter, the form has 12 buttons (12 months) and would like to retrieve records depending on which button is pressed. This filter example works, it shows records from Jan, Feb, and Apr 2021 but I don't get why it shows them all. Should't it show just one month because I used OR? Month()=1 AND...

I am attempting to perform a Do Until...loop which should search all records in a given recordset while looking for an email address from a particular field. A separate field in a table that has a null value will update when the loop is executed. My problem is that everything else is working except for when the email is sent, it only sends an...

I have an Access form with a history subform embedded in it. The history subform consists of years, 2001, 2002, 2003. When someone renews a membership, I add the year to the subform. Always before the year went at the bottom of the subform and stayed there. For some reason the last few entries I made puts the year in the penultimate row, not the...

I have two combo boxes, one is make and the other model. The Make combo pulls from a make table, and the model combo pulls from the model table (which has make and model fields). I want to have the Model Table to only show those models that match the Make Combo. How can I do this?

I am tasked with tracking Overtime hours worked by Department/Employee. Our work week is 35 hours, first 5 additional is Straight Time, any additional is OT (at time and a half). Tables collect Week of Date, Employee, # of OT Hours and Department. I initially attempted to use a running sum in the report and can't get it to work correctly. Now I've...

we have developed an application on Ms access database and working on this application since 2017 and have a lot of data stored in this database, we want to integrate via API ms access data base to send sms service to our client , is it possible , if yes then please send VBA Code

hi buddies.... need your help kindly see the image. i made a report of all students fee i want to print this report on one legal paper with 30 records with total sum of their fee/page. Explain: for example i have 400 students and i print the whole database and in last i get the total sum of the fee. so i want to print only 30 record of...

Howdy Folks! I am working on a project where I have been given Domain\Usernames (Contoso\JSmith) and my data dump has records containing the Domain\ and no user name, Domain\administrator, and Bogus Domains that I need to remove with delete queries. I am looking to isolate both the left and right of the "\" to remove garbage items, but I need...

Hello dear friends I want an idea for How to create Balloting of a Housing Project Plots.... There are two files.... one for Plot Numbers and other for Customers details... What to do for balloting ... looking for an idea or any demo... thanks irsmalik