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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.