Search results

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!

After getting the error, I have been opening the Excel file and running the macro to finish the report so I can send it. When I open Excel, it has the Document Recovery pane open, I just close it and then run the Get Data macro. I was thinking I must not have written my code right in Access...

I have just started getting this error as of 2/6/17 our database has been functioning since 1/26/15. I am now running MS Office v2016 after upgrading July 28, 2015. Microsoft VB Run-time error '-2147023170 (800706be)': Automoation Error The remote procedure call failed. Here is my code...

Thanks CJ, That is beyond my abilities, especially when data on each line changes daily. What I finally figured out as a work around was to export the report as a RTF file, open it in Word and save as TXT. No more blank lines before each of my rows of data. Appreciate your quick response to...

A customer is requesting a .txt file from us to import into their new system. Here is their requested format: H Unique 20161107 20161107 I 5500000021 110 4100000031 DBW1 20161107 2430848 LB 8010004405 SC 110 4100000062 LPT1...

Perfect, thanks Steve!