Search results

Hi, I'm trying to create a query that allows me to find the differences between values inside a same table. Let's suppose I have this table: Client Item A 1 A 2 A 3 B 1 B 2 B 4 The query should return only these results: Client Item A 3 B 4 I tried using WHERE NOT IN...

Hi, I just found an error on my db and was looking for some advice. I was working on my forms, looking to improve some things, when by mere accident I clicked the compact & repair button. After that, the welcome form started giving me error #5. Looking through, the problem was the Select case...

I am making a report that has it's results filtered using groups. I was trying to use the value from the textbox on the group's header to filter a subreport that is attached on the group's footer. The script was wrote on the Onload event of the subreport, and worked on the report's view, but...

I'm sailing on a travel that I think I'm not experienced enough to do, so I came here expecting some guidance because after a lot of research on internet, came with few ideas. I have been tasked with developing a database to track the production history of different items. The main problem is...

Hi, I have a Table that has two fields that can contain similar data. Let's call them "Name 1" and "Name 2". I was thinking on making a Query that search for a name on either of those two fields, but I can't make it work. The closest I came to achieving this was using this expression Expr1...

Hi, I am having some trouble with coding a reference to a textbox on the footer. I just want the textbox to display any text that is between "" When I load the main report. The code is something like this Me.rpt_subrelind.txt_srobs = "text" But it keeps giving different errors like: 438 But...

Hi, I'm trying to code a function that writes directly the status on a query field when called. The code I wrote is just for test as for now and looks like this: I just want a column that shows "bing" for everyrow, because I am trying to check my code, but the thing is if I set the rs it...

Hi, I was trying to code an autonumber for the PK of a Table that only ID field and a text field. I came with this: Option Compare Database Option Explicit Public Function Nextus() As String Dim pref As String Dim lastCase As String Dim csNum As Integer Dim nxtCase As Integer Dim anno As...

Hi, I was wondering if someone else had this problem: My db has a linked table to sharepoint to add records through an update query, but since I made this now I can't use the excel files that are linked to the db through some queries without having the error "The database has been placed in a...

Hi, I have stump with an error when I try to update/refresh the queries or tables on my workbook, it's the error "The database has been placed in a state by user...(etc.)" any idea on how fix it? I have been told it might be related to the build version but maybe any of you have found a...

Hi, I think this is my first post here so greetings everyone! I was looking for some help with the following, I never used Access with Sharepoint before and I'm trying to implement some ideas for my organization, one of those ideas would be to have access to a query from a link on a QR Code, but...