Search results

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,

Hi, I've the following code but the cancel doesn't seem to be working, when upon click cancel, it should still remain on the form but it closed the form. Can someone please advise. Dim strMsg As String Dim strMsg2 As String Dim strTitle As String...

Hi, Thanks! I manage to get it working. Brillant!

Hi, Yes have tried searching and trying to find some solution here and there from the various thread that is being posted previously.

Hi, How can I do the following : I've a name field which I would like to extract part of the information. For e.g Tom Cat Dog, how can I extract just the initate, C from Cat and D from Dog so that my name will appear Tom C D Thanks,

Hi, Currently I've one txt file that contains a few reports, I need to break them up but grouping the same report into one file. This is how the txt file look like : I want to have all with reportid 001 into one file and 002 into another. Please help. ReportID:001 aaaaaaaaaaaaaaaaaaaa...