Search results

That was an excellent example! Thank you very much!

Yes I had load event to auto maximize the main form. I removed that and your code worked. But If I wanted to convert what you have to an if and statement based on todays date that the Monday subform would be white unless today was actually Monday and the same scenario for all other weekdays...

This is what I put in the main forms code for on load. But I get an error message. Private Sub Form_Load() Me.MONDAYLIST.Form.DatasheetBackColor = 13434879 End Sub

So this will sound silly but I solved the issue by going to the form properties for each user who had the issue and changing pop-up from yes to no then saving the form. Then changing pop-up from no to yes like I want and saving. Click the button and it works!

So I went back to my backup database that wasn't split, copied it and resplit it with the steps from the link tvanstiphout suggested and then gave the original front end database file to everyone but the issue with the forms not opening is still happening.

I didn't do that. I'll give that a try and let you all know who that works.

I have been creating a database for a trucking schedule for my company and I have everything working how I would like it to work. But when I go and put the database on our server then split the database other users on the server can't open some forms I have made. It wont open with the buttons I...

I think becuase I have querries driving the subforms that is why I cant figure out how to vba code it?

Hello Everyone, I'm quite new to access and if you know how to make the majority of the code please help. TIA I would like to know if there is a way to change a subform back color with an if and statement based off the day of the week. For example if today is Monday or (2) then the background...