Search results

Hey guys!! Hi Everyone, first great forum! I have posted a lot and always get wonderful help, but as usual my users want to push me to do things I have no idea about. So the latest request was to have a form with columns listed and let the user select which columns they want to display in...

Happy Superbowl Sunday everyone!! I have a navigation form and on one of the forms within the navigation form is a subform. I was asked if I could have that subform which is based off of a query display only the results back specific to that user. The form that is attached to the...

Thanks for all of your help. I will make the change and thanks for the link to the videos. I have actually watched numerous of his videos and use some in my past projects.

sneuberg Thanks!! That worked great!! I did have to change my function a little bit, but with your function and mine it works like a charm!! Here is my code for reference for others if they are trying to accomplish the same thing. Public Function IsLink(sTableName As String) As...

I attached the images for your review. Thanks for your help!!

sneuberg, Ok so I copied over your function and changed my function to what you suggested. In my macro I have it to run code and I run my macro and I am still getting the same error. Too many arguments within the function.

Thanks Sneuberg for the code. I have two questions: 1. Where do I define the table name? 2. Do I need to add another reference since I am on 2013 and you are using a DAO recordset? Thanks!!

Hello Everyone, So I have a project where I wrote a macro and saved it as AutoExec. I want it to run a few items before the database opens. The first part of the macro is to check if the user has macros enabled so the code works. The second part is to check if the user has permissions to...

Hey, Has anyone else attempted to do this? I have an Access project where the users are requesting this feature. Thanks

knarlyd - here is my code for importing an excel spreadsheet. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "tempolddefectlog", selectFile, True, "Defect Log!C7:T200" What I do is import a range of cells into a temp database in this case it is called...

Of course I did change the message box to say something different then get out of here loser. That was just to put something. Thanks again for all of your help!!

Nevermind, I got it. So here is the actual working code for other users if they come across the same problem or want to do what I am doing. Public Function OpenCHeck() Dim varUser Dim varOK varUser = Environ("username") varOK = DLookup("racfid", "tbluser"...

PBaldy - I actually did for some reason. Thanks for catching that. Now I have this runtime error 94 invalid use of DLookup and it highlights this row varOK = DLookup("racfid", "tbluser", "racfid = """ & varUser & """") Any Ideas?

racfid is actually a username field and is set as text. As an example it would be jdoe I added the module by going to the visual basic editor and clicked on insert and then module. Do I do it a different way? I believe that was the first thing I did when I started the new database.

I am starting a new project and I would like to use the AutoExec Macro for this one. I have the following function and when calling the function I keep getting the error "The expression you entered has a function name that Microsoft access can't find". Here is the function code Option...

Hey guys so we came across what the issue was with the code. I am using Access 2013 and the users were on 2010. The object library for me was at 15 and the users had 14. So the reason why an older version of the database worked was because it was written in 2010, but when changes were made...

Thank you everyone for your input. It appears our security policy has blocked applications from using outlook to prevent the spread of viruses and spam. I spoke with another programmer on our team and they have ran into the same issue. Frothingslosh - I will try your code and see if that...

Hey Everyone, So I have Access 2013 32Bit and the majority of my team has 2010. Recently they have been seeing an compile error on one of the forms. Below is the code and it highlights Me.txtuser = Environ("username") - All the code is doing is just looking up the name of the user and stating...

Hello everyone, I am trying to take a form and send it in the background using outlook. It basically sends a table to the user when an update has been made. Below is the code <code> Private Sub cmdsend_Click() Dim oApp As New Outlook.Application Dim oEmail As Outlook.MailItem Set oApp =...

Ranman - Thank you very much, I am not even sure why I did not think of using a join in the update query. I already wrote it and it worked like a charm!! Thank you for the suggestion!! jdraw - Thank you for the links. I will be sure to watch them for help with other projects that require...