Search results

Hi, I have some VBA that is used to export a series of reports as snapshots, and then they are converted and rolled up into a single PDF document. The code works fine in the development version of the DB but when I tested the function in an MDE for 2000, I get an error message about halfway...

Oh I got it: IGNORE_DUP_KEY ON If anyone else stumbles across it!

Hi, I am new-ish to SQL server (2005) and I would like to do something that I did fairly regularly in Access but I can't seem to figure out in SQL - use a Primary Key (or index) to reject certain data being inserted into a table. With Access, if I had 100 records and a few, say 20 would break...

Hi, Please accept my apologies for posting this a second time but despite some pretty good help from JPaulo in the original post (here) a couple of weeks ago - I didn't manage to get the issue resolved. I really need to get the Novell Netware File Owner property because the way our network is...

No Probs... thanks for your help. Anyone else done this before? Cheers, Tom

Thanks for your help JPaulo but that code looks like it is more concerned with Network Connections rather than file properties. Let me elaborate a little... Take a word doc on our network as an example. The Windows properties show the file owner as "S-1-1-0" (The same as every other file in the...

Hi, I really need to get the Novell Netware File Owner property because the way our network is set-up is that the windows file owner always says "Admin" or "Everyone" (which isn't very helpful!). I've searched everywhere online and although there are a few mentions of the Netware APIs for VBA...

If you go to tools->options->view and check system objects then you will be able to view the system tables which contain all the objects. You should be able to pick up identifiers for each object type and build the queries/code you need from there. HTH, Tom

Thanks Lagbolt, I have done that before but I thought there were some issues around repeatedly opening the Access.exe? I could potentially be opening it up to 500 times a day. If there are no issues around that then it is the simplest way. I think i'm suffering from a classic Access...

Hi, I have an Access DB which is essentially a form with a timer event which runs code every few minutes to get data in "near" real time from a web service. It then processes the data a bit and feeds it into SQL server tables before waiting for the next timer event. It all works fine but it's...

Hi All, Here is the URL for a dev guide for the groupwise module you are using. http://developer.novell.com/wiki/index.php/Image:GWDevGuide.pdf I found it really helpful and enabled me to get a lot of extra functionality out of the module. It includes logging in to different accounts (just...

Sure, PM me with your e-mail and i'll send it on....

Hi, I have a database that uses the date picker control from MSCOMCTL2.ocx The problem is that in earlier versions I used a calendar control and not everyone has the OCX on their machine. I put the file in a self extracting zip file which unzips the OCX to their system32 directory and...

Hi, I recently bought the book "MS Access Projects with MS SQL Server" by Ralf Albrecht + Natascha Nicol (Microsoft Press) because it was recommended to me by a couple of people on the forum. It was a bit pricey to buy new so I got it 2nd hand but unfortunately the CD isn't inside! I don't...

Rabbie: Yeah each user has a copy of the FE. Gemma: If it only happens once in a while it's not so bad. I guess the error is generated at runtime so I could probably trap it and automatically replace the corrupt FE. I'm using an auto-update function to roll out new versions anyway so this...

Hi, I have a split FE/BE system running on a network and I am having a few issues with the FE's corrupting... Occasionally a user will call up saying they can't get in and when I go, I get the "microsoft jet database engine could not find object MsysDB" error message which basically means...

I am just about to release phase one of a DB and am trying to figure out a way to digitally sign the project? I managed to sign the development version on my machine but after reading about the self-certification process I realised it's not going to work on other machines. As I will be...

Another slight variation would be to do this with the first condition of conditional formatting. You can also copy this with the format painter. If you format the first one you can double click the painter and then just click on all controls you want to apply the format to. HTH Tom

Hi - I hope this question isn't quite as noobie as it might at first appear! I have to store a TimeStamp value which is used to determine the chronological order of records. If this was a date field no problem but I actually have to decode it from an XML Base64Binary field and it comes out like...

You can do this with VBA because when Access creates a report it goes through the entire report source so you could append each heading and it's page number (on the heading format event) to a Temporary table and then print a single page report based on that table before the main body of the...