Search results

here this time this has highlight and without flicker.

here test your db. i arrange the Tab order and also add ControlSource to textbox txtSelectedRecord.

i save the record immediately after each scan.

record_id is autonumber and is unique, so you will end up with All the records returned. use Total Query: Select Min(record_id) As minRec, artist_name, Min(record_release) from yourTable Group by artist_name;

that is a presumptive size. when you add table to blank database, it create the table, yes. but it also add record to MsysObjects and other system tables.

i don't get any error on the new code.

try and test your db.

while in Design view of your form. Set the Bound Column of the Combobox to 1 (ClientID). Column Count = 2 Column Widths = 0

upload your new db. the subform name might have been changed.

it is still Long whether x32 or x64 unless your table is Linked Table and using Large numbers. LongPtr only applies to Window Handler or Memory Pointers and does not apply to MS Access Intrinsic numeric types.

change the After_Update to: ' arnelgp ' change this to Public so it can be called from external Public Sub txtProductCode_AfterUpdate() Dim lngProdID As Long Dim strReturn As String, var As Variant If Not (IsNull(mID)) Then 'remove this 'DoCmd.GoToControl...

I think the B there stands for Byte. Len() will count the number of characters, while LenB() will count the number of bytes. so, LenB will return 2 times the result of Len().

Win32Api text file is found on this forrum: https://www.access-programmers.co.uk/forums/threads/win32-api.299801/

try this, make sure you read the VBA code. you also remove "unnecessary" keys on your Keyboard POS, since it is mainly used for manual entry of Product Code (no math involved).

GUID? as in you want to create Object from GUID? here the same demo db, with Clipboard GUID ("{1C3B4210-F441-11CE-B9EA-00AA006B1A69}") if you select this record, it will show you the Text content of the clipboard (if there is).

just put it in a Table (tblConsVariables) ConsName (Short Text) ConsValue (Short Text) if the Value of the Constant is Numeric just convert the string to numeric, ie Val(ConstValue & "") here is a demo db for you to check out.

you can also try this note that I added code on the After_DelConfirm, so that it will renumber correctly when you delete a record. Private Sub Form_AfterDelConfirm(Status As Integer) Dim rst As DAO.Recordset Dim LastSequenceNumber As Long If Status <> 2 Then Set rst = Me.RecordsetClone...

you need to put all tables into one and just add fields like, PK field, building Number, Station Number (floor number) to distinguish each stations. this will be your Master table. then on your daily records, you just add a FK and the details of the record.

if form, "Job Form" Textboxes has the same name as your Field name, you can try: DoCmd.OpenForm "Job Form" DoCmd.GoToRecord acDataForm, "Job Form", acNewRec With Forms![Job Form] !Manufacturer = "TBC" !Model = "TBC" !Serial = "TBC" !Description = "TBC" !StatusID = 9 End With

congratulation on your new Haus :)