Search results

Hello everyone, I'm encountering an issue when exporting data from a Microsoft Access form, which includes subforms, to an Excel file. Specifically, when I attempt to sort the data in the Access form (either ascending or descending) before exporting, the exported Excel file ends up containing...

Hello everyone Can Grow and Shrink in continuous subform fields automatically extend or shrink vertically based on the content.

i fixed it with below code : Thanks you all Private Sub userName_AfterUpdate() On Error Resume Next Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("Select * from tlogin where userID =" & userName) If rst!remember = True Then...

Hello evreyone, How do I prevent other users in internal network To use my username and password if I saved the username and password in the tabel login as remember My UserName have full accsess , i dont need others user to see it . Note :- Database was shared internally in internal network...

Thank you The_Doc_Man , its work fine now without any erorr

its done , Sorry

Option Compare Database Option Explicit Private Sub btnCalculator_Click() Dim calculatorPath As String calculatorPath = "C:\Windows\System32\calc.exe" ' change the path if necessary Shell calculatorPath, vbNormalFocus End Sub Private Sub btnDemo1_Click() If IsNull(Me.form1) Then...

Thank you for your response, @The_Doc_Man. I believe I've identified a few key points : 1. i suspect that the issue may be related to the image type used for buttons, and i have noticed that : changing the icon to image type ( ico or bmp ) format resolved the problem after testing it multiple...

Hello evrey one When i add or Change buttons .icon or images in my databas i see below erorr after it : *The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure] *There may have been an error evaluating the function, event, or macro* Note ...

Thank you Mr. @Pat Hartman I appreciate it

Could you please provide more details? @Pat Hartman Thank you in advance Editing on VBA codes, or making regular modifications on data entry in other forms

i have Simple Live chat between users as messages pop Running with timer = 1000 is only 1 seconds. now 😞 should be better to changed to 30 seconds or delete it from the system , Thank you for your advice . i appreciate it @The_Doc_Man

@June7 & @The_Doc_Man Thanks for your advice! I've made the changes you suggested to my database. Your help means a lot 👏 i updated it as below

Hello everyone, I'm looking for help . I need a professional to review the database (codes and the relationships) to ensure it's reliable to avoid future issues. I'm not a professional I'm willing to pay a small fee if it's allowed her . Thank you

Thank you for your advices . @Pat Hartman

i try before to added two new calculated fields: SumOfSellingPriceAED and SumOfPurchaseAmountAED. These fields calculate the total selling price and total purchase amount converted to AED using the aedX IF IT USD USE USDX , IF IT SYP USE SYPX , IF IT EUR USE EURX SELECT DISTINCT...

Hello Need idea or way to To build Commission Report 35 % from the profit (TOTAL Selling - TOTAL Bills ) * 35 % if invoice is Commission (checkbox) true its multi Currency , Based Currency =AED , Exchange rate is diffrent from invoices to other

Thank you Mr. Pat Hartman for it , I am learning about it now , and I have already fixed some of it .

tblBill = table of bills = equal = purcheses from our ( suplliers ) to show how much total bill unpaid for each suppliers

Bill TABLES names = tblBillT & tblBillH