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

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

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

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

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

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

How can you have two fields with multiple data linked to each other? If I have two fields: skills and classes. I want to be able to list all the classes that fall under a certain skill as well as match all the skills that fall under a certain class. How is the best way to link these two...

I've read the FAQ on Enabling/Disabling the Shift Key on Startup. However, it was written for Access 97 and I'm using Access 2000. I get an error that the "User-defined type is undefined". Can't Dim As Database. Public Sub EnableByPassKeyProperty() Dim db As Database Set db =...

I have a database on a network drive, and for some reason, can't seem to have more than one user at a time. Never had this problem before on other databases. Is this a setting error? Please help! PJ

Passing Environ("Username") value to a query-based form I originally had several forms and reports based on the same query which asked you to input your name. What I'd like to do is use the Environ("Username") function to determine who the person is and then set the query...

Linking Multiple Word Documents on a Single Form in Access Scenario: 1. A user clicks on a button that opens a clean Word document (actually a hyperlink to a default word file previously saved). I want to be able to have Access save the information typed into the Word document automatically...

DLookUp Not Populating Field - Why ? I have a form ("Task Info") that populates all the fields in one of my tables. However, one of these fields is optional ("Personnel ID"). However, if the user selects a person, then I want this bit of code to retrieve that person's...

Form doesn't save data when a certain field is left blank - help! Scenario: I have 2 tables. One has personnel information. Another has taskings information. The two tables are connect by a personnel field and an organization field. I created a form from a query with a mixture of fields...

Linking Multiple Word Documents on a Single Form in Access Scenario: 1. A user clicks on a button that opens a clean Word document (actually a hyperlink to a default word file previously saved). I want to be able to have Access save the information typed into the Word document automatically...

Automatically Sending Outlook Email By Clicking A Button in an Access 2000 Scenario: Trying to have a button send an email using some information from a form, some information as part of the code. Here is what I have so far. Can't seem to get it to work. Private Sub CmdSend_Click() Dim...

How do you call a module by clicking a button on a form in MS Access 2000? Scenario: Form is used to add a suspense to a master list. Person would then click a button that would automatically email a person to tell them they have a new suspense. The form would have already have some of the...