Microsoft 365 and Office Access Other Other

1 answer

How to fix #size! and #type!

How to fix #size! and #type! from formula =Nz([asep])-Nz((Reports![Rep16_loc_reg]!Report12csub!col1)) in microsoft access?

asked

Chloe Roffe 20

accepted

Chloe Roffe 20

2 answers

Is Jetcomp.exe retired for mdb?

Has JETCOMP.exe utility been retired for mdb? We still have several clients who are using a .mdb database with one of our products and we had been using JETCOMP.exe in our troubleshooting these databases.

asked

Baker, Stacey 20

commented

Baker, Stacey 20

8 answers

Is Microsoft Access being phased?

I have heard that Microsoft Access will be phased out in 2025 and it will no longer be available at the end of this year. Is this true?

asked

Anonymous

4 answers

Please can someone help me with the following script

DELETE FROM PICKING WHERE([Alternate User ID (Locus)], [Date Of Shift]) IN (SELECT[Alternate User ID (Locus)], [Date Of Shift]FROMPICKINGGROUP BY[Alternate User ID (Locus)], [Date Of Shift]HAVINGCOUNT(*) > 1)AND(SELECT COUNT(*)FROM PICKING AS P2WHERE…

asked

Anonymous

3 answers

Can you use a variable value in a different variable's name?

Howdy. I'm pretty sure the answer is no, but I thought it would be worth asking just in case I'm not searching the right way. Can you use a variable value in a variable name? Like... v1 = "Test" v2 = "Hello" i = 2 Debug.Print v…

asked

Anonymous

5 answers

Access file converted to Excel - Data not lining up right

I have an old Access file that I'm trying to use for research, but I've had to convert it to Excel. The old database was used to track vehicle service by customer. However, I have entries in one table that do not tie to the other table and I can't…

asked

Anonymous

4 answers

Input Mask Code Not Displaying-Access

Hi all So I've followed the steps correctly to input a mask code for a table's phone numbers (Short Text, proper code, selected proper table, etc.), but it's not displaying in the Field Properties box. Therefore, I can't format/modify it. It only works…

asked

Anonymous

8 answers

My Microsoft Access Database's Saved Imports don't work

As of right now, I am running the most current Microsoft Access program on my computer. It should be close to the 2019 one, but I am uncertain if it truly is. However, I believe that the "saved imports" should work even in older versions. …

asked

Anonymous

5 answers

In Access 365, how do you export a table to a delimited text file using a file extension other than .csv?

I'm using a common dialog box (Microsoft Office 11.0 Object Library) to select and existing file or create a new one. I'm outputting a table to comma-delimited format. (I'll switch to semicolons eventually.) I do so by first placing the values of the…

asked

Anonymous

10 answers

Northwind Developer 2.4 missing Custom Ribbon

Is custom ribbon and MRU still available in version 2.4 of Northwind Developers Edition? I've tried opening the template on two pcs with Access 2021, but no custom ribbon. Custom ribbon works in version 2.3. Thanks.

asked

Anonymous

6 answers

Can you use a public function / sub to set a recordset, or query parameters?

I have the following code to set the parameters of a saved query, and then use that as the recordset of a form. Is there a way to do this in a public sub/function in a module? Just to avoid putting this block in the Form_Load of every form that needs…

asked

Anonymous

2 answers

VBA_Extras question

Howdy all. I bought MZTools around the start of my adventures with VBA. While I don't use nearly all the functions of it, the stuff I do use has made this learning and working process much easier, so I consider it WELL worth the money spent. But many…

asked

Anonymous

2 answers

How to run multiple queries with one button in Microsoft Access?

Hello all, I have a search form with a search button that runs a query on a table. You can search for number ID, year, and name. The search button opens another form that matches what was typed in the search form. The second form that opens up displays…

asked

Anonymous

2 answers

How to perform a page break in an Access FORM

I'm working with a form created in Access by someone else. I can't not talk to him about it. I have connected 2 excel files: address list and donor activity. They appear to be in the proper format, using the same column names. The form prints all the…

asked

Anonymous

12 answers

A Vision for Modernizing Microsoft Access - A Proposal

A Vision for Modernizing Microsoft Access Dear Microsoft Access Team, As a longtime user and admirer of Microsoft Access, I’d like to share some ideas for modernizing and future-proofing this remarkable tool. Access has been a cornerstone for…

asked

Anonymous

2 answers

Why does VBScript connecting to SharePoint require re-authentication on VM2 but not on VM1?

I have two virtual machines (VM1 and VM2). On both VMs, I'm using the same VB script with this connection string to connect to SharePoint:…

asked

Anonymous

5 answers

ฉันติดตั้งโปรแกรม Access 2013 ลงบน Windows 11 และเมื่อเปิดโปรแกรม โปรแกรมก็ปิดไปเอง ฉันไม่สามารถใช้งานได้ ต้องแก้ไขอย่างไร

ฉันติดตั้งโปรแกรม Access 2013 ลงบน Windows 11 หลังจากการติดตั้งแล้ว เมื่อเปิดโปรแกรม โปรแกรมก็ปิดไปเอง ฉันไม่สามารถใช้งานได้ ต้องแก้ไขอย่างไร

asked

Anonymous

7 answers

How to create a VBA code to search multiple fields in Access with one input box?

Hello all, I am having trouble making my search box work with all the fields. The PPNumYr field was originally a string and the numbers had leading zeros such 0197, 0297 and then I changed it to Numbers so the leading zero is now gone but there are…

asked

Anonymous

10 answers

Microsoft Access: Forms not visible since database split

Hello, I oversee a database that, since our team has grown I have split, so that each user has their own front end file. The backend is only the tables, as is standard, I imagine. For some reason not all of my forms appear when I open any of the front…

asked

Anonymous

2 answers

I am using Access Task Management database and event management template but i wanted to know how to use filter details form and how it can be created?

Dear I am currently using the Access Task Management Database and Event Management template. I would like to understand how to use the Filter Details Form and how to create one effectively. As I’m gradually learning Microsoft Access, I’m looking for…

asked

Anonymous

Microsoft 365 and Office | Access | Other | Other

Filter

Content

114 questions with Microsoft 365 and Office | Access | Other | Other tags

How to fix #size! and #type!

Is Jetcomp.exe retired for mdb?

Is Microsoft Access being phased?

Please can someone help me with the following script

Can you use a variable value in a different variable's name?

Access file converted to Excel - Data not lining up right

Input Mask Code Not Displaying-Access

My Microsoft Access Database's Saved Imports don't work

In Access 365, how do you export a table to a delimited text file using a file extension other than .csv?

Northwind Developer 2.4 missing Custom Ribbon

Can you use a public function / sub to set a recordset, or query parameters?

VBA_Extras question

How to run multiple queries with one button in Microsoft Access?

How to perform a page break in an Access FORM

A Vision for Modernizing Microsoft Access - A Proposal

Why does VBScript connecting to SharePoint require re-authentication on VM2 but not on VM1?

How to create a VBA code to search multiple fields in Access with one input box?

Microsoft Access: Forms not visible since database split

I am using Access Task Management database and event management template but i wanted to know how to use filter details form and how it can be created?