Hi, The icon pack I purchased comes with .bmp files that are coded in RGB with magenta areas to define transparency. But they are showing up in the...

PW

Today 04:32 AM
Phil

Hi, I have the clipboard group working but when trying to add either (or both) print preview to the XML in the uSysRibbons table I am...

PW

Today 12:27 AM
PW

I have a continuous form (Takings) based on dates and I want to synchronise a second form (TakingsWages) based on a crosstab query pulling...

Phil

Yesterday 06:42 PM
Phil

I am preparing a delivery and am including the A2010 Runtime package along with our application's setup program. I included our EULA in the Package...

PW

Yesterday 06:41 PM
PW

I posted this question once before without a clear answer. I would appreciate any advice I could get. I am having a problem running a sub query in...

WhathaveIdone?

02-02-2012 07:25 PM
Bob Barrows

After you a command button to requery the data I want to return to the record I have been working in but at present it just goes to the first record...

FireyColin

02-02-2012 01:01 PM
Jan T

I have a report with a bound subreport on it (LinkMaster & ChildFields both set). The subreport's page footer doesn't print. Both main report & sub...

Phil

02-01-2012 05:56 PM
Phil

On 2012-01-31 9:07 PM, sparks wrote: As Larry points out, this is by design and trying to work around it in the manner you are investigating is...

Jan T

02-01-2012 01:27 PM
Jan T

Anyone have EXPERIENCE in converting 32 bit Access to 64 bit? I found this tool http://technet.microsoft.com/en-us/library/ff453909.aspx that...

BobAlston

01-29-2012 03:12 PM
Albert D. Kallal

Hi all, I have this issue importing rows in a access table. Depending on numbers and other data in a excel sheet (1,2,3,4,5,6 etc.) rows from table...

Ronald

01-29-2012 02:54 PM
bsn

Hi Not really an Access thing more of a Windows 7 64bit Issue. When I was running Windows XP, To copy and paste a file was like...

bobdydd

01-28-2012 08:41 AM
Patrick Finucane

Using Access 2007. I have been doing a bit of research and I think I need Redemption for this (as far as I understand, the CDO stuff that comes with...

Paul H

01-27-2012 07:47 AM
agiamb

hi I have a table containing several fields one is a date field i have summed the data and grouped my month depending on the date field value what i...

kevcar40

01-26-2012 06:09 PM
Phil

Hello, I have a specific problem with a continuous form, dependent comboboxes, andhiding key values. After a little googling this might simply be a...

Jeff Norville

01-26-2012 01:04 AM
Jeff Norville

Hi All, First, I'm sorry to hear about the death of David Fenton who answered a couple of my questions and whose answers to others I found useful. I...

Gilgamesh

01-25-2012 03:27 PM
Jan T

The CC Email address in SharePoint comes over to Access look like this: Person Name <PersonEmail (AT) mail (DOT) com> How would you go about...

musicloverlch

01-25-2012 12:10 PM
Bob Barrows

Hi All, When I'm in Outlook, I can change the "From" field to about 6 other email addresses. When I send an email through VBA I need to be able...

musicloverlch

01-25-2012 10:20 AM
musicloverlch

I have ID, First, Middle, and Last names (4) fields I created a Combo Box for record selection with the following Event Procedure: Private Sub...

Deac

01-24-2012 02:32 PM
Patrick Finucane

For Each ctl In Me.Controls If ctl.Tag = "add" Then ctl.Enabled = True ctl.Locked = False Else End If Next In the Form_Current event I have some...

BobbyDazzler

01-24-2012 10:20 AM
Patrick Finucane

I'm still persevering with my Multi select (extended) list box problems and have now identified the stumbling point. I use the KeyPress event to...

Bob Darlington

01-23-2012 11:11 PM
Bob Darlington

Access Report for Dance classes. One page per student listing their classes. Grouped by Name then sorted by Class, Date, and Time. There are 380...

Deac

01-23-2012 08:33 PM
Patrick Finucane

Albert or anyone else who has used Visual studio 2010 to create a client proxy for accessing a web service, then using it from Access 2007/vba and...

BobAlston

01-23-2012 04:00 PM
BobAlston

Hi I have just taken the plunge and upgraded to Window7 64bit Spent about 5 hours trying to get SaveAsPDF to work when I found blog warning that...

jeff003@youcanbillme.com

01-23-2012 10:53 AM
bobdydd

Hi, A client sent me an Access 2007 db.accdb which I modified using 2010. The client could not open using Access 2007 "Unrecognized database format...

Barry Edmund Wright

01-23-2012 09:51 AM
Albert D. Kallal

â·– - I have googled and it is the "Unicode Character 'ETHIOPIC SYLLABLE XYO' (U+2DD6)" I have created a new query with no tables and just one field...

BobbyDazzler

01-23-2012 04:29 AM
BobbyDazzler

Anyone using Access/VBA to interface with web services who has used a) WSDL.exe to generate a .NET client and then added the necessary "wrapper" and...

