Search results

  1. M

    fetch Image from table to report

    i have Image stored in my table named Company_Profile i need to fetch that image in my reports i use image control on my report then i put this in Expression builder =[Company_profile]![Company_Logo].[FileData] when i open report in view mode it will give message inter paramter Company...
  2. M

    report Image QR Code on report

    i have QR Image ready on my form how to report it on Report
  3. M

    convert (text+numbers) to Hexcode then to base64

    hi dears i have a value in text-1 like this Text -1 0113Alarabi Group021120003548231032212/27/2020 10:47:08 AM0446900053900 question is i need to convert text-1 value to text-2 then text-3 text-2 convert text-1 to Hex in text-2 text-3 convert text-2 to Base64 in text-3
  4. M

    QR Code without software or API

    hi dears good day are there any easy way to make QR CODE To invoice without having adding software or using online API
  5. M

    report Time only by form Date

    hi dears good day i would like to report or show only time on my report so i have a Date on a form ,, can i take only time value from the date to show on my report
  6. M

    affect same data in column at linked two Table

    hi dears good day i have table Header and Cloumn called Branch_id and i have table Details and Cloumn Called Branch_id form like Invoice Headers and Details i use one form to insert data to Header & Details (Header one record primary key and Details many records as Subform forein key)...
  7. M

    clean insert into code but no data reach table

    Dears good day i have clean insert into code i used with empty 2 test tables and it work very good and the data go there smothly but when i move to orignal tabels which have same cloumns names , but original tables has some data inside it will run code also with no error but no data...
  8. M

    affect form control value with another

    hi dears good day i wish to find code to enable and disable JV_Post Button when check box is YES THEN JV_Post Button become enable = no
  9. M

    insert into code

    private sub () Dim db As DAO.Database Dim header_jv As String Dim Details_jv_1 As String Dim Details_jv_2 As String 'Header Variables Dim Bill_Number As String Dim branch_id As Integer Dim Bill_Date As Date Bill_Number = Forms("Bills-or-Expenses").Bill_Number branch_id =...
  10. M

    use insert into with two relational tables

    how to make data enter two relational tables using insert into statement i have two tables for invoicing one for invoic head data and other table for invoice items and details so how to use insert into with in two tables they are related
  11. M

    ERROR 3137

    here is the code trying to insert two line in same time by the way one line is working but when trying to add another line it give error 3137 "INSERT INTO test_table_transactions (T_Account_Number ,T_acc_sub_number,branch_id)" & _ " VALUES ('" & Account_Num & "','" &...
  12. M

    save data from my current form to anther table not connect to form

    i need simple way to save data to another table in my database i have form_1 saving data in table_1 but i need to take some data on form_1 and save it in another table_2 i need also to edit the data in table_2 if edit the form_1
  13. M

    Invoicing +accounting vouchers

    Hi dears I have form for invoicing or bills For example logistics or transportation bill I need to make automatic accounting vouchers after saving the bill I have every thing ready like the item linked to accounting number and vendor linked to accounting number but need idea
  14. M

    unable to create accde file

    Hi Dears Good Day how can i deal with this Error unable to create accde file i want to convert my access project to exe file
  15. M

    Navigation form replacement suggestion

    Dears Good Day are there any replacement for Navigation Forms i need to collect all my forms in one place with out changing for example Critreia & parameters in my Queries from [Forms]![AccountingReports]![datefrom] to [Forms]![MainForm]![NavigationSubform].[Form]! i have many...
  16. M

    many forms one (save or delete) button for all

    Drears good day i already have many forms i want to put them in one form or navigation form or i use form with Tab control at the end i want to make one save button for all forms one delete button for all forms one search button for all forms thanks in advance
  17. M

    Solved query data shift or move from clolumn to other

    hi dears good day i am asking if i can if there is null on column (name_english) then the yellow data move from (Chart_Name_English) column to the Null column please look at PIC attached
  18. M

    Query Filter

    Dears Good DAY i want to remove Yellow rows as PIC attached on another way i need Query whithout Yellow Rows
  19. M

    Solved report not like query

    i have query like PIC and report is not getting the same data 2 yello rows in Query result in 1 yello row in report
  20. M

    Solved query repeating rows

    hi dears good day please look at two PIC Attached i have Trialbalance Query show Total Account Transaction for all Pettycash Employees it is very good query i like it so the proplem here when i want the total account query to be in details by Employees like second PIC , It will...
Top Bottom