Search results

appChoice = InputBox("Enter the numeric value for the appropriate selection below to proceed:" & vbNewLine & vbNewLine & _ "1 - Modify ALL roles for an application" & vbNewLine & _ "2 - Modify LOCATION-BASED roles for an...

I have some code to update table information. All it is in input boxes and sql statements. Let's say I have an input box that I specify they enter either True or False. IF they enter something different, how would I cycle the code back to the original input box so they could change their...

Thank you everyone. There are a number of good ideas in here to try and/or consider. I'll give them a go in the morning and post an update.

I'm getting the error "Invalid Procedure Call or Argument" with the following piece of code: replaceLDAP = Right(strRole, (Len(strRole) - 9)) I've done some research and tried adding in a check to ensure "strRole" > 0, which I also manually confirmed, but no dice. I have been able to figure out...

@Ranman256 - There isn't, but the data set I'm pulling from doesn't maintain middle names. In my example, you would consider "John" to be the first name and "Smith Anderson" to be the last name. @pisorsisaac@gmail.co - Thanks! I figured that Len() would be a part of it somewhere, but I wasn't...

I am trying to extract last names from list of full names. I've got the standard down to pull a common first-last name (John Smith). I am running into a problem with names that have multiple last names (John Smith Anderson). Here is the code I have that works for the common name: trimStr =...

I was able to confirm the text file is Tab Delimited. What specification would I use for that? I've never really had a clear understanding of the options for specs, which is why I ignore them if I'm able to.

I didn't use a specification in the code, just left it blank. Would using a specification work better? I found a workaround as noted above, but I'd like to get it to work without the extra step.

I'm thinking all the space in the top row of the text file is causing those problems. As a workaround, I saved it as a .xlsx and then imported with no issues. Thanks pisorsisaac!

I am trying to import a text file but getting the following error: "Field 'SubSystem_Screen_Owner Department_.... ' doesn't exist in destination table 'TableA'" The problem is all of those fields are in my TableA, but it is inserting underscores between each header name. I've attached a...

Thank you for the help, that did the trick! Sorry, I was confused at first. I appreciate your help!

It took me a minute to think through that, but I get what you're saying now. I'll try the loop and see what happens.

I usually have something like that too. But this time I do not. Only because I want to drop in each "Manager_ID" in the same email. I've used loops before when creating an email for each account, but this time I'm aiming for one email only.

I have a function to create emails from my database, which works fine. The problem I'm running into is trying to insert data from a recordset into the HTML code as bullet points. Here is what I have so far: Set rs1 = CurrentDb.OpenRecordset("SELECT DISTINCT Manager_ID FROM TableA WHERE...

Thank you both!

I have a variable (strQry) in Form A. I am trying to declare it globally so that I can use it in Form B. However, when I compile, I get the "Variable not defined" error on the Form B sub at the "strQry" variable. 'FORM A' Option Explicit Option Compare Database Public strQry As String Public...

Is it possible to reference MS Teams in Access VBA? I have a db that tracks responses from managers, and I'd like to open a chat window directly from Access to a manager who hasn't responded to emails.

That did the trick! Thank you!

Yup, the literal value pulls the records.

Short text - but I tried with it as a number and Date/Time (formatted) as well and no luck