Search results

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 :)

use Stephen Lebans RowNum() function. you do not need to save the value to a table.

i've never use a gantt chart, so my sample simple gantt chart might not have the function you are looking. but this is an entry level, no sub-category, just straight single tasks. it took me some hard thinking on this one.

how about support, is he willing to train and give support for Free? :unsure: i've seen his demo, but it is ridiculus to work with, specially the mouse.

did you get his Gantt Chart for free?

NO, i don't need to buy anything from anyone.

yeah right, like in .accde or in .mde?