Recent content by gopherking

Ok ... so this post is really old, but I thought I would share my suggestion which doesn't require much code. I had the same issue in Access 2010 (they still haven't fixed this yet) where the vertical scroll bars don't appear in a text box unless it has the focus in a form. To help show that...

I am in the middle of creating a database to track the Development hours spent on specific projects on a monthly basis and am seriously questioning my table setup right now as far as reporting and form design. First off, I have two tables that allow users to input the number of hours by month...

armm1388, If you don't mind not being able to use F11 and Alt+F11 to get to the Navigation Pane and VB Editor, you can always uncheck Use Access Special Keys option within the Current Database Access Options. This will disable Ctrl + dot from executing, however it will also disable all the...

Yep, I placed it on the originating form but it didn't work. The only thing that I can think of is since I am using a Popup sub-form, it is opening in a new window, so the originating form is never losing focus or is not re-activating upon closing the sub-form window. Were you using a Popup...

Just a side note to my note above ... I added a Forms![FormName].Requery into the VBA for my New Entry form to execute just before the New Entry form is closed. This works just as well.

Ok, I used the method that was mentioned in this thread to refresh my form but it isn't working. The only difference that may be there is that I am using a Popup Form for my New Entries. Could this prevent the main form from executing the OnActivate?

Thanks pbaldy! The book that I was referencing didn't mention that you can use Criteria with the DMax (or most other Domain Functions for that matter), so I was thinking you could only specify the Field and Table to pull back the Max. I was able to put in the following to make it work (just in...

I have an Import Audit Trail setup in my DB to capture any errors or successes when an import is performed. I would like for my main dashboard (form) to show in a text box the date/time that is stored for the last successful import. I am assuming that I need to use a DLookup function, but...

Thanks Trevor. I wasn't sure if the vbCancel was passed where I could use it in an IF statement as you suggested. Worked like a charm!

Ahhhh ... I see what you're saying. So I see more coding in my future!!! Thanks for the info!

I am using the following VBA code to call to the Import Excel process within Access: DoCmd.RunCommand acCmdImportAttachExcel I have recently identified that if a user clicks on the Cancel button on this screen that the other code I have beyond that displays a message that I don't want them...

Ok, the title is a little confusing so I hope I can clear up any questions with what I have here. Currently, I have a form with the Tab control on it. Within one of the Tabs, I have 3 Subforms that the visible property is enabled or disabled depending on the content of a text box control on...

Ok, after some more searching through the forum, I came across the following thread: http://www.access-programmers.co.uk/forums/showthread.php?t=176968 I have used the information found here to: 1) have a new IE window opened 2) Navigate to the main webpage in order for the login credentials...

Ok, I have some more information on this issue ... I noticed that my button that directs me to my internal website all of a sudden stopped working again (really annoying since it was working just fine) and it got me thinking. The website that I am trying to access is not the highest level on...

Thanks Jdraw ... I am only appending records to another table, which will be few and far between so there shouldn't be any major concerns, but thanks for the heads up. I was able to use the following to get what I was after: Currentdb.execute "YourActionQuery", dbfailonerror