Search results for query: *

Background: I have devised and built a database and software that enables the launching and maintenance of voluminous information websites (in 14 languages) that tap a massive, lucrative market. I've had offers of funding but investors want to see a team. Lack of capital has subjected me to a...

I designed a keyboard on a sub form to insert letters with diacritics in a text box at the cursor. The following code works OK if I don't use my computer keyboard (that's a big if). At that point, it will only add text after the last character in the text box. Here is the code on a button to...

Windows 7, Access 2013 Preview My db is very normalized so all data on my main form is on sub forms. To prevent accidental creation of new records and speed up form loading, all the subform queries are restricted to the current records and therefore don't contain a new record (I create new...

Access 2013 (maybe migrating to SQL Server)/Windows 7 home premium I've designed an Access db with some of my tables containing text in various European languages. If the relationship is 1 to 1 between languages (English text/German equivalent/French equivalent/etc.), I have put the text...

Access 2013, Windows 7 I am using expressions and Duane Hookom's concatenate function in SQL queries to convert database fields into readable text. My problem is I can't use SELECT DISTINCT to discard a duplicate row because of the distinct field required for the ORDER BY clause. Queries B & C...

I am assembling fields into text using expressions. The following code produces the error message: 3075 Syntax error (missing operator)in query expression '[tblEpr].[SsnID]=0 AND [tblEpr].[RecID]= & [Forms]![frmRec]![RecID] &'. The message occurs on the final line of code below: Dim strSQL As...

I am concatenating Opening & closing times by Day of the week by Season into a text string using Duane Hookom's function: How to concatenate multiple child records into a single value http://www.tek-tips.com/faqs.cfm?fid=4233 The requirements are rather complex so I need 5 queries to manipulate...

Access 2003, XP Pro I have always brightened up the boring Access tab page control by putting a box with a back color over each page. I just discovered another way: Click Tools / Options / Forms/Reports Then uncheck: Use Windows Themed Controls on Forms. Apply a back color to Detail. Make the...

Access 2003, XP I used Duane Hookom's Concatenate function to list a single field from a table in a text box on my main form and it works perfectly. FAQ701-4233 I decided to put it on a subform and it seemed to work, but when I moved the main form to another record, the text box didn't update...