Search results

hurry up you only have a month to inform: "Support for Microsoft Office 2016 ends on October 14, 2025. After this date, Microsoft will no longer provide security updates, bug fixes, or technical support for Office 2016. Continuing to use Office 2016 after this date will leave your devices...

using the table and code i gave on post#8

sorry, i tested on single datasheet subform and it does save the height. tested on two subform and it does Reset it's size back when opened the Main form again. what you can do is add another table to your db (tblRowHeight) with following fields: FormName (short text) RowHeight (long integer)...

maybe you can save the Form when you close it: Docmd.Close acForm,me.name,acSaveYes or maybe your form got corrupted. try rebuilding the two subforms.

i did not get any error using DDL SQL that i posted. but i did get error using your code: .columns("Id").Properties("Default") = 0

Microsoft ADO Ext x.x for DDL and Security

you can defer the Default part and add that Property using DDL SQL: Public Sub CreateTable(strPath As String) Dim cat As ADOX.Catalog Dim tbl As ADOX.Table Dim idx As ADOX.Index Dim flag As Boolean Set cat = New ADOX.Catalog cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath...

Access2010/Frida, i added the conditional format to the textbox $_Percentage. the field source is a short text, but i did not change it to number. because i don't know if other forms are saving the value to this field. please see the Conditional Format of this textbox in design view.

google the code, it is available everywhere on the net: Function AttachDSNLessTable( _ stLocalTableName As String, _ stRemoteTableName As String, _ stServer As String, _ stDatabase As String, _ Optional stUsername As String = "", _ Optional stPassword As String = "")...

the Save and Cancel buttons are of no use if you are not using Transation. when you press any button, the form will try to be saved before any of your button code will be called.

yes it is on the Conditional Format of Percentage (PC) textbox. to view, goto design view of your form, click on the Percentage (PC) textbox. on the Menu->Format->Conditional Formatting.. but unfortunately it is being format for it's value only and not "comparing" to the "cost price".

the suggestion is being offered to the OP and not to anyone.

whether Full version or runtime it will work. so with the .bat/.cmd file.

as suggested in post #13, you can use an MS Access Loader (or startup db) that wll check if there is new version of your FE somewhere and copy it (if it is the latest), then close the loader and start your normal Access app. there is such db on post #4 on this thread...

just noticed this although i don't use salesforce.

done.

i think what you are trying to ask is a barcode scanner. because if it was a document, you can manually scan it using scanner/printer and save the pdf. in case of barcode, you need to buy a barcode reader. it has same functionality as a keyboard, so whatever you click to scan will be recognized...

use the complete code on the earlier post, not a simple open/close of access app. open the app, open a db ,Run a public sub/form/sub. close the db, and quit the app.

change the definition of rs from: Dim rs As Recordset To Dim rs As DAO.Recordset