Forum Widgets
Latest Discussions
Update Query - 3 criteria
Hello Experts, I need to update 3 fields in a table Import_ExcelPC but I am not getting anywhere with it. Let me explain what I need in simple plain english Update: Import_ExcelPC.Notes to the value show in [Import_ExcelPC_Copy].[Notes], Import_ExcelPC.OKToPayYN to the value show in [Import_ExcelPC_Copy].[OKToPayYN], Import_ExcelPC.DABYN to the value show in [Import_ExcelPC_Copy].[DABYN] but its for records where [Import_ExcelPC].[Invoice amount] = [Import_ExcelPC_Copy].[Invoice amount] AND [Import_ExcelPC].[Invoice No Stripped] = Import_ExcelPC_Copy.[Invoice No Stripped] here is my sql: UPDATE Import_ExcelPC INNER JOIN Import_ExcelPC_Copy ON (Import_ExcelPC.[Invoice amount] = Import_ExcelPC_Copy.[Invoice amount]) AND (Import_ExcelPC.[Invoice No Stripped] = Import_ExcelPC_Copy.[Invoice No Stripped]) SET Import_ExcelPC.Notes = [Import_ExcelPC_Copy].[Notes], Import_ExcelPC.OKToPayYN = [Import_ExcelPC_Copy].[OKToPayYN], Import_ExcelPC.DABYN = [Import_ExcelPC_Copy].[DABYN] WHERE (((Import_ExcelPC.Notes) Is Not Null)) OR (((Import_ExcelPC.OKToPayYN)<>0)) OR (((Import_ExcelPC.DABYN)<>0)); DABYN, OKToPayYN are Yes No fields. NOTES is long text. in picture: the ouput is 0 records to update. There should be 198 records being updated though. I run this select query and it shows 198 records based on the criteria SELECT Import_ExcelPC_Copy.Notes, Import_ExcelPC_Copy.OKToPayYN, Import_ExcelPC_Copy.DABYN FROM Import_ExcelPC_Copy WHERE (((Import_ExcelPC_Copy.Notes) Is Not Null)) OR (((Import_ExcelPC_Copy.OKToPayYN)<>0)) OR (((Import_ExcelPC_Copy.DABYN)<>0)); here is a screen shot. Its 198 records. Why wont those 198 records update in Import_ExcelPC instead of showing 0 records to update? I am not sure what I am doing wrong? thank you for the help.Tony2021Feb 06, 2025Steel Contributor9Views0likes1CommentTRYING TO BUILD A LOGIN BUTTON/PASSWORD
Hi there, I hope you will be able to help me. I am very new to access and managed to build a small database for my work, mainly from watching you tube videos and reading google information however, I want to start upping the anti a little more by adding a level of security so users need to input a user name and password to gain access to the database. My first stumbling block is the 'build event'. Whenever I right click on my login button, it takes me to the macro screen yet when I watch videos online, you get the option to select code builder, I cannot for the life of me see how to change this, any advise please would be greatly received. Many thanks, AndyJustAndyFeb 04, 2025Copper Contributor44Views0likes4CommentsLabels on Access Report
I have a report that prints 4x2 labels, but when I request multiple copies of the records, they are printed on different pages instead of being consolidated on the same page. This leads to wasted labels. How can I fix this issue?Fernando SalgueiroFeb 02, 2025Copper Contributor40Views0likes2CommentsAsset Tracking Template - depreciation
I'm looking for a free/low cost Asset Register app to record a few hundred fixed assets for a NFP. The Asset Tracking Template for MS Access looks OK but doesn't do anything for depreciation. I've had a look at a few spreadsheets but they look even more rudimentary. Can anyone suggest an appropriate tool or updated template? Thanks Stevesedge55Feb 02, 2025Copper Contributor38Views0likes2CommentsStart Access from .bat file as specific user?
Hi, I need to run an Access macro from a .bat file as a different user. Is there a way to use the start command and the runas command at the same time? I want to do something like this: runas /user:Me start /b "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.exe" "\\Data\MyDatabase.mdb" /x TheMacro Anyone know a good way to do this?SolvedAccess_JimFeb 01, 2025Copper Contributor36Views1like1CommentMultiple similar Tables in you database, is it possible to run queries etc by pre selecting.....
Hi, I have a number of similar linked sharepoint lists in a database, specific to different job sites, is it possible to run queries and forms on a particular job only, by selecting the job I want to work on by using a button / combo box on a menu screen?SolvedHenryDJan 29, 2025Copper Contributor68Views0likes4CommentsTrouble finding the trigger behind the "Unrecognized database format Access" error message?
We have multiple local users on my domain (around 6), accessing a Access Front End database split. For most of the days, things go well, but sometimes, after some user updates some register, the .mdb file becomes corrupt, and everybody else using Access on their local PCs get the "Unrecognized database format" error message (see picture). So I have to restart the server, erase the .ldb temporary file and then click on "Compact and restore database" option under Database Tools tab. That fixes the problem. Microsoft 365 Access Build 16.0.3.... But what's the trigger? Is it a limitation of Access? Is there any way I can prevent this from happening? Thanks in advance!SolvedtecmetroJan 27, 2025Copper Contributor33KViews0likes9CommentsFilter Form with Like and Or
Hello Experts, I am having a tough time adding a condition to a filter on a form. It works with 1 condition but not sure about the OR part (sq, dq) Maybe it is correct. The error I get is "Type Mismatch" see pic below. The row highlighted is the Remarks line. It seems odd because the fields are "short text" in the underlying table. Do you see an issue with the OR statement? If not, any ideas why I would be getting that error knowing that the fields are text? Private Sub txtEndUser_AfterUpdate() 'http://allenbrowne.com/ser-28.html If IsNull(Me.txtEndUser) Then Me.FilterOn = False Else Me.Filter = "[Remarks 1] Like '*" & [txtEndUser] & "*'" Or "[Remarks 2] Like '*" & [txtEndUser] & "*'" Me.FilterOn = True End If End Sub here is the table showing they are short text. the table is imported. as a reminder, I have no issues with 1 condition meaning it filters fine.SolvedTony2021Jan 27, 2025Steel Contributor70Views0likes5CommentsReport not opening
I am have a problem when I try to open a report I get OpenReport action was canceled"Lbartz47Jan 27, 2025Copper Contributor13Views0likes2CommentsRun a Query without Saving it (to reduce # objects)
Hello Experts, I want to reduce the # of objects I have in my db. One way I can do this is by not saving queries and running the select statement from a button on my form with code instead. I have read some posts and not exactly sure how best to do this. I think its with StrSQL statement and DoCmd.RunSQL strSQL but not exactly sure. I do run INSERT queries this way but not exactly sure if I can run SELECT queries and if so then how/where to make the changes. My query is as follows: SELECT import_Excel_BOA.[As of Date], import_Excel_BOA.Amount, import_Excel_BOA.[Account Number], import_Excel_BOA.[Account Name], import_Excel_BOA.Text FROM import_Excel_BOA WHERE (((import_Excel_BOA.[Account Number]) Like "*" & [Enter 5213 for VW1 or 5636 for VWMC] & "*") AND ((import_Excel_BOA.Text) Like "*" & [enter part of co name] & "*")); Please let me know if not clear. thank you for the help!SolvedTony2021Jan 23, 2025Steel Contributor54Views0likes8Comments
Resources
Tags
- access1,619 Topics
- office 365355 Topics
- 2016195 Topics
- developer185 Topics
- Access Web Database100 Topics
- Access Web App57 Topics
- 201351 Topics
- sharepoint50 Topics
- 201042 Topics
- admin41 Topics