Search results

Thanks! The code is attached to the frmUserMessages "cmdRead" button. The database I'm using has a temporary variable called "CurrentUserName" that I use in place of your "GetUserName" because user have to log into the database with an id and password. But I didn't think that would affect the...

So I'm coming across an error message when copying the code from Ridders sample DB. This section: N = Me.ID CurrentDb.Execute "INSERT INTO tblUserMessagesRead ( ID, UserName, DateRead )" & _ " SELECT " & N & " AS ID, GetUserName() AS UserName, Now() AS DateRead;" It's...

It's not the web app that is affecting our data storage. It's the the SharePoint upgrade. We have an older version currently and we're migrating to 2016. The tables in my desktop application are stored on SharePoint and average about 25k rows.... The new SharePoint will limit data storage to 5k...

It's not clear to me as to why this is the selected alternative, but it's what was told to me. I'm not that high up in the decision-making chain...I just do the work. We are upgrading our SharePoint and the new version will not allow us to store as much information in our lists/tables. So the...

Hi Ridders, I believe that is true for Office 365 and SharePoint online. But on-premises SharePoint will still be supported into the 2020's. That is what my company is using with no mention of any changes or upgrades in the near future--which is why I need to figure this out.

I just learned that I will have to scrap the Access desktop database that I have been building for 3 years and figure out how to convert all of my beautiful work to an Access Web app. I admit I don't know what I'm doing and have been scouring YouTube and various sites to figure out how it all...

Thanks to CJ_London, ridders, and static for your input! You all have given me so many options to choose from! Static--I started out with your code because it seemed the easiest. I got it to work BUT the message box continues to pop-up every 10 seconds and cycles through all of my messages...

Wow!!! My head is spinning from all the fantastic ideas you guys have provided. Thank you so much to all who have responded! It sounds like I need a message that will certainly capture the users attention and ensure that they read it instead of ignoring it or just clicking it away. So now...

Ideally, I'd like to track who's seen the message so that they only get the alert once...but I haven't figured out the best way to do that.

I have an access database where tables are stored on SharePoint for multiple users to access simultaneously. I have a table (tblUpdates) where I record messages and updates that they would need to know that might affect how they perform their work. Every time I add a new message or update in...

figures it would be something really simple for me to get wrong! Thank you so much for your help!!!

Here you go.

So I changed my code but the report is still coming up as unfiltered. Do I need to add some sort of command to requery the report first?

Can you please provide an example? Thanks!

Thanks for the quick response. So what do I need to enter in order to filter my report if "tmp" isn't the right name?

I have created a search form using VBA that works perfectly. I want to be able to take that same filtered data and use it for a report. I'm having trouble getting my report to open with the filtered results from my form. My search form has a command button containing this code: Private Sub...

You're a genius! Thank you so much! This is perfect.

Hmmm.....well I tried it in a "dummy" database and it worked perfectly, but it's not working in my live database. I am going to look at my data again. Each date field in both tables is formatted as a "short date", so if the formatting is the same, the query should technically work, correct

Thanks so much for the quick reply! Unfortunately, this isn't helping me. It is returning all of the dates in my Issues table instead of the Missing dates from my Hours Worked table. Any other suggestions?

I have a customer service database where workers log details about issues. I also have users log how many hours they work each day so I can calculate their productivity. I want to alert users so that each time they log in, if there are any days where they have logged issues BUT did not log...