Search results for query: *

Thanks Andy The db is in two Access dbs to be ported to SQLServer and output the webpages from there. And then jigged for output to various media (phones, tablets) although much of this is already catered for in the db. Graphic design skills would be useful but that's not a top priority. The...

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

Thanks PHV, but the Allow Additions Property is already set to True. I moved an unlinked subform that contained data from the header to the tab control and got an "Invalid reference to Form" error message which confirms the tab control isn't loading. I removed some restrictions on the main form...

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

Here's a REAL simple db that does what you want. Click on the two vehicles to see the parts. I entered the data straight into the tables--a no-no. You will need to add a form (or add combos to the existing form) to add vehicles and mark parts as available or sold. This isn't completely...

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

Thank you Golom. I would never have been able to do this. It worked like a charm. I didn't use it as code, I pasted it into SQL design view and it worked (the design grid reinterpreted your code). An explanation in case it's useful to someone else: These are part of a series of queries. There...

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

Thanks Andy. This was months ago, but I will reply to your post just in case someone encounters the same error. I never allow nulls in Primary key fields but the original SQL worked perfectly until I moved it from the main form to a subform. I suspect the main form record set hadn't loaded and...

I found the problem. I need to check for a null with an Nz probably because the code is on the On Current event of a subform and the main form hasn't opened when the subform loads. I haven't previously struck this type of problem with queries using the Forms!frmMain!... type of reference so I...

Thanks for the suggestion, but it didn't help. I previously had the quotes, but removed them when searching online for a solution. I saw a post on another forum that said they are not required when the field (RecID) is numeric.

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

Thank you Duane. Setting the data type of the parameter in the first query didn't work. So I took your second suggestion. This thread had several suggestions: Changing Query Criteria via Code I wrote a new query, qcnDhm, with no WHERE clause and then modified it with the following code and...

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

Magic Duane. Obviously the Access fire brigade works all hours. I don't quite understand why the RecID would be null, but you got it. It works perfectly now. Thank you.

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