Recent content by Robecca

Hi, the macro isn't ran in the single step macro mode. That's just the title for the error box that came up. The macro does have a run code command line that initiates the DoCmd.TransferSpreadsheet VBA code. This is where the error box started popping up for this user. The previous person...

At work, I have a MS Access database I "inherited" managing and updating from someone who only used macros (database built in 2014). We have several users all with their own FE applications. All applications & Excel programs have trusted locations set and macro settings are enabled. We all...

Okay, thanks!

Hi, I guess not, I thought the coding I had done protected it. How do I get passed it?

I was contacted by one of our billing staff that it was missing, they're working from the server. I just used Dropbox to get the record re-entered. It is a puzzle.

Hi - I keep a daily backup taken at 11:59pm. The BE is also uploaded automatically a few times a day to Dropbox since I'm in a different state, so I have access to multiple copies of each day for a full month through Dropbox. However, I had uploaded the database to Dropbox just 5 mins before...

I designed both the FE & BE. I have the FE's Shift bypass password protected. I have it set up so they flag records as cancelled rather than allowing them to delete records. Because our operation is in one state and I am in another, I have the BE uploaded to Dropbox automatically, but...

Our BE database is password encrypted and only I can get in it for maintenance. This morning between 7:15 & 7:20 a record entered 3/9 was just "gone", basically as if it never existed. I don't think we would have ever noticed this if it happened in April to the same record, but we're working...

Ah, I had Loop Until, not sure why I changed to Loop While. I switched back to Loop Until and the cursor did move to the BracketSlot control. I put in a msgbox to see UsedSlots after assigning the RndSlot to BracketSlot and it loops 8 times before moving to the next row in the form. I've...

Still not working. The program freezes. Won't move from BracketNo to BracketSlot. I have a feeling this is simple but I haven't used any of this code before and I don't know what to do. Here is the code now. Private Sub BracketNo_AfterUpdate() ' Assign 8 unique random numbers to string...

I apologize for the week that has gone by. I have been working overtime and/or researching Do Loops. I do appreciate the help in figuring this out. I am still having problems getting the result I am wanting. The code is looping 8 times before assigning the value to Me.BracketSlot for the 1st...

Here is the code I've come up with from my searching into strings and InStr(). The result is null. Any tips would be appreciated. Private Sub BracketNo_Exit(Cancel As Integer) ' Generate random value between 1 and 8. 'String to store used position slot numbers Dim UsedSlot As...

Thank you Plog for a direction to explore. I've never done strings or arrays, so I will need to do some research. I may get back to this with questions or I will get back with a proper thanks for the solution!

Our summer bowling leagues does brackets. We’ve been determining the bowler order for the bracket “manually” by drawing a random playing card. I would like to have Access assign the order randomly instead. A bracket has 8 bowlers. We have 10 brackets a night. I’m very new to coding VBA but...

I appreciate all the comments and ideas. Since I can run the macro from within Excel, I uninstalled Office and reinstalled and same issue. I will contact our IT person. Thank you!