User Profile
lwestberg
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
MS ACCESS wont read Form Variables as query parameters
I use form variables as parameters in my queries. I have been doing this for 25 years in Access. Recently I have noticed that some of my queries are showing null values for form variables that are present on the form and I can see there is content in them. I can even see data in the immediate window when I reference the form fields in question, but doesn't work anymore in the query. What would be the reason that referencing a form variables in a query would not work (would not retain the data in the parameter that references a form variable)? EX: SELECT tblLoanTypes.LoanTypeCode, tblSDSTeam.ScheduledAttendancePerWeek, tblSDSTeam.StartDateThisAcademicYear, tblSDSTeam.EndDateThisAcademicYear, tblSDSTeam.AwardPeriodBeginDate, tblSDSTeam.AwardPeriodEndDate, tblSDSTeam.NumPaymentPeriodsInThisAward, tblSDSTeam.StudentProgramEnrollmentId, tblSDSTeam.StudentAcademicYearId, tblSDSTeam.StudentAwardId, tblSDSTeam.ExportDate, [Forms]![frmMain]![cRecId] AS Expr1, tblSDSTeam.ScheduledAwardAmount, tblSDSTeam.ScheduledAwardAmount, "R" AS Expr2, [Forms]![frmMain]![cSeq] AS Expr3, Left(Trim([StudentId]),9) AS Expr4, tblSDSTeam.AwardYear FROM tblSDSTeam INNER JOIN tblLoanTypes ON tblSDSTeam.AwardType = tblLoanTypes.LoanType WHERE (((tblSDSTeam.StudentProgramEnrollmentId)=[Forms]![frmMain]![nStudentProgramEnrollmentId]) AND ((tblSDSTeam.StudentAcademicYearId)=[Forms]![frmMain]![nStudentAcademicYearId]) AND ((tblSDSTeam.StudentAwardId)=[Forms]![frmMain]![nStudentAwardId])); The query above worked fin until a month ago. But now all of the form variables are not making it to the query with data in them. I compacted and repaired, re-created the tables and queries from scratch - with no luck. Any help is appreciated. Microsoft® Access® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20066) 64-bit Windows 11 pro with 32 GIG Ram309Views0likes1CommentAccess lock file filled with chinese characters and unrecognized database format
We have several MSAccess Databases that have worked fine for year but recently we are getting unrecognized database format sporatically first thing in the morning and a compact and repair does resolve but it is becomeing to frequest. the .ldb or .laccdb files have chinese characters in them instead of the computer name information it normally has. Example below 䕄䭓佔ⵐ䵕䡐㠵A††††††††摁業n††††††††††††† We are using Windows 10 with Office 365. Server 2019. Access build 12730.20236 and version number 2004 I see a new build comes out May 4th to resolve some corruption issues but we have not received it on our channel yet Any other ideas while I wait for the build to apply?3.2KViews0likes4Comments
Groups
Recent Blog Articles
No content to show