Recent content by momoko

Thanks a zillion!!! you really saved me!

Thanks for your reply. However I really don't know how to change the code to make it work.

Hi, I inherited this quote and trying to enhance it but having problem. The filter in navigation form is not working but it is on its own form, the filter is working without problem. Would greatly appreciate any help.

Hi, I've quite a number of report that i'll output daily. Instead of coding it one by one in VB, how can I maintain a table on the report name and output them according to what has been added to the table?

Hi, How can I stop user from closing the form if the mantory fields are not filled up? I try using gotocontrol but it is not working.

Hi, I'm having problem whenever I try to input a record to access DB. It automatically change the language toolbar to chinese. Please help!!

Hi, We migrated on DB to a shared network drive. But the users cannot open the DB. It keep give an error message that microsoft access can't find the database file. Please advise.

Hi, One of my user is getting this error when trying to launch the DB - "Could not use 'admin'. File already in use. The DB is in shared mode and other users are using it without problem. What could be the issue? Thanks,

Tried ! but gives me error that MS can't find the field. Are there any other method that I can use?

Yes I've ensure all fields and table is correct. This is working on other form but for this it is giving error which puzzle me.

Hi, I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error : Dim strSQLSF As String strSQLSF = " SELECT * FROM UT_table_EOM_UT " strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" &...

Hi, How can I get a 2 digit month when I use month(now())? I've getting only 1 instead of 01. Please advise.

Hi, Currently I have a remark field and want to just extract the amount. The data input is not in a structured manner therefore I could not use the mid function. Appreciate some advise. Example : Remark CASH PURCHASE $50K.DEBIT 3007484701...

Hi, I'm trying to publish the access db over the web. How do I get the security portion? I'm currently using the access security.

Hi, currently I have a table A (2 fields, Name and Signature). How can I insert the signature upon a click of a button. Meaning, in form A (the link is by name to table A), when the user click approve, their signature will be inserted. Cheers,