Recent content by billmark

Hi I've coded this as follow but no data in the search combo box. Please advise if it is something wrong in the code: QUOTE Private Sub cbofrman_AfterUpdate() Dim myfrmanager As String myfrmanager = "SELECT tblFRT.[FR Manager] FROM tblFRT GROUP BY tblFRT.[FR Manager] "...

Hi I've created a multi field search form with subform. In the combo search, I've updated the criteria in the Row Sources in the properties. I can select the information in the combo box. Please advise how to link this search to filter the corresponding field in the subform without coding...

Hi Access allows multiple users by default and my concern is when some users (eg more than 3) at the same time are using the input form to update the table, will it be any impact on updating the data? My table has a primary key. Also, if they click the same button to run the report, will the...

It works if I close the form with timer. Why? That is I can't write any code in the form with timer or how to overcome this.

Hi I try to write a DIM statement in the private sub. When I type the word dim, it turns red and can't let me continue to write the code. Please advise how to fix. Regards

Thank. I am not familiar to split the database. As mentioned by using the public function, do I need to split the db or just create a public function. What does it mean "the path and name of BE"? do I need to modify this? Regards

Hi I have created an access program with user id and password to login. I want to restrict only one user at one time. Please advise how to write vba or any way: 1.to prompt a message that someone is using when other use try to launch the program 2.to show the login id in this message 3.no...

Hi I am using Access and Excel 2010. 1.I created a table with 15 fields in Access with the Primary Key 2.Excel file is created with 16 columns (1st column is blank for the Primary Key) 3.I used the Import function to import to Access. I works 4.I wrote VB to import but it fails using the same...

Hi I've created a simple code to export the query to excel. The exported excel spreadsheet always has wrap text. Please advise how to get rid of this format (wrap text) when exporting to excel by coding or somewhere in access I can modify. QUOTE Private Sub cmdAuditor_Click() On Error GoTo...

Hi I have a excel file and try to copy and paste to my table in access. It prompts the message: 'Update or CancelUpdate without AddNew edit' Before I can do this operation, but now can't. Please advise how to fix. Regards Bill

Hi I've the SQL below and it gives me Top 11 but not Top10, please advise how to fix. Also, I would like to give them the no. of each record from 1 to 10. QUOTE SELECT TOP 10 tblSalesPayments.InvoiceNumber, tblSalesPayments.PaymentType, tblSalesPayments.PaymentAmount FROM tblSalesPayments...

Thank It works well now. Bill

Thank It works now but I found 2 issues and 1 message: 1.The text box of Confirm New Password has always a Password Input Mask (********) 2.When any user resets the password, the password of the 1st user in the tbluser got the password changed as this user 3.Sometimes, I got the message: 'Write...

Thank But I got an error (Method or Date member not found, 'Username' in Me.Username is highlighted) when running the following statement: " WHERE UserName = " & Chr(34) & Me.UserName & Chr(34) & ";" I use the UserName field in the tbluser. Please help. Regards Bill

Hi I have a frmResetPassword with the following codes but don't know how to link to the correct user who requires to reset. It always resets the 1st user in the tbluser If Me.txtPassword = Me.txtConfPW Then MsgBox "Password updated!", vbOKOnly Me.PWReset = False DoCmd.Close acForm...