Search results

Hi, I have some VBA code that runs when a form opens. The purpose of the code is to make visible or invisible 17 different Command buttons on the form. The reason for this has to giving certain users the ability to run certain reports and other users they can't. It takes a couple of seconds...

Thank you all for replying. I downloaded the database that MajP offered and while the code was relatively short, it's not trivial. After spending time "translating" it to my project, I was able to get it to work. Thank you all!

My brain is fried and I'm drawing a blank. I have a single form that has a subform, which is continuous. I want a combo box, (on the continuous form), query's all of the values from a table/query. After the user selects the value, like maybe "Boots", I want the AutoNumber for "Boots" stored...

NauticalGent. Distance was never a concern. I'm sorry if I somehow conveyed that. And, I checked, Cache is turned on, right now I have 50k+ of records. I'm using Access 365. To net my questions out, how do I distribute updated versions of the front-end? When I do development work on the...

theDBguy. It's familiar because I'm still searching for answers. Sorry.

I built an application for a client that had three remote sites. The Access front-end database runs on the local machines, (main location and three remote offices), and the data in the back-end is on a SharePoint list. Now, when I need to do updates on the clients front-ends, I'm wondering how...

Hey, theDBguy, I just want to make sure when I give the client a new front-end with, not sure what they are but I'll call them hidden SharePoint tables, the local/front-end tables will be out of date with the SharePoint tables and I want to make sure the SharePoint tables aren't overwritten...

Hi, I've developed a database and split it into a front-end and back-end databases. I then from the front-end exported the data to a SharePoint list. The reason for this is that there are three remote locations plus a main-office location for this application. It is my understanding that the...

I got it: If IsNull(EmailX = DLookup("[Email]", "[Employee Table]", "[EMail] = '" & MgrEmailX & "'")) Then EmailX = "XYZ" Else EmailX = EmailX = DLookup("[Email]", "[Employee Table]", "[EMail] = '" & MgrEmailX & "'") End If

OK, new issue. The following code works if the [MgrEmail] from the [Admin Table] finds a matching [Email] from the [Employee Table]. In testing, if I made it so there weren't any matching [Email] addresses in the [Employee table], I get an "Invalid use of Null" error in the following line...

Mark, I can only assume it is the chicken's fault. Thanks again. Chuck

Mark, Before I asked for help, I tested via the DIM statement to make sure I could see the MgrEmailX in a MsgBox. That worked. I also copied the matching email from the [Employee Table] to the [Admin Table] to make sure they were perfect matches. Still didn't work. I then took your...

Gasman, Here's what the statement is saying to me. Lookup the [Email] address from the [Employee Table] where THAT [Email] address is equal to the [MgrEmailX] from the [Admin Table]. In the [Admin Table] there is only one [MgrEmail] address, bugsbunny@park.com. In the [Employee Table] there...

Minty, Thank you, I modified my code to match yours but I still get the message: "This from the Employee Form: " without anything after that. This is one of the scenarios I was dealing with before. Any ideas? Chuck

Hi, I have two tables; [Employee Table] which has a field called [Email] and another table, [Admin] that has a field called [MgrEmail]. The [Admin Table] will always only have one record in it and the [Employee Table] will always have many. I want in a Public Module, (for testing)...

Plog, One additional thought. The risk with your second solution, (I used the Left function three characters), is that if the format of the data ever changed and the codes in my Tire Code Table weren't at the beginning/left of the string, I wouldn't be able to detect them. The LIKE function...

Plog, Thank you. I used your second suggestion and it worked perfectly. I appreciate your reply! Take care, Chuck

I've run into a snag. I have a query that is based on one table, [BillingTable]. That table has a field, [ReferenceNoOriginal]. The data in that field might look like, TAX482-69511449. I have another table called, [TireCodeTable]. It has six rows with a field name of [TireCode]. The...

Hi, I'm building an Access application using Office 365 where certain users won't be able to access certain forms and certain reports. Before I start coding, I thought one way would be to build a table with certain information, the users email address, a password field and fields, (check...

Thanks. I do understand your logic and it makes sense. It's just kind of weird that if the criteria is ="b" the AND criteria works but when it's <> "b" it can't be on the same row. In one sense it's like a double-negative. Maybe that's why I'm not thinking about it the right way.