Search results

In earlier versions of access the F4 key would open a drop down in both Normal view and design view. Unfortunately in newer versions such as 2013, the F4 key opens the Property Sheet when in design view. Have been searching periodically over the years to locate a keyboard shortcut replacement...

Thanks theDBguy. Appreciate your encouragement.

Thanks all. I had seen Gasman's suggestion in my initial search and after a quick look, moved on as at that point was trying to locate one that was specific to the header. I took a second look at it and decided to make a go of it. Had to make a few modifications to have it work in Access. I...

If it were only one time, sure I could manually edit. These are files that are sent from several departments anywhere from one to several a day. Since I already have automation set up, I had hoped to simply add a bit more code to the existing function that inserts data not available to the...

A typo was discovered in a word document that we receive. Was advised that they are not going to provide a corrected version to users until there is a major change to the file. Since via Access, I have been able to edit text elsewhere in the word doc, I thought would be simple enough to add a...

Here are two other options using Batch files. Option 1: Create a batch file with a parameter prompt. Then the batch file will copy the "template/blank" file to the name you provided and run the cmd line statement to open access and the selected file. Option 2: Since you are starting with a...

Is your question about how to get the file size or how to set up the loop to reset when it is near or at 5mb? If the former, here is one example from Stack Overflow to get the file size: Function GetDirOrFileSize(strFolder As String, Optional strFile As Variant) As Long 'Call Sequence...

Thanks arnelgp. That sorted it out. Thanks June7 for your suggestions/advice and code. I tried both your version and arnelgp's and since they both returned the same result, decided to go with arnelgp's since his worked without the nested If.

Getting closer, thanks June7 and arnelgp. After adding your code, it does keep the highlight and the date just like you said. :) The new issue is it puts up a message box "The value violates the validation rule for the field or record". Since the user has already been prompted that there is an...

I'll try tomorrow when back in the office.

Would Cancel remove the entry? They don't want to undo the entry since there are exceptions, it is only for information purposes and I thought would be helpful if the textbox would be highlighted so user can decide if the date needs to be revised. Maybe tomorrow I'll try a different approach...

Changed the code as you advised to BeforeUpdate. Same result, after the End Sub the selection goes away. Private Sub tb_DateTaken_BeforeUpdate(Cancel As Integer) Dim dtRWP As Date dtRWP = DLookup("EmployeeTraining_DateTaken", "tbl_dt_EmployeeTraining", "EmployeeTraining_EmployeeID=" &...

I have this in the after update of the field in question: Me.tb_DateTaken

I am using the following to Select the textbox when the date is before another date. I thought it wasn't working. However when I stepped through the code it does select the text until the End Sub and then becomes unselected. I have this in the after update event. Is this the right spot? Or...

Are you looking to remove duplicates from your concat list? Before: "User1 Role1, User1 Role2, User2 Role1, User1 Role2" After: User1 Role1,User1 Role2,User2 Role1 Function RemoveDupes2(ByVal txt As String, Optional delim As String = " ") As String 'Remove duplicate repeating multiple words...

Not sure how using a timer would help for my application as I'm not having the data pasted into a textbox. The form only has a button on it, which runs code that parses the clipboard data into a recordset loop to append vbcrlf delimited text rows into a table. This saves me from the extra step...

I think I found an alternative solution. Rather than enabling and disabling the button, I put the if statement in the on click event of the text box. If the button is clicked and the expected string isn't found, it pops up a messagebox saying to go get the data and then click the button.

Sounds like you have a solution. For my own understanding, curious about what the code I posted didn't provide. Only reason asking is that in reading the additional posts, seems that the other method requires a manual setup. The code I posted can directly export the data without having to...

Tried your suggestion and it does not seem to work for external program. Activate works when switching between forms within access. I guess I'll need to figure out a different approach.

I have a form where I would like to enable a button only when the clipboard contains a particular string/phrase. The purporse of the button is to paste data into a table and if the data isn't what is supposed to be pasted, don't want to inadvertently add it. When the form opens, if the phrase...