Search results for query: *

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...

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...

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...

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, 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'

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...

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...

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...