Forum Widgets
Latest Discussions
Query error 3141
Yesterday I started my Microsoft 365 free trial. I created a database and made a query, when i tried to save the query i got error 3141"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" but the spelling was correct. So i tried a new database and got the same error again when saving a query. This error happens with multiple different types of queries across multiple databases and when i download a database with a query already in it and copy the code from the already made query into a new query it still gives the error 3141 even though it works in an already made query. I assume this has something to do with my Microsoft Access. this is the query i made: SELECT * FROM ttblTraits;
Access changing lettercase - redux
This has probably been beaten to death, but I'm fuming, so here goes. I want Microsoft to DO SOMETHING to help. Access has the highly annoying habit of changing lettercase on identifiers, seemingly at random. This is a real pain when using add-ins like MSAccessVCS, which makes it possible to use git for source code control. Here' what I've deduced is happening: There exists a dictionary/symbol-table containing every identifier used in a project. The symbol table contains ALL identifiers, including those defined by MSAccess, referenced libraries, and your code. Searching that table is case-insensitive, but it stores the canonical version of the identifier with case preserved. Normally, when you type an identifier that already exists in the table, the VBA editor "corrects" the lettercase of your entry to match the table's entry. The extremely annoying part is that sometimes that last step works in reverse. You type an existing identifier, but with a different lettercase. Instead of correcting what you typed to match the table, it instead updates the table with the version you typed, and decides that's the way future and existing identifiers should be spelled. Here's a recent example. I tried to create a class module constructor (Class_Initialize) but typed it "class_initialize" implicitly expecting that the VBA editor would "fix" it. Instead, it updated the symbol table and set the canonical lettercase to the all-lowercase version... and then proceeded to change the lettercase on the Class_Initialize() method in all my class modules. It has now decided the canonical lettercase is "class_initialize" and that's what it "corrects" to from now on. Of course, when I did the next MSAccessVCS export, git showed a bunch of unwanted (but cosmetic) changes. This pollutes the changeset and makes source control more difficult. THIS. IS. A. BUG. My workaround is, when starting a checkin, I go through the list of changes and group all such changes into one commit called "VBA Artifacts". But come on, this shouldn't be necessary. At least let us know WHY this happens, and give us some control of the process. A way to specify/correct the canonical casing would help.
Select Query values not showing in report - MS Access
I'm probably missing something simple, but.. I have a Table that has 4 field (plus key), Company ID, Join Date, Quit Date, Notes. This tracks agency membership I made a select query, with 2 IIF statements, and 2 conversions. My Datasheet view shows correctly, but when i put the fields on a report, YRSCALC is empty, and doesn't sum, which affects Grand Total. I have tried every type of formatting i can think of.. Select Query: SELECT tblJOINQUIT.[Company ID#], tblJOINQUIT.[Join Date], tblJOINQUIT.[Quit Date], tblJOINQUIT.Notes, Sum(IIf([Quit Date] Is Null,"0.00",DateDiff("m",[Join Date],[Quit Date]))) AS NumOfMonthsCalc, Sum(IIf([Quit Date] Is Not Null,"0.00",DateDiff("m",[Join Date],Now()))) AS NumOfMonthsCurr, [NumOfMonthsCalc]/12 AS YRSCALC, [NumOfMonthsCurr]/12 AS YRSCURR FROM tblJOINQUIT GROUP BY tblJOINQUIT.[Company ID#], tblJOINQUIT.[Join Date], tblJOINQUIT.[Quit Date], tblJOINQUIT.Notes; Report View: Help??
Linking Access to Excel does not work
I have created a simple Access that is connected to a linked table to an Excel file as a data source. I can run the Access without any problems. It accesses the data and everything is fine. But when my colleague wants to run the Access, she gets the following error message "Microsoft Access “C:\Users\User\ [Source Path] .xlsx” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." We use OneDrive/SharePoint in our company and the colleague has access to the folder where the Excel and Access files are located. But it doesn't work. I think it's the path, as it seems to be local. But I don't understand why. This Access in turn serves as a source for another Excel (the target file). There it has a similar error message: ‘’Microsoft Excel [DataFormat.Error] “ [File Name] .accdb” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." I can open and run both the Access and the target Excel without any problems. Thanks a lot in advance. I appreciate your help a lot.In 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)
Changed systems 2/3 Working
I am not an Access Professional, and I inherited a system that was on a PC that is no longer viable. I built the new PC and named it exactly the same as the old one to mitigate any conflicts, and it is half working. We have a large database and 3 associated programs that add data and export data from that database. The 2 programs for adding data are working flawlessly with no issues. The program for exporting data is giving me error 3044 that there is no valid path, when I upload an Excel file to it to output a different Excel file. I do not understand how the path can be valid for the 2 programs for inputting data are working, but not the program for exporting data, when it's the same path to the same database. All I did was copy and paste the existing database and all its files into the same file location on the same named PC. Any Assistance is appreciated. The database is on a Windows 11 PC.
