Search results

Appologies, I was distracted at that time. I get the error "An Expression you entered is the wrong data type for one of the arguments." When I examine the debugger it has "DoCmd.Close acForm, theForm" highlighted, and when I hover over the code it appears to be displaying "acForm = 2"

I have two subroutines, each one references the type of form that the call is embedded in. However, one works and one doesn't. This works: Public Sub doLockout(ByRef theForm As Form, ByVal isLocked As Boolean) ' In separate shared module Dim ctl As Control For Each ctl In theForm.Controls...

To fix this I went to the Database Tools ribbon, clicked on Visual Basic, and Renamed the file from there back to what it was originally. From there, I was able to do a rename and haven't had any problems.

Great - I tried inputing the SQL right in the statement but I ran into an issue (Probably made a mistake) so I turned it into a string and went from there. At least it works. Dim MyDB As DAO.Database, RS As DAO.Recordset Dim emailsList As String Dim strSQL As String strSQL = "SELECT...

That was it. I'm down to this point - the VBA works great, except now I need to use the SQL to pull only the addresses I need, which I can't figure out how to do that. This time I really am going home because it's way past time. I'll come back to it in the morning. Thanks for all your help...

I actually stayed behind a bit and tried to analyze things. However when I went to test things out I find I can't get past this point: Dim MyDB As Database, RS As Recordset Dim emailsList As String I get "Compile error: User-defined type not defined" and it highlights "Database" Which is...

That's a lot to digest, I'll have to come back to this tomorrow.

I have never actually created a loop before so I'm a little lost - also, what do you mean by "open a recordset" ?

Hello all, There are so many threads on here for emailing a PDF version of a report. I've put together a nearly complete bit of VBA that will do what I want - except for one thing. Basically I have a personnel table with an email field. I Also have a field that details if a person is...

Grr, I must have deleted it, thinking it was part of the optional code. Thanks Paul you're awesome! That's the second time your website has helped me out. Instead of moving to the next record I'm going to have it check to see if the record is still in an "open" status, and if not, pop a...

The first example worked as advertized, but I decided that I do want my users to be able to navigate the other records in the table still. So I followed the link on that page to the second part "still include all records" and I am runing into an error - perhaps I'm not putting in the form name...

Is this possible? I had this idea just now. I built a report that provides all of the open support tickets. My idea is to have a button (Which I called "WorkIssue_Button") that displays beside each record that is populated on the report... I need this button to be able to pull the ID number...

:D Ok, I feel dumb! The report was printing an erroneous character at the very end that couldn't be imported. Once I deleted this character from the text file it imported smoothly. Thanks. ~Kit

That's what I thought too, but it doesn't want to work. :banghead:

I have a saved import that my office will be performing monthly (or more often). We pull a report from another system that comes out in a delimited text file. I prefer to keep the header row in the document - I don't want to force my personnel to remove the header row, but I also want the header...

I'm getting really frustrated... Can you not rename a module without corrupting it??? Twice now I've created a database, and made the decision to modify the name of the Module I was using. Both times I did this caused the module to become corrupt. Now when I try to click the module or modify...

This sounds pretty good. Can I create a TempVar anywhere, and it would be recognized throughout all the forms, even when the current form was closed, or do I need to follow the same rules as a Global Variable? Thanks,

Perfect, it is working great. I made a Global variable with the following: Option Compare Database Public theUser As Variant During the login process I have a listbox with the users in it change the User_Text value, then upon clicking Login it changes the global variable to match what...

Sure that does sound promising. Could I could refer to the variable "myUser" that I created in the subform which refered to the User_Text text box, or would I need to refer to the text box itself? Thanks!

Good Day/Night all, I've learned so much from this forum so far and for that I am grateful. My Tech Support tracker Database is coming together great - I'm very excited to give my coworkers an update on it soon. Before I get to that point though I have one more function that I absolutely...