Search results

I am trying to port over a number of access db's to SQL Server, and I want to avoid rewriting the data access code. I am currently testing on SQL 2008 Express on my local machine, and am using the SQL Native 10.0 driver. My table has a primary key, and I can open and write to the table...

Hi Mark This works really well !! Thanks very much..

I have a subform which I have some code in the Current() event. For some reason it gets triggered twice when the main form is opened. Anyone got ideas as to why this is and how I can trap for it ?

have a look thru this http://wwwimages.adobe.com/www.adobe.com/content/dam/Adobe/en/devnet/acrobat/pdfs/reader_overview.pdf

Does your PDF program have an API ?

I've been developing with Access for over 10 years now (still mainly using 2003).. And i've never used any of the 'extra' controls available from the tool box.. Do you guys use any, and if so then what for..

In your code that opens the report: If monkey Then DoCmd.OpenReport "Report", acViewPreview, , , , "qryMonkey" Else DoCmd.OpenReport "Report", acViewPreview, , , , "qryBanana" End If In the Open event of the report: Private Sub Report_Open(Cancel As Integer) Me.RecordSource =...

Thanks for the replies guys.. I've uploaded the file.. A table with two records, one record has a space as a separator, the other has the unknown character. Ran this, turns out its Ascii Char 160.. which is a 'non-breaking space'.. I'm not sure how it could have got in to the system, but i...

I am querying full postcodes in our database and it appears some of the postcodes contain a null character as opposed to a space between the first and second part of the postcode.. For example, If use the Ascii Tool on http://easycalculation.com/ascii-hex.php to convert 'GL7 7JY', it returns...

Thanks I can understand this, but if the system is built properly from scratch then I can't see the harm in it.. I have always developed db's in the past and exposed the keys for human consumption.. plus you can only have one autonumber field on an individual table..

Thanks Spikepl I could do that, but i need I want the database to do the work of ensuring data integrity.. A Booking Reference is unique to an Event and the existing booking references cannot change. I suppose the only other way I can think of to enforce this is to create a seperate table...

Hi Guys I am trying to consolidate our Booking databases into one... And I have a problem which comes from the data. Currently, an individual booking databse is setup for each Event that our company hosts. The old structure the following key fields BookingRef: Autonumber ContactID: Long...

Hi Guys Have any of you calculated the memory requirements of your databases when upsizing to SQL Server? Our organisation currently has some SQL 2005 Workgroup Edition licenses which are not being utilized. So I am being told that I have to use this edition unless it does not meet...

One more thing.. Should intellisense work all of the methods within the dll ?

I need to build a report which will be 3 pages for each record. The report is contains a Direct Debit mandate in the middle.. Page 1 is the agreement with payment options Page 2 in the DD mandate Page 3 contains personalised data collection info I cant fit all of this into one report as the...

Thanks DJKarl.. This worked !! Cheers Banana.. thats useful to know..

Yep Yep.. Started from scratch and went thru the full procedure.. Now have a different error.. 'ActiveX component can't create object'..

Hi Guys I've built a basic .NET dll and am trying to reference it... I've followed the instruction on this link.. http://www.geeksengine.com/article/create-dll.html The instructions have worked on my machine (I have VS 2010 installed), but when trying to get it registered on my colleagues...

Thanks guys.. Has been an interesting topic for me..

Yeah, essentially I just wanted a switch for managing connections when deploying and I may also use it to relay environment info to the on the main menu.. Didn't know that.. thanks