Search results

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.

Hi I have a simple recordset. the code is running okay until it reaches "rs!VesselID = txtVessel" in my code and it returds error 3164. I tried to manipulate the data in query form and I'm able to edit the field VesselID but when it is in recordseet it gives me an error. Please see my code below.

Hi Arnelgp, thanks for your reply. for just two spaces it puzzled me for hours. :)

Hi June7, the link is very useful. I studied the link and i came up to the code below. I wanted to add the current time in the file name and tried to add "& now() " in my code but i can't get this one work.

Hi, I tried to use the same process of updating my table source using SQL. Which is i only copy the SQL from design view and manipulate it in VBA. This is my first time to use this process in a query that will create table. I just don't know why my code returns "query input must contain at...

I thought i posted my reply. Anyways, Thanks the Doc_Doc_Man for the tip. I got my scroll bar for my text box.