Search results

Hi philben, I have attached the database with the table. I have tried to do the query and it is not working. May be my syntext is incorrect. Please have a look my attached database. Thanks Raghu

I have a table with the following fields surName Text commDate Date ceaseDate Date tableID Autonumber (Key) The following are some sample records. surName commDate ceaseDate ID ------------------------------------------- Prabhu 01-Jan-12 15-Jan-12 1...

Hi All, Was able to solve the problem. This method helps the users to copy a record within the same table and amend the first record and then amend the second one at the same time. This method can be used to copy and amend record from one table into another.

Hi All, Wish you all a Merry Christmas and a very safe, Happy and Prosperous New Year! Attached a small database. The tblMain holds the persons details. secTable holds the commence and cease records. Commence is actiontype 1 and cease is actiontype 2. I am able to copy a commence record...

Post the data and may be some one will be able to help you.

Hi bass twich, Please look at my sample. It creates the reports in txt files instead of pdf. Hope this helps.. http://www.access-programmers.co.uk/forums/showthread.php?t=217439 Cheers Raghu Prabhu Melbourne, Oz

Hi All, I have attached a small database. It creates the required folders, subfolders and pay cables in txt files and then emails them to the addressees. It also creates an excel spread sheet, and four other reports in txt format. I have problems with three of these output files. Please look...

Hi All, The following is the code behind the click event of a button to close a modal form. Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click Dim conn As ADODB.Connection Dim sSql As String ' DoCmd.SetWarnings False ' DoCmd.OpenQuery "qryUpdate", acViewNormal, acEdit '...

May be try this. It a a QPMF database that I have designed and built. All fields need to be filled before the save button is enabled.

While desiging the table, in the general tab, make the required tab as "yes" and zero length allowed as "no" that will fix your problem. No need for any coding. See the attached figure in the word document zip. Cheers Raghu Prabhu Melbourne.

Hi Venu, This may help you.... Cheers Raghu Prabhu Melbourne,

Thanks a lot. It worked like a charm. I was not thinking properly when I joined both the tables. It is working very well. Cheers Raghu

How do I create a query for no data. In the attached database, tblImportedData does not contain any data for the following countries ID CountryName 11 MICRONESIA 22 COOK ISLANDS 25 TUVALU 29 EAST TIMOR 30 ISRAEL 34 JORDAN 35 SWEDEN 36 ITALY 37 CYPRUS 39 EGYPT 40 IRAQ 41 AUSTRALIA 43 KUWAIT...

Thanks will work it out slowly...

I have a table called tblCountryName. It has two columns, an ID column and a country name column which has names of 45 countries. I want to create txt files in the same directory of the database in the following format “countryName-ddMMMyyyy.txt” for example “Australia – 22Aug2011.txt“ . The txt...

Hi All, I have a small database. It has three tables "tblCountryNameAndNumber", "tblImportedData" and "tblService". "tblCountryNameAndNumber" has names of 45 countries and "tblService" has three records. The working table is "tblImportedData". Not all countries have to people working for...

This small database might be of help to you. Cheers Raghu Prabhu

I found the FindFiles.mdb database on this forum. I am trying to use to import data from a text file in to the database. The txt file is “Pp0414ab.txt”. The table it should be imported is “tblImportedData”. It is not working properly. There is no heading in the txt file. The fields are separated...

Hi All, I have attached a small database. There are three tables “tblFYear” , “tblPayPeriodAndDates” and two forms “frmMain” and “frmPayPeriodAndDates”. The data source for frmMain is the “qryPayPeriodAndDates”. This shows the next pay day is 04-Aug-2011 and we are in pay period 03/2012...

Hi to One and All, I have attached a small database in 2003 format. We have three different formats for phone numbers Normal format (03)92823600, Free calls 1800-464-444 or Mobiles 0421-458-555 (same formatting) and Short format 131-181. It was decided at my work that we use one phone number...