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!

Register Log in
  • Congratulations Rhinorhino 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. StarScream

    Appending to New Record, Not to Same Record

    I have a simple log form with a bounded text box and an unbounded text box. The user enters text into the unbounded box and when presses a button/exits field, the information is added to the bounded box. While this works -- I was surprised to find that the info is all in one field(record) and...
  2. StarScream

    Tab Stop=yes Causes Skip To Next Record - Weird?!

    PHV, Thanks! I just saw that I needed to change the focus and then set it back -- but now that prevents me from clicking on the Bounded Text Box. Instead I'm trying a button -- so when a person types something in the unbound box, they press a "submit" button and it does everything. Works for...
  3. StarScream

    Tab Stop=yes Causes Skip To Next Record - Weird?!

    I have a Unbound Text Box on a form that a user can type in a message and when they hit enter, the message is transferred to a Bound Text Box that adds Date/Time/User stamp and displays the whole thing. However, every time I input text twice (basically hit enter twice), it automatically jumps...
  4. StarScream

    How to: Subform updates Mainform on Enter

    Trying to create an Events Log in MS Access. I want to have a subform where a person writes in the memofield and when they hit the ENTER key, it clears out the subform and shows it as a running log in the mainform. I tried using a continous form view, but that doesn't achieve the look I want...
  5. StarScream

    Printing a certificate

    A10Instructor (sounds like you might be in AETC -- [thumbsup2]) I've done something like this before. All you have to do is create a report that looks like the certificate you want. You'll create a box for the fields that change based off your table/form field names. When you run the report...
  6. StarScream

    How can a Query return a Count of 0?

    Golom, boriska40, I understand your logic, but what are the "A."s, "B."s, "J."s ? Also, where do I put the SELECT statements? Instead of using DesignView I should use the SQL view, right? My overall goal is this report which uses the query information. I...
  7. StarScream

    How can a Query return a Count of 0?

    In a query (design view), I want to count how many times a specific field equals "Teacher" in a table. If there are no records with "Teacher", I want it to return a 0. TABLE [Country] [Name] [Job] Canada John Teacher Canada Pete Plumber...
  8. StarScream

    Summing Nulls Problem

    The SQL part is the part I am missing. TABLE Canada John President Canada Steve Driver Canada Pete Ambassador Belgium Dana President Belgium Paula Vice President Germany Hans Secretary of State If I set up the following query: QUERY Country Name...
  9. StarScream

    Summing Nulls Problem

    Hypothetical: You are having an international party. In MS Access you have a table with a list of each person, the country their from, and their jobtitle (Ambassador, President, Minister, Driver, etc). If you query a list of countries who are bringing their Ambassador by setting...
  10. StarScream

    Combo Box Selection Goes To Specific Frame

    Thanks Olds, I'll try that. You would be surprised how long it took me to figure out there were two more scenes. I had thought you made an MC out of it and was trying to get it to open... :-) I assume I can use variable names within the Data area so as to get the info from a database? PJ
  11. StarScream

    Combo Box Selection Goes To Specific Frame

    Combo Box Selection Goes To Specific Frame I have a combo box that I want to populate from a database so the options can be modified through the database. Based upon the selection, the flash movie would jump to a different frame either by frame number or labeled frame. I've seen Oldnewbie's...
  12. StarScream

    Open Connection Error with a SELECT INNERJOIN

    Thanks Simple, it was...er...simple ;-) once you pointed out the reason. Thanks. You get a star! PJP
  13. StarScream

    Stumped By The Easiest Things

    Thank Rudy for confirmation! But I get a "syntax error in the FROM clause" or a "Join expression is not supported" error. Can't seem to shake it. I can't imagine that such a simple and common thing can cause such a big problem. Does anyone have an example that does...
  14. StarScream

    Stumped By The Easiest Things

    Okay, neither idea worked. Too be honest, right now I don't even know if its the SELECT statement thats wrong or the rest of the ASP script. Anyone else have any suggestions? PJP
  15. StarScream

    Stumped By The Easiest Things

    That's a great idea! I'm gonna go check them both out. I'll let you know shortly! PJP
  16. StarScream

    Stumped By The Easiest Things

    Hey RiverGuy, Yeah I tried that when I realized it. But the error is still present: "Join expression not supported." Makes me think the error is in the SELECT statement, and not the rest of the code. Any thoughts? PJP
  17. StarScream

    Open Connection Error with a SELECT INNERJOIN

    Oops! I made INNER JOIN two words, then it says "Join Expression Not Supported" I'm missing something obvious, ain't I? PJP
  18. StarScream

    Stumped By The Easiest Things

    Help, For some reason I can't get this to work. I've written several completed DBs and am working on a new project. Had it all working fine until I tried to write an ASP page using this query. Any thoughts on what I'm doing wrong? Thanks. SELECT PersonnelName FROM PersonnelTable INNERJOIN...
  19. StarScream

    Open Connection Error with a SELECT INNERJOIN

    Syntax Error In FROM Clause I am trying to get this ASP to output info from a specific record. I input the name of the system "Microsoft" which correlates to a single record which has 4 people on it. Each person does a different job. The person I want is SysPersID. But this would...
  20. StarScream

    How can you have two fields with multiple data linked to each other?

    Okay, I understood that. But still am lost about what fields to have in which tables. Here's my example: Students (Table) StudentID (Primary Key) First Name (Field) Last Name (Field) Major (Field) Classes (Field) <-- Do I have this in this table? Classes (Table) ClassID (Primary Key) Class...

Part and Inventory Search

Back
Top