Search results

Sorry, the code resides in a button on the main form.

Hi, I have done this in the past, but for the life of me, I can't get the code right. Main form: frmBC2ndParent Subform: frmBC2ndChild If Me.Form.frmBC2ndChild!Combo173 = "Company Will Pay" Then Me.Form.frmBC2ndChild!SUPC1.BackColor = vbYellow...

Hi, I am trying to create a button that will open a different database. I was thinking I could use the Shell command, but the computers that will be accessing this other database are using AccessRuntime 2010. Can someone please explain to me how this is done. Thanks! Jeff

Hi, I am trying to create a Macro or Module that will rename an existing database and then, using the Save As option to save the current database into the same folder as the old database and name it the same name as the old database. Any help would be greatly appreciated. Thanks! Jeff

Hi Everyone, I am trying to have a calender popup on the screen when a user clicks a button. I have read through a lot of posts and all of them seem to want the ability to either choose a date and enter it into a field or be able to make notes on a given date. All I am trying to do is have a...

Thanks! That did the trick.

Hi, I have done this in the past but can't remember what I did. I am trying to change the text in a Text Box on a form based on the time of day. So if it is between 12:00am and 11:59:59am, I want the text box to say "Good Morning" and if it is between 12:00pm and 11:59:59pm, I want the Text...

That is the name of the page on the Tab Control.

Ok, now I was getting the following error: Run-time error '2467': The expression you entered refers to an object that is closed or doesn't exist. I played around with it and took out the quotes around "LoginPage" Me.Parent.TabCtl0.Pages("LoginPage").Caption = "Logout"...

Ok, thank you again for all of the help. Ok, I will try to explain this as best as I can. The main form is called "frmSwitchBoard". On that form I have the Tab Control that is named "TabCtl0". On the page named "Login" I have a subform called "frmLogin". The button "Command10" resides on...

Thank you for all the help, but I am still having a problem. Below is the code I am using. Me.TabCtl0.Pages("LoginPage").Caption = "Logout" But I am getting the following error. "Compile error: Method or data member not found" and ".TabCtl0" is highlighted. Does it matter if the button is...

Ok, I attached a screenshot of what I am trying to change. I want the word "Login" to change to "Logout" and then back again by clicking different buttons. Thanks!

Hi, Is there a way of renaming a Page on a Tab Control through code? Like when you click a button, the name changes and when you click a different button, it changes back? Thanks, Jeff

That worked great!!! Thanks!

Hi, I have a Access 2010 database that loads a form when it opens with both "Pop up" and "Modal" set to yes. My question is: Is there a way of minimizing or hiding the main MS Access program window when it loads the form so you don't see it in the background behind the form. Thanks, Jeff

Hello all! Is there a way of converting an Access 2010 database into an EXE file that does not require having Access installed? Thanks!

Thank you all!! That did the trick!

Hello everyone, I am having trouble with a tab control. I am trying to reference a text field on a subform of a tab control using a query. Main Form: frmSwitchBoard Tab Control: TabCtl0 Sheet Name: SearchClaims SubForm: frmClaimSearch Text Field: Text54 I am trying to reference that field in...

Hi, I am trying to pull data in a subform to my report and all I am getting is "#Name?". I have no problems pulling the same fields from a main form. I have tried it several different way. =([Forms]![MainForm]![SubForm]![Field]) =([Forms]![MainForm]![SubForm].[Field])...

Hi, I am working with MS.Graphs and I am trying to sort the "Legend". Currently it sorts in alpha order. Is there a way of changing that? Thanks, Jeff