Search results

While clicking on button "Email Salary Slip" as attached in *.mdb file we are getting the following error (Snapshot attached) Description: The System cannot find the file specified.; Error Number:-2147025894; Source :CDO.Message.1 Unable to send Salary Slip Email in PDF format with password...

Dear Sir, The Below mentioned VBA Access Code is working in Windows 11 O/s but the same is not working in Windows 7 O/S. Similarly respective setting of Email Accounts of different Operating System i.e Windows 11 O/s & Windows 7 O/s is attached here as Image. Unable to send the Email , We are...

On Enter Key Press , check the validation if User Name and Password is perfect open Main Form Kindly suggest the VBA Code. File attached.

In Ms Access (VBA) , How to get all the dates of the month after selecting the certain month and weekdays?

Dear Sir, In MsAccess 2007 I have two Forms, Form1 and Form2 The code written :- Dim stDocName As String Dim stLinkCriteria As String DoCmd.Close acForm, "Form1" stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria I have also used the following syntax :-...

I have created a Report in Ms Access File ( MDB) as attached, Wherein report is in Row wise format , but I want it in Column Format i.e in Label format In Three Columns (Sector -1 , Sector -2 ,Sector -3 ) in Small it is mentioned as SEC-1 similarly for all sectors. Two Class are there ( Crew...

I am using my Ms Access 2003 database file is two different Ms Office Version's. I am using Excel file in it But Whenever I update the database and keep it is different locations, On Opening it is gives us an error "Your My.mdb database or project contains a missing or broken reference to...

I Have multiple Queries in Trans Form, but will ask one by one in each threads I Have a three tables : Item_Mast, Flt_Master and Trns and all are linked as shown in Snapshot attached. In Trans Form : All Three TABLES Data will be requiring in Trans form. Here...

I have created a SQL Server Sequence (Backend) CREATE SEQUENCE [dbo].[Airlines_Mast_SEQ] AS [int] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 99999 CACHE GO CREATE TABLE [dbo].[Airlines_Mast]( [ID] [int] NOT NULL DEFAULT NEXT VALUE FOR [Airlines_Mast_SEQ] PRIMARY KEY...

Query 1 : In Ms Access, I Wish to Create transaction Form linked with Multiple unrelated tables (Transaction Table, Flight Master, Item Master). Snapshot attached Query 2 : Item Master Table Master Item change dynamic and data entered against it thus it should be in Grid Format/ Sub Form...

Hi, As per the Access File attached , I want to run Append Query to Append "TRNS" Table from Item_Mast! item_Code ,Item_Mast! item_Code, Cat_Mast!cat_Code , Outlet_Mast!Outlet_Code. But outlet_mast!Outlet_code is in RELATIONSHIP with TRNS table and i wish to am inserting data in TRNS table...