Microsoft 365 and Office Access Other Other

2 answers

My encrypted database on Microsoft Access does not accept my password, which I know is correct. How do I get into the database?

Cannot get into my encrypted database but I know I am entering the correct password. I'm the only one using the database. Moved from: Community Center | Not monitored

asked

Ron Patterson 0

commented

Tammy-Ng 5,265 Microsoft External Staff Moderator

2 answers

Access Delete query using an asterisk on the from table still yields 'specify the table containing the records you want to delete'

I have one table identifying records requiring removal from another table and I am being sure to use an asterisk for the table with records needing to be removed. But I continue to get 'specify the table containing the records you want to delete'. SQL…

asked

PETER CERVI 20

commented

Gabriel-N 9,545 Microsoft External Staff Moderator

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

commented

Chloe Roffe 20

5 answers

Access is not running any internal VBA code

I was working on a simple library data base with 5000 records. I am trying to build a report to look at the library by different criteria. I built the basic report which runs fine no issues. I try to add a simple test for "various artists" in…

asked

Richard Case 0

commented

Richard Case 0

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

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

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

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

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

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

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

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

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

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

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

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

i want to use access and i am using my phone sansung android via a Dex connection for a mirroring effect for more power usage. Can i use access

asked

Anonymous

8 answers

Access VBA Question

I have a question about adding lines to some existing VBA code. I'll paste the code in below then explain what I want to add to it. Sub CopyTemplateFolderWithUserName() Dim fso As Object Dim templatePath As String Dim newUserName As String Dim…

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

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

Microsoft 365 and Office | Access | Other | Other

Filter

Content

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

My encrypted database on Microsoft Access does not accept my password, which I know is correct. How do I get into the database?

Access Delete query using an asterisk on the from table still yields 'specify the table containing the records you want to delete'

How to fix #size! and #type!

Access is not running any internal VBA code

Is Jetcomp.exe retired for mdb?

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?

VBA_Extras question

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

Northwind Developer 2.4 missing Custom Ribbon

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

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

Input Mask Code Not Displaying-Access

Access file converted to Excel - Data not lining up right

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

Please can someone help me with the following script

Is Microsoft Access being phased?

i want to use access and i am using my phone sansung android via a Dex connection for a mirroring effect for more power usage. Can i use access

Access VBA Question

Microsoft Access: Forms not visible since database split

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