Search results

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?

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

I have a query string in the following code. I want to put the entire code into a function so I can use it somewhere else as well. Private Sub Form_Load() 'To enable the AllowAddition property once the form is opened Dim dbs As DAO.Database Dim rstTest As DAO.Recordset Dim strQuery As...

Hi, I have On Load, Current, After Update events on a form, which all work fine. But, when I add a Before Update, I get the error: "Procedure declaration does not match description of event or procedure having the same name". Can anyone please help me to resolve this issue. Following is my code...

Hi, I have written the following code. I want to change the status of my order when reminaing products shipped is equal to zero. When I run this code I get error " Cannot update. Database or object is read only". I think that this error is because that I am using the front end of the database...

Hi, I have a button on my order form. I have written the following code on on-click event of the button to read one of values from the order form and return some values using query. In my code I put a msg box to test the query.Anyways, my problem is that I get an error "too few parameters...

I have an unbound combo box with three columns, which get the values from a query. The first column is hidden. When I close the combo box after my selection, only the second column value is shown on the box. Is there any way that both the second and third column being shown on the box after...

I have a split design form, where user can select on any row and column of the spreadsheet view of the form and edit the data. Now, I want to write a code to limit the data addition(Row addition) to a certain number. But I still want to be able to edit the previous records added to the form. I...

Hi, Can anyone please let me knowhow to resolve error 94 in the following code: Private Sub Form_Current() Dim strTime As String Dim strHour As String Dim strMinute As String If (CollectionTime.Value) = "" Then MsgBox CollectionTime Me.Hour = "" Me.Minute = "" Else strTime =...

I have two combo boxes containing integers on a form. How can I store the values of these combo boxes in a field of a table separating them by comma or semi colon?

I have designed a split database( with back end and front end), I am just wondering what would be the best way to put a password for both of the back and front end.

I have a list box on a form. The list box is bound to a field of a table. When I select a single or multiple items from the list, the selected items will not be recorded in the table. Can somebody help me to fix this problem?

How can I add clock control functionality to a form in Access 2010? I have tried the entire procedure in http://office.microsoft.com/en-ca/access-help/add-clock-control-functionality-to-a-form-in-access-HP001121061.aspx, but I get an error that says "a problem occurred while Microsoft access was...

I have two fields on a form. One of the fields has to be entered first in order for the other field to be filled. How can I restrict the user to enter a value in filed #2 before filling the filed #1?

I want to limit the # of records being entered in a form according to a limit value which has to come from a query. I greatly appreciate it if you help me how to code this.

I have a split form design. I want to hide a field which I have already set a default value for. But when I make it invisible, the default value is not being recorded. Is there anyway, I can fix this problem.

I have a score column for my data in a query. I want to add a rank column beside it to rank according to the scores.I also need a way to break the ties using 3 other criteria, which are all dates. I appreciate it if you can guide.