Search results for query: *

Gentlemen thank you all for you help. I think I've got it nailed using fields and fillins. Still have a bit to learn with regards dropdown and check boxes but thats all part of the fun now I've managed to clear some time in my diary. Eman2005 thank you for a solution I completely overlooked and...

Sorry I havn't replied and thanked you for your help. Are there any websites that anyone knows of where I could find an example of the above in action ? Thank you Paul

Hello. I have recently been asked to create a template in Word 2002. The problem is that the users would like the template to prompt them to fill in a set of fields upon opening. I remember a long time ago doing this in Word 97 but cannot for the life of me remember how to do this. If anyone...

Hello I'm a programmer pretty new to Citrix and have been asked to create a routine that updates a setting in the users pn.ini file. The setting is "PNCacheRefresh=Off" which I am changing to "On". I have manged to achieve this only to find that when a user next runs pn.exe...

No you are able to set the reports printer on the fly so to speak. I use access security to see which user it is and then set the printer for the report based on this information e.g JBloggs = CanonPrinter

I do this exact same thing but use the Access Security logon name to identify which usrs they are and to set there default printer when printing a report. Its a bit a pain to set up but once done it works like a charm. Paul

There are many ways but the easiest is to use the Nz function.

I have been using the above method and it works like a dream. Paul

Sorted I have just noticed that I am the owner of every object in the database but am not down as the owner of the database itself.

Sorry I didn't make myself more clear it is the access 97 database I am trying to convert and which gives me the message after the login prompt.

I have an access 97 database that I am attempting to convert to AccessXP. The 97 database has its own MDW file that I thought I had full admin privileges to. If you look at the objects within the database I appear to be the owner of all of them and have the necessary rights to: Open/Run...

I have been asked because of the new lisencing requirements to find out if it is possible to use VB6 to ascertain who is currently logged into an SQL 2000 database. Any help or nudge in the right direction would be greatly appreciated. Paul

I am quite new to SQL Server programming but have been asked because of licensing issues to find out whether it is possible to see who is currently logged into the database. Paul

My apologies I am talking rubbish its a feature of Jet4.0 not access 2000

If you are using Access 2000 and above you are able to set the starting point and set the incremnatal value in the table.

This is a bit long winded but is the easiest way I have of returning random records from a table. - Create an exact copy of your existing table minus the data. - From this new table remove any auto number field and create a new autonumber field and set its New Values property to 'Randomise'...

Hi I use this in a database I manage.I create in the basDeclarations module enough Global Variables to hold the information needed to be audited. I then use this code behind the after update event of each field I wish to audit. glbFieldName = "Name of Field" glbPreRecord =...

Yeah I've tried but I can't seem to find anything on the mechanics of creating the number.

I have an application that uses this feature to return random records from a table. However I have been asked to explain the randomisation process that Access uses to generate this number and can't find any reference to this anywhere. I was hoping that some kind soul out there may know. Any help...

Is it possible to have an option to Select All the items in a list box. Iknow this can be done in VB but the list box in Access(XP)does not seem to support this function. Many thanks in advance Paul