Recent content by emsadoon

Hi, I am trying to write a VBA code in Arena Simulation Software. In this model, I am trying to put a new arrived entity into the right place in the Queue. When an entity arrives, I want the VBA code reads its attributes ( priority number), then search through the queue, and finally insert the...

I have written the following function in a module to query for a name. But I get an error (Type mismatch error '13') regarding line ApplicantNameQuery = rstTest![Applicant Name] Public Function ApplicantNameQuery() As Integer Dim strQuery As String Dim dbs As DAO.Database Dim...

Hi, I opened my access database in a Surface tablet that has windows 8 and Access 2013. The problem is that, the navigation tabs are overlapped on each other and other command buttons are not in the same place that they should be. Can anyone know what the issue is? Thanks.

Hi, I want to know if it is possible to generate reports in writable PDF format? Also, is it possible to send the report automatically to a list of emails recorded in the Access db using Outlook?

Thanks a lot Nigel for making the Demo for me.

I actually find out that [Forms]![Navigation Form]![NavigationButton01].Visible works instead of Me!NavigationButton01.Visible or Me.Controls("NavigationButtons01").Visible But now when I replace Me.Controls("NavigationButton" & Format(intControl, "00")).Visible = (Me.txtPassword & vbNullString...

Actually I diactivated the following line If Me.NavigationButton01.Visible Then Me.NavigationButton01.SetFocus, and the error said "MS Access cannot find the field 'NavigationButton' referred to in your expression". The button names are NavigationButton01,02,..,06 .

Thanks. I used this code Private Sub cmdLogin_Click() Dim intControls As Integer, maxControls As Integer maxControls = 6 For intControls = 1 To maxControls ' If your first controls are numbered 1 - 9, which I suspect they are 'Me.Controls("NavigationButton" & intControl).Visible =...

Thanks Nigel. I am actually using your way to create one for myself. But, I do not know how to call my navigation buttons.I have navigation buttons with names of NavigationButton1,NavigationButton2,.... . Furthermore, each of this navigation button targets to an existing form outside the...

I tried to put the code on "on focus" event, it actually works. But when I press a wrong password and then click ok , it opens the form that should be opened.

Since I am working on a navigation form with the tab across the top, If I set the visibility of a sub-form (the form that will be opened once the tap is clicked) to "no". Then the entire sub-forms will be invisible.

Thanks michaeljryan78 . I used your code and it worked. But I want to change your code a little and put on Click event of the tab. I want when I click on the tab, the password page pops up, before loading the form. The code I have so far is Private Sub NavigationButton63_Click() Dim strPass As...

Is it possible to put password for a tab in Access 2010?

Sorry. I was confused and was looking for a wrong way to re-link the tables. I made it work by going to the External Data Tab, and then Access button, and then link option. Thanks Scotwithadevil for your suggestions.

When I delete the linked tables in my front-end, then the Linked Table Manger button will be disabled. So I cannot re-link the front-end to the back-end. Do you know where I am going wrong?