Search results for query: *

Hi I have an .mdb database created in Access 2000. The backend is on a networked server and we have customized frontends. Users are currently using Access 2003 but I am about to start using Access 2010 (new computer) and the main other user will remain with 2003 for the time being. There...

I'm trying to list an array and where the date field is less than 10 days ago, flag the record as "new". Can anyone tell me why this isn't working? <? $query = "SELECT date, name FROM tbl_onepagers WHERE fktheme = $id OR fktheme2 = $id OR fktheme3 = $id OR fktheme4 = $id OR fktheme5 = $id OR...

I have a query which produces a list of products and prices (four price fields for different versions of the same product). Prices are type DECIMAL field. Where there is no known price it has the value 0. When printing to the page I would like to replace these 0 values as "<a...

I created a small database which is on our internal server, in Access 2000. A colleague has Access 2007 with Vista OS and at first couldn't get into the database at all. I made her her own front end by using the original forms, importing the queries, modules, macros, etc and linking to the...

I have a command button that produces a text file, one string per record combining many fields. Here is the problem part of the code: If Not IsNull(rsHBData.Fields("Address")) Then strAddress = rsHBData.Fields("Address") strAddress = StripLineBreaks(strAddress, ", "...

I have qryHistory which joins two tables: tblMembers and tblHistory; the relationship between the tables is one to many as each member can have more than one item of history. SELECT DISTINCTROW tblHistory.HistoryID, tblMembers.MemberID, tblHistory.MemberID, [Title] & " " & [Initials] & " " &...

Hi I am working in English language Access but I need to produce a report in Spanish language. I am trying to find a way to represent date fields in the following format: dd-mmmm-yyyy. I've tried extracting the month and using an iif expression to convert it but can't get it to work. I think...

Seasons greetings! I want to create a single field in a form (that can copy and paste into Word) with the following format: FCD-DID-07-001 Purpose is to generate unique references for letters. The 07 is the year in yy format and the 001 needs to increment by one for each new record. This...

I'm drawing up an accessibility policy for our soon-to-be-relaunched web site. As a scientific organization we will probably be putting a lot of pdfs on the site and I'm researching how accessible they are. Acrobat Reader has a facility to read pdf's in a simulated human voice. Files in English...

Access 2000. After doing an append query and stupidly including the autonumber id, I find that I can’t now add new records because it’s trying to use a duplicate autonumber. MS KnowledgeBase 257408 suggests updating the Jet ServicePack but I find I’m already uptodate. The db compacts...

Hi I have developed a front end/back end database and am now testing on user's PCs. Problem is, I'm working in Ecuador where they use the comma as a currency/decimal separator (as in $1.000,00 or 1234,75). So this is the Windows Regional Setting in most of my users' PCs. One of the database...

Hi guys I have a report based on a parameter query which prompts for DateVisit using a BETWEEN ... AND criterion. I would like to be able to show the parameters entered in the header of the report (which are not necessarily the first and last dates shown in the data) Here is the SQL SELECT...

Hi guys I have a form with two checkbox fields and a date field chkHonorary chkLife txtFullDate I would like to make the checkboxes functional only when the text box is not null. (this is in Access 2000 9.0.2720) I’ve tried the solution offered in thread702-909430 but it’s not working...

I have a single address field, with the data entry form property set to “New Line in Field”. I need to produce a report including this field in which the address stays on one line. Is there anything I can do, either in the report or in the underlying query, that will achieve this? Thanks

Hi I have a client who insists on the ID being a unique combination of letters and an incrementing number (I know this is a bad idea …) The string is: The person’s first initial, followed by the first two letters of their surname, followed by an autonumber which restarts for each combination...

My client wants a field that constructs an individual's full name from their [Surname], [Title] [FirstName] I can do that ok, but she also wants to be able to overwrite it, so that if the expression produces e.g. "Smith, Mr Robert" she can change it to "Smith, Mr Bob" Is this possible? Thanks