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 Chriss Miller 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: *

  • Users: adamstuff
  • Content: Threads
  • Order by date
  1. adamstuff

    Changing items in Data Validation List via ListBox

    I still can't understand why the simplest things are the hardest for me to find. I can find things like list inversion, sorting, Martian characters, ad nauseum, but not anything about how to change the list used to populate a listbox. I have gone through tutorials and tips and found nothing...
  2. adamstuff

    Trying to display time on userform textbox

    Hi all, I have a text box on a userform that I’m trying to use for both display of a cell from the sheet and as an input back to the cell. The problem is that the cell formatted as Time (13:30). I’ve tried different formats with same results. The textbox displays the TimeSerial instead of the...
  3. adamstuff

    Record filtering with Option goup

    Hi all, I've got a form with an Option group and simple selection: Select Case fraEEPicks.Value Case 0 MsgBox "Please select a reporting form." Case 1 DoCmd.OpenForm "Claims Analyst" Case 2 DoCmd.OpenForm "Provider File Analyst" Case 3...
  4. adamstuff

    How to Multiple forms with same subform

    Hi all, I'm sure this is a newbie question, but I can't find an answer no matter where I look . I have several forms and I'd like to put the same exact subform (copy) on each of them. When I try to copy and paste the subform, the subform on the original form becomes a blank space holder. I...
  5. adamstuff

    How to remove Main Menu to look like an App?

    Hi all, The subject says it all. This may be a very simple question, but so am I. Are all Access databases designed to run in the main Access Window? Is there no way to make a database look "professional", instead of something written in another program? This may be trivial to most of...
  6. adamstuff

    Subform won't display input, only zeroes

    Hi all, I've got a subform on a form. This subform is identical in every way that I can think of to another subform that works, but when I try to enter data, the textbox reverts to a zero. The other subform in the other form works just fine. I've looked at the properties of the form and...
  7. adamstuff

    Getting 2 records on one click

    Hi Folks, I have a form bound to Table1 and a subform in it bound to Table3. When I click on the SUBMIT button, I get 2 records added in Table1 and 1 record in Table3. Table3 data seems OK. In Table1 the first record created has all the data fields filled, but not the name, date and...
  8. adamstuff

    Getting "microsoft office access feature"

    Hi folks, Things were going reasonably well, until some of my users starting bumping into this error. When they open a database, they get a thermometer window that says Installing: Microsoft Office Access Feature. They never saw that before. The program seems to open OK, but click on any...
  9. adamstuff

    Tabbing creates multiple records

    I can't believe how helpful you folks are and how dumb I can be. I have a subform, bound to a table, with data entry property set to yes, because I want blank fields to start. There is no record recall/display, only data entry. The subform has 6 fields. When I tab from one field to another...
  10. adamstuff

    Get data into table in subform

    Hi folks, You've all been wondeful in helping me and now I have another newbie type question. I have 2 tables that I have related thru the ID field. When I put the data in my form and subform, the ID is not saved into the new record of the second table. It is in the new record on the first...
  11. adamstuff

    When to create new record

    Hi, I've got a couple of forms that are used for data Entry only. When a user enters the form, he is presented with blank fields. After filling the form, the user presses SUBMIT, the new record is written and the user is taken to a menu. My question is if the user presses CANCEL and he is taken...
  12. adamstuff

    How to handle blank boxes on form

    I've got a form with bound and unbound controls, text and numeric. What I'd like to do is have my user come in and see all blank boxes. If he fills the boxes (only 2 required out of 20) then hits CONTINUE command button, I want that saved as a new record. I think listing all the boxes and a...
  13. adamstuff

    2 Programmers, 1 MDB. Possible?

    Hi all, I think the subject says it. I have two people working on one MDB, sometimes at the same time. We've already lost some time becase of miscommunication. Is there a way to allow them to work on it at the same time (shared, as in excel)or some way to lock the other one out when one is...
  14. adamstuff

    MDB acts like it's read-only

    Hi all, I just got done messing around with my mdb and tried to save it. Of course I got the backup question and I put the file on my Thumb drive. Then I saved it again with the regular file name. I copied the file to the server. Now not one of these files will let me do anything. Right clicking...
  15. adamstuff

    Nonexistent Form Message

    Whenever I start my MDB named "Claims Prod", with a title of "Analyst Input" I get a pop-up message that says: The form name "Analyst Input 1" is mispelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and...
  16. adamstuff

    Startup/switchboard programming

    Hi, I'm trying to create a very "mild" security startup form. The form consists only of Username and Password fields, with Submit and Exit command buttons. What I'm trying to do is have the Username be the first initial & last name of a user, and the password to be the last 6 digits of a...

Part and Inventory Search

Back
Top