Forum Widgets
Latest Discussions
Application.SaveAsText posible Bug
I'm discovering the powerful Application.SaveAsText and LoadFromText methods, never used before, and found that Application.SaveAsText acTable,... always produces an Error 2.487: The Object Type argument for the action or method is blank or invalid The method works flawlessly with any other ObjectType. I've tested this behavior in a bare new accdb, with a single table in it, in three different systems (win10 & win11), all yielding the same result. My Access is 365 2508 (32 Bits) May someone check if it is a bug?SolvedJF_RuizSep 10, 2025Brass Contributor36Views0likes2CommentsAdding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?viclea8Sep 09, 2025Copper Contributor197Views1like12CommentsVBA
Hello everyone, I'm new here, so please be kind! This happens every time I create a new file, and Visual Basic Editor won't open in Access. When I click on 'Visual Basic', a pop-up box appears and I'm told that the database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all codes from modules, forms and reports. You should backup your database before attempting to delete the VBA project. Note: To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK. Well, I have no database to read in the first place because I haven't made one, so what does it mean, and how do I fix this, please?NumSep 04, 2025Copper Contributor73Views0likes4CommentsAdding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?rehanademon3Sep 02, 2025Copper Contributor26Views0likes1CommentPictures are not displayed in report
Hello, I have a serious problem in Access 2016. Our database is running on multiple machines. Most access databases are running without any problems but some access databases do not display the product pictures in reports (jpg format). The strange thing is that the pictures are displayed correctly within the forms. The pictures are not embedded but shown as link. Any ideas how to fix this? Tomwater645Aug 29, 2025Copper Contributor2.1KViews0likes4CommentsIn form or report design view, cannot paste objects
Hello all. I have used MS Access for over 20 years as a user (not developer). I like to design forms and reports from scratch (not using wizards), and it is handy to copy and paste objects in design mode. This includes controls, labels, lines, buttons, etc. For example, in a tabular transaction-type report, I can copy already-formatted controls from the detail to the report or group footer and just edit each to be a sum. For the last several months, I can click Copy on the bar (or ctrl +c), but the paste icon does not light up and ctrl + v does not work. Sometimes if I wait long enough (like several minutes later), the paste function becomes enabled. It takes me substantially longer now to add new objects from the Report Design bar and reformat them to match the existing report or form. I don't know if this is an Access issue or a clipboard issue. I am able to copy and paste large volumes of data with no problem at all. I am thinking about re-installing my Office 365 (which includes Access). Has anyone else had this problem, and is there a solution? The version I have is Access for Microsoft 365 MSO (Version 2503, Build 16.0.18623 20076 64-bit)BeanCounter0792Aug 27, 2025Copper Contributor564Views2likes15CommentsWhat's the cleanest way to skip NULLs when looping through Recordest in VBA?
I've been working on a legacy Access app, and I find myself looping through a DAO recordest to process a bunch of fields. The thing is , some of those fields occasionally contain NULLs, and I've noticed they can easily break logic when you're not careful, especially when doing string concatenation, arithmetic, or conditional checks. I'm doing something like this : If Note IsNull(rs!MyField) Then ' Do something with rs!MyField End If Which works, but when you've got multiple fields or are writing more compact logic, it starts to get messy real fast. I'm wondering. Is there a cleaner or more elegant way to handle or skip NULLs ? PS ; I am having issues with the code editorJalessaAug 21, 2025Iron Contributor72Views1like2CommentsACCDB Files wont open in MS Access 2024
I have a group of ACCDB files that originally were MDB files and over the years have been upgraded to more current versions. These files do not open now with the current desktop version of MS Access. An error message is generated about the file being an unrecognized database format. There are several files that present the same way, not just one. If only one, perhaps it could be a file corruption. Of course, I no longer have the ability to use previous versions of MS Access to try to open these files. Any thoughts are appreciated.FLA-MLAug 21, 2025Copper Contributor58Views0likes1Commentver2507 bug
I got an Access 2016, it updated itself to version 2507 (build: 19029.20156). Since then I can't use the linked table management interface. I can't refresh linked Excel sheets. The Version 2507 (Build 19029.20136) was still OK, but I can't downgrade my Office 2016. Is there any solution?PZ77_Aug 20, 2025Copper Contributor311Views0likes8CommentsCalculating Age In Access
Hi All, Just got a question regarding calculating ages in tables in access. I am on Access 2016, and I have two columns, DOB, and Death Date. I only have one entry for a death date, and if there is not a death date I want to calculate it from today. Would I use a Calculated Field Type? What would I put in it? I found some Vba code, but I don't know how to put that into my table.Jqws13_Aug 19, 2025Copper Contributor6.1KViews0likes7Comments
Resources
Tags
- access1,673 Topics
- office 365372 Topics
- 2016201 Topics
- developer196 Topics
- Access Web Database102 Topics
- Access Web App57 Topics
- sharepoint53 Topics
- 201352 Topics
- 201042 Topics
- admin42 Topics