Search results

Hi I have a legacy system that i wrote a few years ago that worked fine with office 2003 but we are planning an upgrade to office 2010. The application included a emailmerge button that performed a word mailmerge in the background. With office 2010 the code just steps through not appearing to...

I’m struggling and I know I doing something stupid!! If I try the following SQL to return the date 30/04/2009 I get ‘error converting 30/04/ to int’. SELECT DATEADD(YEAR,-1,'30/04/' + DATEPART(Year,GETDATE())), Obviously I could just type 30/04/2009 but I want it to dynamically calculate...

I have an issue i would be grateful for some assistance on. I have a function that has a fieldname passed into it (relevant code below). i then want to use that fieldname to reference it on a form but it does not accept it. What am i doing wrong?? Any suggestions will be greatly...

When i link a SQL table to MS Access using ODBC the UNique Record IDentifier is not popping up. Does anyone know a way i can manually set this, or force it to pop up, as at the moment i can't add any records to my database? Thx in advance Ant

Hi, I have tried many different things to get this to work but can't, i'm hoping someone on here can shead some light or just tell me it is not possible. I have a report giving detailed spend by particular individuals and then a sub report in the header that lists the total expenditure for...

Hi I need to write a macro that will copy the 1st row of my spreadsheet and insert it into the row above the current users selection (which could eb anywhere). I can insert a row above the users current seelction using: Selection.EntireRow.Insert i then need to copy the 1st row into this row...

Spec: Access 2000 front and Back End, Jet sp8 I have a database that stores both English and Czech Characters. All characters display correctly in the table and on any reports i write. However, when i export using TransferText some of the characters accents are missing. I have discovered...