Search results

Hi All, I have just added a function to a database to strip out any commas or quotation marks from a passed string. However, it is returning a black string even though when I step through the function it creates the out string correctly and the variable "OutString" is populated when the...

Hi All, Have had a database which I developed in 2007 and has been running for several years on Office 2003 and 2007 without issue. Although most of the navigation in the DB is done though pages and buttons on Page has a switchboard form as a subform. However, one of my clients have...

Hi All, I have a form which is based on a query which selects information from three different tables. All fields apart from one are locked, all are enabled. The table the field I wish to update is native to the current DB i.e. is not a linked table. when I activate the form and try to...

I have got a Access 2007 format data base which I have been looking after for over a year now. I have just made a change to one of the forms by adding a button (by copying the only other button on the form) to cancel any changes and close the form. However, as soon as I added it I started...

Hello, I am trying to create a query in VBA to extract data for a report. I am using the "Like" operator for one of the variable fields. It works correctly if you use the full value, however when using a wildcard it returns no records. Example below. MOP - Works returning several records. M*...

I have a form that shows continus details based on several queries depending which buttons you have clicked. I have identified which query is in use and have got its sql code by using:- stsql = qr.SQL where qr is defind as "QueryDef" and stsql is defind as String when I try and use this...

Does anyone know if there is an equivelant on a form with "Continuous Forms" as the "Detail_Format" on Reports. I have a Form which contains a sub form. The Main form is a "Single Form" and the sub form is a "Continuous Forms". On this sub form I wish to high light the details on a specific...

Hi Guys, I have a database which is linking to Ms Outlook for Email messages and Appointments. However, it needs to run on client machines which are running versions 2003, 2007 and 2010 of Office. currently I am manually maintaining 3 versions each with the relevent referances checked...

Hi Guys, I am a certified MS Access Specailist and have several databases out in charitable sector helping orgs help there clients. I am constantly trying to improve them by implementing new functionality. I am based in the UK and have about 7 years experiance of building Access databases...