BobAlston

01-21-2012 10:19 PM
BobAlston

Hi I have just taken the plunge and upgraded to Window7 64bit Spent about 5 hours trying to get SaveAsPDF to work when I found blog warning that...

bobdydd

01-21-2012 08:26 PM
bobdydd

Hi, I have a combo box cboDate with the value "01/01/12" on a form. I click a button on the same form to run a query to insert records into a table....

Barry Edmund Wright

01-21-2012 07:12 PM
Bob Quintal

I am trying to access a table in a mdb using VBA though a brain dead program. The problem is it's modifying the the text inside a sql string...

Ron Paii

01-21-2012 03:27 PM
Tony Toews

My intentions: I am trying to build the WHERE clause in VBA for a pivottable form. I want to condition the results on dates and "premium"...

WhathaveIdone?

01-20-2012 06:03 PM
WhathaveIdone?

I have one form "frmInvoiceCash" which can be called from lots of different places in my application. I currently use the following code to pick the...

BobbyDazzler

01-20-2012 07:30 AM
BobbyDazzler

hi i have a table with a number of column ie date, reasons, cause, incident the files reasons, cause, incident hold a number entered by the user ie...

kevcar40

01-17-2012 04:15 PM
Ken Snell

Please see my posting at UtterAccess.com Hopefully someone here has experience using the Web services toolkit...

BobAlston

01-17-2012 02:38 PM
BobAlston

hi, Have a problem that I have not been able to correct. Attempting to create a shell to run "C:\Program Files\Remote Control...

stevenrec

01-16-2012 11:59 PM
Stuart McCall

I have ans Access 2010 SP1 report with a field "BoatName" set to CanGrow and CanShrink both set to True as is the Report's Detail Section. The field...

Phil

01-16-2012 06:20 PM
Phil

I am struggling I have an A4 report on which I want to print 4 identical A6 sub reports. Basically each sub report is a list of events for each...

Phil

01-16-2012 03:41 PM
Patrick Finucane

Hi, I am testing my new ribbons on a different PC. I am getting a couple of error messages: "Can not run the macro OnOpenFormNewRec" "User defined...

PW

01-16-2012 02:02 PM
PW

In A2010, I have a bound Form that is displayed as Continuous and is set to be Popup. Its size has been set. If I alter anything in this Form, e.g....

Keith

01-16-2012 10:18 AM
Keith

I’m trying to step up from being a decent Access Programmer, to including SQLServer in my repertoire and am running into a conceptual design problem....

Tom

01-14-2012 04:46 AM
Stefano C

My Post on Convert RGB Colours to HSL may well be irrelevant, so I will ask the basic question instead of guessing the answer. I have a continuous...

Phil

01-14-2012 04:13 AM
Phil

I have found all sorts of code to convert from RGB to HSL, but seem to get different results. I need to get the same results as the colour picker,...

Phil

01-13-2012 08:19 PM
Phil

I have a form which I want to filter based on a combo box (ComName), which is linked to a table. I have 1000s of records, but want to select a...

Paul

01-13-2012 12:15 PM
Paul

So: Access: 2003 - tables over 5000 records, too slow, and no referential integrity (no relational tables) 2003 - tables over 5000 records -...

BobAlston

01-13-2012 11:21 AM
Albert D. Kallal

So, I'm using my favorite search code from here: http://allenbrowne.com/ser-62code.html Once I have everything filtered on the form, the users want...

musicloverlch

01-13-2012 10:16 AM
Patrick Finucane

Hi: A subquery has me stumped. Suggestions appreciated... Simplified sql is Select Field1, Field2, (Select Max(FieldA) from tblEvent...

Tom

01-12-2012 07:33 AM
Tom

This is a follow up to previous unresolved thread which was getting a bit messy. I have a multi select (extended) unbound list box which has a...

Bob Darlington

01-12-2012 02:51 AM
Bob Darlington

Dear Access gurus, I am retrieving data from Access into Excel through ADO. It is quite slow. The data are retrieved from an Access queries. Will it...

Lane

01-12-2012 02:32 AM
Albert D. Kallal

Global Business Intelligence (BI) software vendor, Yellowfin, has released a new white paper that explores the need for, drivers and potential...

janette.pelletier@yahoo.com.au

01-11-2012 07:41 AM
janette.pelletier@yahoo.com.au

I am trying to interface Access 2010 with google calendars. I have a nice calendar program, ans want to be able to upload and download events to...

Phil

01-11-2012 04:53 AM
Phil

Hi Access experts, Does anyone know the ADO connection string used for connecting to a password-protected Access 2010 database? So far, I can...

Lane

01-10-2012 08:02 PM
Lane