Recent content by Hanz

I decompile but with no luck. I have no option but to re-create that form on that PC. I rename the form to "formname_old" and i just copied everything to another form and it solve my issue. can't really figure out why that happens to that particular PC. Thanks to those who shared their ideas...

I haven't tried to decompile yet but i will try

Yes some forms and buttons works fine. I only have two buttons that will open a form that don't trigger the openform command. also only one form with subform that does not show the subform. the subform is not empty, i open the subform outside the parent form and does show the data that i...

I compile and was compiled with out errors. in my desktop the macro is not enabled so i also didn't enable in the pc with problem. the project only have tables, queries, forms and module. no macro used. I saved the project_fe in the desktop and i add its desktop as trusted location. the...

I just finished my project and it works well from my laptop and in my desktop. when i distributed it to other desktop some of my forms don't open using the button that i placed with just a simple docmd.openform. one more weird thing is that i also have a form with a subform and the subform...

Hi June7, Thanks for idea. I got the code below and i think this works fine for me.

I'm new with access and I want to use the features of the attachment to my database. I did look for tutorials and found some useful tips on how to work with attachments. on my search I also read some comments that this feature in access will dramatically increase my db file. I did my test and...

I was so confident that I got Jun7's post previuosly. Actually i tried concatenating and even put quote even though i know that my ID is a number but still doesn't work. Just realize that i asked a very stupid question :). I run the SQL and it's working now. Thanks for your patience.

I did the same thing to my other form as what was discussed previously but this code won't work on my sub form. I got that SQL from this action query

Thanks to all who responded. I got this issue resolved.

But that code works if it is outside the mainform. if i put it in a main form as a sub form, it doesn't work. so i think the path won't be the issue.

Hi, I got 2 forms named TruckMaintenance_Main and TruckMaintenance_sub. On my Sub form i have a delete button to delete a row and this code below works if I click the delete button on TruckMaintenance_sub. But when i put TruckMaintenance_Sub as sub form of TruckMaintenance_main, the delete...

Hi June7, yes i would prefer to have date and time so to avoid same file name when the user exports to excel. i got this code working fine for me. Thank you.

Yes i already removed the record selectors and added my buttons for next, previous, edit, save. this is the reason why i used recordset but got stuck with the vesselID.

I wanted to control my form that i could forward, back, edit, add and save w/o that access record selector. I'm very new with access and any better option is highly appreciated.