Search results for query: *

I have a query (QryPersonalDetails)which extracts data from two tables, using a common field (Alias). TblMaster_Address_List contains 600 records and TblPassportDetails contains 21. My problem is that the data is extracted OK but I cannot amend it. I assume that Access will not allow me to...

I have a form which displays personal information for an employee (name, adddress, passport details, visa details etc.) The form contains 40 fields. I would like to have a tick box alongside each field so that the user can select certain fields (e.g. passport details) and then press a command...

I have two tables, TblCompetitor and TblClass/Peters. TblCompetitor has 93 records, one for each competitor for the current year. TblClass/Peters lists all competitors for the past four years, thus many of the names have an entry for more than one year. Using the names and initials from...

I have an update query (QryClearCompetitorDetails) which is used to re-set the data in a number of fields of a table (TblCompetitor)as follows: UPDATE TblCompetitor SET TblCompetitor.TxtName = Null, TblCompetitor.TxtInitials = Null, TblCompetitor.TxtRank_Rating = Null, TblCompetitor.TxtUnit =...

I receive an Excel worksheet by email every day. I open this file, print it and then save it to a folder "N:\VBR\Current Month" with the file name being the date of receipt. I can use "GetSaveAsFilename" but this requires me to specify the file name. I would be most grateful if someone...

A particular Word document is received by email every day. I open the document, print it and then want to save it in a particular folder. I have the following code which saves the document with today's date: strDest = "N:\Access\Houston Updates\Current Month\" & Format(Date, "DD MMM") &...

We have recently upgraded from Mailgate to Microsoft Exchange. In Outlook on my PC I had the following code to saved a particular attachment to a specified folder: Dim myOlApp As Outlook.Application Dim myInspector As Outlook.Inspector Dim myItem As Outlook.MailItem Dim...

Is there a code which you can enter before a series of queries are run which will stop the results of each action flashing up on the screen? Ideally I would like the screen to display just a rotating hour glass or similar whilst the code is being run. Best Regards John

I have a query (QryPresident_Count) which returns two fields - TxtUnit and CountOfTotal. If the CountOfTotal is greater than 2 I need to run another query (QryPresident_DeleteDuplicates(W)) to remove the unwanted records from the underlying table. I have written the code below but when I run...

I have a Command Button that executes the following code Private Sub RptPresident_Click() On Error GoTo Err_RptPresident_Click Dim stDocName As String Msg = "Are there any duplicates?" Style = vbYesNo + vbDefaultButton1 Title = "DUPLICATE RESULTS" Dim PauseTime, Start...

I recently started thread 701-894603 in which I posed the following question: I have a table named TblPresident containing the following three fields: LngCompetitorNo TxtUnit Total "Total" is the sum of the scores from two competitions. For each TxtUnit there are four Totals, one for each...

I have command button on an access form which runs the following code: Private Sub ExportToExcel_Click() Dim wbXL As Excel.Application Set wbXL = CreateObject("Excel.Application") DoCmd.OutputTo acOutputQuery, "QryVP", acFormatXLS, "VP_Access.xls", True wbXL.Application.Visible =...

I have an Access form with a command button that runs the following code to export the data to Excel: DoCmd.OutputTo acOutputQuery, "QryVP", acFormatXLS, "VP.xls", True Application.FollowHyperlink "N:\Access\BackgroundVP.xls" The Excel spreadsheet BackgroundVP.xls has an automacro with the...

I have a Access form with a command button that exports the results of a query to Excel using the following code: DoCmd.OutputTo acOutputQuery, "QryCTP", acFormatXLS, "CTP.xls", True The data in "CTP.xls" is then imported into another spreadsheet named "CTPartic.xls". I would like to...

I have a form with a sub form which displays cargo tank details for a particular vessel. The main form has an unbound text box which is used to select the vessel name, based on a table (TblVesselDetails) and the sub form displays a series of records, each of which contains details for one cargo...

I have a sub form which displays four records based on a selection in the main form. Each record contains four fields, three of which are for information and the fourth is where data is entered. Thanks to Lupins46 I have the focus moving down through the four records, stopping only on the...

I have a sub form which displays four records based on a selection in the main form. Each record contains four fields, three of which are for information and the fourth is where data is entered. Having selected the information required in the main form, the focus the moves to the data entry...

I have a table which lists events that occur on the same date each year and a form which extracts data from this table and lists the events in date order. Unfortunately, month end is the 26th of the month, so some of the events at the end of each month are included in those of the next month...

I have a Word template into which a number of files are inserted using a macro. At the end of the insert procedure I want the macro to prompt the user for a file name under which to save the modified template. I have searched everywhere for a method of doing this but all the "save" procedures...

I have a query that lists "SumOfLngPracticeScore" and "CountOfLngCompetitorNo" which gives me a list of scores (in descending order) and the number of competitors that have achieved that score. I need to allocate points to each score based on the number of competitors achieving it. e.g If the...