Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PeterMAS

    Would U.S. tech. staff accept low salaries for an adventure in an exotic locale?

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

    Would U.S. tech. staff accept low salaries for an adventure in an exotic locale?

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

    Problem with SelStart when inserting character into text box by clicking a button

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

    Tab control doesn't display when there are no records on the subforms on the tab control

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

    Tab control doesn't display when there are no records on the subforms on the tab control

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

    How do I link tables..(or whatever it is called that I need to do)?

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

    Looking for general advice on Access DB design with mixed language families

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

    Problem discarding an (almost) duplicate row from a query because of ORDER BY clause.

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

    Problem discarding an (almost) duplicate row from a query because of ORDER BY clause.

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

    Problem with Duane Hookom's Concatenate function in a textbox on a sub

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

    Syntax error in SQL

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

    Syntax error in SQL

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

    Syntax error in SQL

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

    Problem with Duane Hookom's Concatenate function on [Forms]![frmRec]!...

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

    Problem with Duane Hookom's Concatenate function on [Forms]![frmRec]!...

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

    Remove Windows Theme from forms but retain Windows command buttons

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

    Problem with Duane Hookom's Concatenate function in a textbox on a sub

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

    Problem with Duane Hookom's Concatenate function in a textbox on a sub

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

Part and Inventory Search

Back
Top