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!

  • 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: Mayhem9
  • Content: Threads
  • Order by date
  1. Mayhem9

    Yes/No checkbox showing as -1/0 once filter is applied.

    I have a form based filter that that will show "Yes" or "No" for a checkbox but this changes to "-1" or "0" once any on the combo boxes used to set the filters are used. On initial loading: Once the manufacturer is selected (same with any field selected): The filter was created by MajP for...
  2. Mayhem9

    Having trouble searching by date (dd/mm/yy) in a custom filter form

    Some years ago MajP was kind enough to let me use a very nice filter in a database I was putting together. I've since adapted this database to serve a hobby of mine and have added a couple of new search parameters. However, I cannot get one of these to work. The field in question is a date...
  3. Mayhem9

    ? Compatibility issues with Access database and 64 bit systems

    Hello, I received a lot of help here in the past with a tool log database, which was built and working well in Access 2003 (and still is). I have since shared it with some retired folk on a machining forum, so their wives have a record of what their tools and equipment is worth, should they...
  4. Mayhem9

    Revisiting an old thread - advanced search feature

    thread702-1584791 Well I knew it had been a while since I had been here, so I wasn't surprised to see the post cosed. Health issues have kept me from developing this as I had hoped. I encountered an error with the subCategory field in the filter initially but I had figured this may have been...
  5. Mayhem9

    One combo box to control another

    Essentially I would like to use my current tool type combo box to control the options available in a second combo box, which will then contain sub types (I do not have this yet). Currently, I have a tool log table, which is populated by my main form. There are several combo boxes, that...
  6. Mayhem9

    Locking tool bars in Access 2003?

    Hello, It has been some time since I have been online due to an accident in my workshop. An apprentice failed to check a vehicle was in neutral before winding over the engine and jumping it off the ramps with me underneath it. Long recovery but could have been much worse. I am just getting...
  7. Mayhem9

    Not enought memory error when opening a form

    Hello, I have been working on a form and now I am getting a "There isn't enough memory to perform this operation..." error. I am running 4GB of RAM and have no other programs running and have closed down all the sleepers in the system tray. Task manager shows 3% memory use. Opening other...
  8. Mayhem9

    Opening another form using double click in a combo box

    I have a form with a number of look-up combo boxes and I was using the following code the open a form that enters the data into the field that the look-up is referencing by double clicking on the combo box. Additionally, if you typed in an entry that wasn’t there you received an error message...
  9. Mayhem9

    Opening a Windows Explorer Window and capturing the file name

    Hello, I am hoping someone might be able to help me with the code posted in this thread: thread702-1289131 There are a couple of comments calling for the ANSI version of the function if NT is not used. I am using XP and Vista machines. The second issue I have is that I am not sure that I...
  10. Mayhem9

    Options for data entry?

    Hmmm - not exactly sure how best to describe this: In another post, I sought help on displaying an image in a form, using the picture name in the table. I have this working well now and I am unsure of the ways in which I can enter the image name, other than putting the textbox into the form...
  11. Mayhem9

    Main window is hiding and I cannot drag it back onto the screen

    Ok – it seems that as soon as I have a win in Access, it strikes back at me! The main window (the one in which you create/edit tables, forms etc) is now partly obscured by the menu bars and the title bar is not accessible, so I cannot simply drag it back into view! I have tried hiding the menu...
  12. Mayhem9

    Excluding a text box and setting the cursor position in a form

    Hello, I apologize for asking such basic questions. I have not been able to find a solution. Perhaps it is a matter of terminology. I have 2 questions: 1.) Is it possible to exclude a textbox from being written to and remove it from the tab (so that you don't go there at all). 2.) When...
  13. Mayhem9

    Two events in one Current

    Hello, As you can see by the title, I'm not really sure of the terminology (sorry) - but I am willing to learn! I have tried the code in the FAQ on custom navigation (faq702-4655) to create my own record x of y counter but it keeps returning the following error: The expression On Current you...
  14. Mayhem9

    Using Me![ImageFrame].Picture = Me![ImagePath]

    Hello - I was reading the (closed) thread702-289543 in an attempt to solve a problem I have. I am building a database to log my tools and I wanted to include a photo of each item. I added the field "ImagePath" into the table and placed an image into the form, named "ImageFrame". The following...

Part and Inventory Search

Back
Top