Search results for query: *

Cheers Geoff for that, I hope my situation turns out as well as yours! Thanks again Muppet

Thanks Lupin. I am in the UK and was the supplier so think that this stands me in reasonable grounds. Though I think it does need a more specific answer in terms of actual legalities so will chase this up. Thanks again Muppet

Hi I have put together a small but complex database for a client (they paid fine even though there was no contract; basically it was for a friend who has since moved on from this company). I have been told that they intend to sell this software on to another company, can they do this? There must...

good idea Knicks, hmm now I'm thinking I should really have thought of that one! Thanks for the help Knicks

Hi I have a sub-form that captures a brief overview of recent telephone conversations. I have ordered it so that recent is shown first as per: Private Sub Form_Current() Me.OrderByOn = True Me.OrderBy = "MailingID DESC" End Sub My problem is now I can no longer add a record as it reports that...

Thanks PHV, I think I had the INSERT/CREATE mis-understood. many thanks Mup'

Hi All, Any idea why the following doesn't work? it takes the contents of an unbound txt box and 'should' place it into the address5 field. Any help greatly appreciated. Private Sub countryabb_AfterUpdate() Dim strText As String strText = Me.countryabb DoCmd.RunSQL "INSERT INTO Tbl_CusDetails...

Lawrence that worked a treat, thanks very much for your help. Mup'

Thanks very much Lawrence I shall give it a try straight away. cheers Mup'

Hi All, I have a subform which captures brief conversations with a supplier. It would be helpful if the most recent conversation was visable first instead of the very first conversation created (i.e. record number 1) being displayed which then requires me to press the record navigation button...

Hi PCLewis Thanks for your info'. I am trying to get one name [Decision Maker Surname] that meets the criteria from tbl_Stage_2_Status. So the result can eventually used for a mail merge. Would it be best if I created a DISTINCT query first on [Decision Maker Surname] and then ran another...

HI, I have the following SQL query statement that I need to attach a distinct value onto one of the fields i.e.[Tbl_Decision Maker].[Decision Maker Surname] but cannot seem to get it right. Any help would be GREATFULLY received. SELECT Tbl_CusDetails.[Company Name], [Tbl_Decision...

Hi, Is it possible to prevent data entry by for example using the autonumber field and when it reaches a given maximum number further entries would not be possible? TIA Mup'

Classic problem. I did some work for a friend of a friend and did not set up a contract. Now upon completion they are not paying, is there any way I can get them to?

Hi, I want to set a 30 day trial limit on a db thats being currently used. Can a autoexec macro still run in the BE once a FE is opened and obviously makes a link to the BE? The BE autoexec calls a module to only allow it to be opened during a 30 trial period. Any idea's? If this doesn't work...

Thanks PHV for your reply, would this slow the form load up? There will be probably 3-4 thousand entries over the next few months.

Hi, I have implemented a small DB which has 4 users. My problem is that 2 users have duplicated a record. The PK is an autonumber. Is there a way of having some sort of autocomplete in a field (in this case the customer name) that would give a way of detailing previous entries of same text...

Thanks Ken I will experiment

Hi Is there a way of carrying out a mail merge function within Access? I have a DB with 4 tables 'stage1 thru to 4' Stage 1 is the contact details including address etc, stage 2,3 are questions and stage 4 is an appointment setting stage. Is there a way to create a mail merge using the data...