Search results

Hi All, I would like to be able to have a button on a form that when clicked brings up the Colour picker chart like what is used setting colour in Design mode. Then when a colour is selected the colour code gets dropped into a field that can be referenced later by a form to colour code as...

Hi There, Does anybody know what needs to be modified in the following Excel code, so that it can be run from Access. (I have added the xlApp. as needed) xlApp.Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False If I just have...

Hi All, I am running some Excel code within Access after exporting to excel using the code below. All is ok except at the line... xlApp.Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5), Replace:=True, PageBreaks:=False, SummaryBelowData:=False I am not sure what other...

I have an Alter Table command followed by a Transfer Database command which transfers the tbale just alterred to another Access Database. The transfer command works fine as does the Altar table independantly however when the transfer follows the Alter table it cannot find the table to transfer...

Hi All, I have a query which outputs a number of fields. SELECT qryTypeofProject_Report.* FROM qryTypeofProject_Report; I have used SELECT qryTypeofProject_Report.* in order to get all the fields from the initial query its based on. I want a final field that merges all the previous fields...

Hi All, I am exporting a Query to excel to an existing Folder. I would like to be able to export to a new folder that is created before the export ie labelled by the current month. So my question is, is their a way to create a folder say on the desktop, labelled current month before the...

Does anybody know how to amend this code so it works in Access. Set xlApp = CreateObject("Excel.Application") xlApp.Cells.Select xlApp.Selection.Subtotal GroupBy:=11, Function:=xlSum, TotalList:=Array(10), Replace:=True, PageBreaks:=False, SummaryBelowData:=True...

Hi All, I have a table that has multiple records that are basically duplicates that differ in one field only. I want to get rid of all duplicates leaving 1 record which is the one with the highest value in this field. Can this be done with a query? or do I need to use VBA code to generate this...

Hi All, I have a table that has multiple records that are basically duplicates that differ in one field only. I want to get rid of all duplicates leaving 1 record which is the one with the highest value in this field. Can this be done with a query? or do I need to use VBA code to generate this...

Him All, I am trying to change the forecolor of multiple text boxes after the selection of one or many of these text boxes listed in a List box. As a user selects from the list the coresponding text box needs to change to red. There are a lot of text boxes and I do not want to have an...

Can anybody assist me with this? The file outputs OK to the location I want however I keep getting an Script Out of range error when Access tries to open the file to run the rest. DoCmd.OutputTo acOutputQuery, "qryExcel_Selected_List", acFormatXLS, "C:\Users\" & Environ("UserName") &...

Hi All, Is there a way to format a text box to allow a space at the very end of a alpha/Numeric entry...ie "@@@@ ". Every time I type the space at the end it drops off however I want the space to be a part of the Text box entry. Thanks All.

Hi All, I have a Union query that brings together several tables into one. This works perfectly well however there is an occassion when a field in one table has its data type changed to text from date. This is to allow N/A to be entered rather than a date. When this occurs the union query...

Hi All, I have a List box in a form which is currently showing the Field List of a table. I also want to show the data type of each field next to each field name. eg Field_1 Text Field_2 Text Field_3 Date Field_4 Text I have set the List Box to column count 2 however all...

Hi All, I am using the followong code to create a form on the fly based on another form... Set frm = CreateForm(, "frmTemplate") This works fine for what I want except frmTemplate has some code within it which runs On Load however this code does not copy over into the new form. I have tried...

I have written this code, below, which populates a list box with outlook contact items. This is working very well. I have the List box row source type set as Value List. The code simply builds the Row source string and inserts. The issue I have though is that the list is not in Alphabetical...

I have a worksheet that every month when running a month roll over VBA code, creates a new month column on the right side Therefore increasing the number of columns. I have frozen the left hand column with the row labels. I am using code in a form to go to the particular worksheet however I...

I have a database that is built in Access 2007. It utilises a nice command "Docmd.RunCommand acCmdAddFromOutlook" which opens a browse window of outlook contacts and then imports selected contacts into an Access Table. My problem is that the database has to be run in Access 2003 and this...

Using code I want to make a particular field null as a part of some other actions that are taking place. I have successfully done what I want when the form is set as Single form however when I change the form to Continuous the same code will make the particular Field null for the first record...

Hi All, In Access 2007 there is a built in Macro that has an "Add from Outlook" Macro which when used in conjunction with a contacts Table template imports the fields from Outlook Contacts into an Access table. This is a very nice feature. 2 issues however.... I have this button set on a...