Search results

Good Morning, I am working on this same concept and am stuck. I am building a string from my underlying form and want to create a folder with it using a button. This post has been the most useful. Private Sub cmdMakeFolder_Click() Dim strFolderPath As String, strNewFolder As String, strCoName...

Just to update the solution: After one of the windows 10 updates it resolved itself without any further actions.

Good Morning, The contacts are on the phone however are not syncing when updated. You can search the GAL from the phone which is perfect. I just hate to have to go into everyone's contacts to open and update each contact card individually. Thanks, Samantha

This really isn't an Access question, but I have been searching off and on everywhere for a few weeks for a solution and am totally lost. You guys have always been a great well of knowledge and if anyone can point me in the correct direction it would be much appreciated. I have come to the...

Kyoch, I couldn't get this code to work either, I am in no way an expert at this. I found an alternate way to accomplish what I wanted. I just wanted to kick out everyone and run backups/make changes to the BE. Upon checking the box in my form the other users receive a message telling them...

I will look into using runtime just to see if it fixes it. Really we should be going in that direction anyway - no since of paying the extra for full versions. To not confuse things further my DB was created from a blank - I only mentioned the templates since the ones that say "Updated" work...

Thanks for the response Minty. This particular form was just a blank form that I added controls to. Control padding and Control Margins are both set to none. Do you recall what you did to fix this? I'd be glad to try anything at this point. Being though the problem does recreate itself in a new...

Hi all, I recently updated one of our computers to Windows 10. Seems okay - I am not thrilled although I really haven't performed any real work on it. I am running Access 2013 on both machines and my computer is running Windows 7. While running Windows 7 everything is fine. In Windows 10 my...

Gemma, I tried changing the numeral to workbooks(0) and the same error resulted. I googled that line of code and came to the following discussion...

Good Morning, Company wide we will run on 2013 - at least until Access 2016 is released in 365. I do have 15.0 object library referenced. So after looking up some examples I changed the code to the following: 'Set up object variables to refer to Excel and Objects Dim XL As Object Dim...

Minty, Thank you for your response. I attempted to look into it more today however other MS software is acting up putting this on the back burner. I will look Monday again and post back my results. Thanks, Samantha

Hi, Let me start by saying thank you for anyone reading in an attempt to help. I am by no means a pro at this, and have borrowed and changed all of the VBA in my DB. I have spent a few days searching for examples and clues as to what is going on and this is beyond me. I am running Windows 7...

Privateer, Sorry for my delay, I got caught up with other issues. You were right I should have Dim'd each individually. Thank you for your help. For anyone else attempting this you can also insert =("***-**-" & Right([SSN],4)) as the control source for the text box.

Just to update and close out this thread - After months of Microsoft looking at this issue it was deemed the trial site was corrupt and no further explanation from them. They set me up with a whole new instance which works as intended.

Thanks for your willingness to help Alex, I changed it to .value and still no error code, opens to the first record. Ahh...I think after the headache on something so trivial I will abandon the look up fields and start replacing them in my tables as you have suggested. There are many throughout...

How do you accomplish this? I was under the impression that the information does not save anywhere when you have a unbound control. Unless I have this confused? Back to the original problem at hand - so I changed the code as follows referring to the id field Private Sub...

was an type-o that is one of the fields on the form that is opening. tblLookupBoxLocation.BoxNumber should match with ArchiveBox. Since ArchiveBox is a lookup in tbleProposals how do I determine what it is actually saving? The record source for the field in the underlying table is actually a...

My apologies, the most important part "compile error method or data member not found".

Hi all, I am using 2013 and always learning. This should be really simple although all of the variations I have tried haven't worked out. I am sure it is something simple that I am overlooking. The following code is located on my form frmProposalLog which is a datasheet based on qryProposalLog...

Thanks for the response CJ, I am using 2010 and just purchased 2013 to explore web apps. The db works fine in both. The function exporting to excel works fine for every other field even multi-selection although I haven't tried exporting the memo field. I will play with it before I get to deep...