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

    Can't edit a form

    Thank you, Nancy2. Just what I needed, a place to look that was right there all the time. I wasn't getting any error message, just not able to edit. The funny thing is that the query looked as though it worked. The correct record was retrieved. I removed two fields from a non-related table and...
  2. oystercracker

    Can't edit a form

    It happened when I wan't looking but, before something got set, I could edit this form without trouble. Now, all its buttons work and it displays debug message boxes (on open & on activate) which say "AllowEdits = True". Which is a lie. Also no locks anywhere. The form in question...
  3. oystercracker

    Is it possible to make a list box selection with ENTER?

    Thanks for the info about using Alt key labelling. I didn't know you could do that in Access. But what I really was asking is how to use a user-invoked listbox event, other than Click/2click . The user may just be browsing through possible selections, so I want an event that means the user...
  4. oystercracker

    Is it possible to make a list box selection with ENTER?

    I would like for the user not to use the mouse to click a selection from a list box. Uing the down arrow gets to the selection but then I can't see how to activate it nicely without leaving the keyboard. Ideally using the ENTER key would work just fine. Any ideas would be greatly appreciated.
  5. oystercracker

    Can't get to database form

    I wish it were References. Discovery of that Access trap for the uninitiated happened a while ago. Everythings been working with (in order): VB for App,MSAccess 9.0,MS DAO 3.6,OLE Automation, MS VB for Apps Ext 5.3,MS Scripting Runtime. Now everything works except for this one main form and that...
  6. oystercracker

    Can't get to database form

    I seem to have broken a form that was working quite well until I started working on a list box index. When I try to click it on in both design and open nothing happens. The documenter message is "Application-defined or object-defined error. Is there any way to recover any of the 3days of...
  7. oystercracker

    Report snapshot was not created - not enough disk space

    OK. Dumb. I thought Access would use file name the report name as a file name. Sometimes I get tripped up by doing what Access does by itself! Just learn it, I guess.
  8. oystercracker

    Report snapshot was not created - not enough disk space

    DoCmd.OutputTo acOutputReport,"rptPending","d:\Archive" produces a runtime error 2024: The report snapshot was not created because you don't have enough free disk space for temporary work files. The report is very small and available disk space is at least 10Gigs. TIA for...
  9. oystercracker

    On form, display data not in form source

    The table containing the data I want to display is not related in any way to the form source. I only want to display the data not use it. Thanks, kd
  10. oystercracker

    On form, display data not in form source

    I would like to display on a form, general info, such as "meeting date" from a table not associated with the form. I think it might be done using a label to display the date as text, but I have no idea how to do it. Any help would be wonderful. Thanks, kd.
  11. oystercracker

    Null date causes #Error

    Trying to evaluate or assign Null to a non-variant data type causes an #Error MS knowledge base tells me. Changing the Date type to Variant in the function parameters did the trick. Thanks.
  12. oystercracker

    Null date causes #Error

    I wrote a very simple Date function with one date parameter. It is supposed to return 1/1/1999 if the parameter date is Null, else 1/1/2000. A record with a null parameter date returns #Error, while all other records return 1/1/2000 correctly. Changing the Null date in the record does eliminate...
  13. oystercracker

    Null date causes #Error

    I wrote a very simple Date function with one date parameter. It is supposed to return 1/1/1999 if the parameter date is Null, else 1/1/2000. A record with a null parameter date returns #Error, while all other records return 1/1/2000 correctly. Changing the Null date in the record does eliminate...

Part and Inventory Search

Back
Top