Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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