Recent content by Stoic

Hi, thank you so very kindly. It works great. Just a little background, I am working on a school database, and so this will help a lot. I am hoping to include an audit trial to know who initiated an entry, who updated an entry, who change an entry and who deleted an entry. If you have any...

Thanks again for your help. I would like to direct users to specific forms based on access level. I have the following code: If DLookup("[AccessLevel]", "tblUsers", "[UserName] = " & Forms!frmLogin!cboUser) = 2 Then MsgBox "You have access to Human Resources Section!", vbOKOnly...

Thank you so very much. It worked just as I wanted. You are the best. Thanks again.

@isladogs thanks for this platform. I really like it and would like to use it in my database, but I would like for users to enter their user ID and not select from a combo box. Therefore I would like to change the combo box to a text box, but changing it produces an error that points to Column...

Hi, I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form. Me.lngSCode =...

Of course I didn't take it as serious, I know you were just make a statement, and I can't hold you for that. The code doesn't seem to be working as it is still running as the previous code. Maybe I am not placing it correctly. I added a couple more lines and they are working as I desire. This...

Thanks again Mihail, my database is getting together by your assistance. I am trying to include an 'If' statement that in the case where only one or tow options(combo box leaving the other combo boxes blank) is selection, the report should run the query for the selected combo items. Dim...

One more thing, does that mean I can add more combo boxes and follow the same partern?

Thanks Mihail, sorry about the SQL thing, but yes it did worked. Thanks again for your support

I selected from cboState "Montserrado" and selected from cboRegion "Greater Montoria" and two dialog boxes are requesting for the selected parameters ( Montserrado and Monrovia)

It seems to work but requesting a parameter value; normally, this is just simple if it will requst for parameter value, but that is not my intend. I would prefer if it runs the report directly based on the selections.

It is strCounty

Hi, I have a database with a table name tblTeachersProfile and a report format based on the table. I also have a form with two combo boxes name cboState and cboCounty base on field from the table and a control button called Get. Now, I would like to make selection from the two combo boxes and...

Good to hear that all is well. Thanks for the support, I will let you know if it does, but I am quite sure that it will. Regards, Oscar

Hi Paul, I am trusting that all is well; I have been doing well with my database but something else came up that I thought to seek your advice on. 1. Instead of the username appearing on the form after login success, I would like to use the actual name of the person that have entered the...