Search results

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...

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...

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 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, 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...

How can i display the access columnhistory in a text box in a continuous form? I tried to use this code : Private Sub Form_Load() Me.txtHistory = Application.ColumnHistory("tbl_RegistryJob Query", "JobTimeline", "ID=" & Nz(Me.txtID, 0)) End Sub but when my form loads, all the column...