arnelgp's latest activity
-
arnelgp replied to the thread Solved DoCmd.GoToRecord doesn't take me to the requested record.it may not be evident on a Single user. possible even Lock the whole Table on multi-user when issuing SQL Update. -
arnelgp replied to the thread Export table data to excel.goodluck and hoping for the best.
-
arnelgp replied to the thread Standard Modules and Global Variables.Private Sub opt_AmPm_F_AfterUpdate() hh_F = Me.opt_hours_F mm_F = Me.opt_minutes_F ap_F = Me.opt_AmPm_F If (ap_F = 1) Then ampm_F =...
-
arnelgp replied to the thread Solved DoCmd.GoToRecord doesn't take me to the requested record.because you are using a Memory copy of the recordset. using SQL Update will update the table physically, but your form (if bound to that...
-
arnelgp replied to the thread calling the value of a field from a main form -> subform into a query.how do you call it then from "note" subform? better create a Timer Event sub on "note" subform, then call it there. this will ensure...
-
arnelgp replied to the thread Make image interact with control source.on the Attachment control Property Sheet->Data, set Enabled to No.
-
arnelgp replied to the thread calling the value of a field from a main form -> subform into a query.the question is "where" are you calling this query? if in the subform, it is too early as subform Note might not be Loaded yet. //edit...
-
arnelgp replied to the thread No record yet for dsum process.to check if there is any record in a table, use DCount("1", "tableName"). it will return 0 or number of records in that table. ex...
-
arnelgp replied to the thread database coordinator high school class.add code to the report's Detail section On Format Event: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...
-
arnelgp replied to the thread Change Recordsource for a Sub.Report.there is No way you can change the Recordsource of a Report other than it's Open Event. likewise there is no way you can set it's...
-
arnelgp replied to the thread Hello everyone.allan wa salam! for novice like you, try reading books/e-books about ms access first and do it a step at a time. you'll get frustrated...
-
arnelgp replied to the thread conditional formatting for the last record per group.I also made an example without using extra Query and only using Condititional Format.
-
arnelgp replied to the thread Export table data to excel.Vlookup is you validator. if vlookup finds it in sheet2 then it is valid. otherwise if an error occurs, meaning nothing is found then...
-
arnelgp replied to the thread Export table data to excel.how do you want it validated? I think you can use Worksheetfunction.VLookup() to check if a cell is in the other range.
-
arnelgp replied to the thread Solved Filtering a many side of relation with two conditions..my guess is: select tblOrders.* From tblOrders Where OrderPK Not IN (select OrderFK From tblOrderProgress Where (ProcessFK = 11) Or...