Search results for query: *

I have it sorted it now, had the code behind the command button on the subform instead of the main form. Dim x As Integer x = Me.RecordsetClone.RecordCount Me.InsideHeight = 20 + x * 20 It's working now. Thanks for your help.

Hi Duane, I only realize it's the SubForm in the details section I am looking to hide or shrink This code below seems to work for a form without a subform but I cannot seem to get it working with a subform in the details section Dim x As Integer x = Me.RecordsetClone.RecordCount...

Hi, anyone know how I can hide and unhide the Detail Section with controls on a form. I would like to use a command button from the form footer section to hide, minimize or shrink this section along with the controls. Thanks

Hi All, Thank you for your input all, I figured the “invalid check digit” error was due to not accounting for the check digit on this type of barcode: UCC /EAN 128 barcode (00) 1 0123456 361586002 http://www.gs1-128.info/sscc-18/ I have since coded for this check digit in a module and...

Hi, I apologise for double posting this on Microsoft Access: Other Topics but in desperate need of assistance. I am trying to encode the following (00) 1 0123456 361586002 into a UCC /EAN 128 barcode label in my Report The record source is from table called Delivery and uses the following...

Hi, Not really sure where to ask this question, I am trying to encode the following (00) 1 0123456 361586002 into a UCC /EAN 128 barcode label in my Report The record source is from table called Delivery and uses the following three fields ( A1Code, GSI and PalletNo ) I have tried following...

Hi, Could anyone explain why this happening with Access 2010? This code works with Access 2003 but since I've changed over to Access 2010 I am getting this error now even with the use of dbSeeChanges. “ You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table...

Hi Duane, Thank you for the reply. I have attached link to the database. Perhaps you could have a look and see on Customer Schedules Form http://www.mediafire.com/?xe87a66egibw85n Thanks

Hi, Hope I could get some assistance here? I have a form and subform (datasheet) based on 2 tables, Customers and Customer Schedule. Customer Schedule subform (datasheet) has a tick box named "Completed". How do I select only those records for customers from this datasheet whose schedule have...