Search results

See my previous edited reply. Thanks again, Don

PNGBill, 1. I had this step done before I posted the thread and it works. The new records come up with "No" in the fields. 2. I ran a query looking for null fields and nothing showed up except for 1 record with the word No in it. As I said, I also tried "" and got the same results. I can't...

PNGBill, Thanks for the quick reply. Tried what you suggested but to no avail. I still have the same results.:eek: I even tried using IsNull and "" for criteria but no change??? Don:confused:

Hello again,:) Having another simple but frustrating problem and I can't come up with an answer. I have a table that has (along with others) 2 fields, "Response Sent" and "Response Received". When I print a report these 2 fields are often blank so I decided to default them to "No" so it would...

Galaxiom, Thanks for the additional tips.:) I wondered how to get those code boxes to appear on the screen. It also looks as though there is a command "#" at the top of this "Reply" screen that may do the same thing. I'll have to give it a try. I have a bunch of those "Open/Close" commands...

Galaxion, Thanks for the detailed description on the cure for my program ailments.:D I had a table that I used for saving miscellaneous data so I used that instead of creating a new one. I ended up using a little advice from everyone and now the program does as I wanted it to do. I have a...

Galaxiom, My start up form is nothing more than some label boxes with instructions written in them. Once they have been read they are no longer needed. I don't know how to bind a checkbox to a non data form.:confused: I came up with some code to do what I want but it is far to complex for...

Alan, That looks as though it will work if I can get the checkbox to stay checked between sessions. I have to find a solution to that problem now. Dave, I'm afraid you've gone one step above me with your solution. Although it still appears I'll need some type of checkbox (flag?) to contend...

Hello again,:) Simple question, I hope. I have a start up form that appears when the database is opened. The form has a checkbox to not show the form again on start up. I want a second form to become the start up form when the box is checked. I don't see an easy way to do that in the startup...

Nidge, It's like most other towns, it depends on which part you visit. It has its upsides and of course its low points. All in all it's more on the upside than the down. It has good restaurants, a casino, plenty of bar/restaurants on the southside of town, the two rivers merge point to form the...

I always appreciate any help I can get.:) Now you tell me I can't put code in those little boxes!!! ;) No wonder I had so much trouble getting things to work. HA! HA! I have 4 books here about Access and I get more info from the internet than I get out of those books. I think I'll sell them...

Hello again vbaInet, I have never had any luck putting code in the event boxes such as Got Focus. I always get an error that tells me Access can't find the macro named ....whatever I type into that event box. I've tried all different formats, parenthesis, etc. with no luck. What does work...

vbaInet, OK, let's go back to the beginning. What I was looking for was the following: A populated Listbox that could be scrolled through so the user could see all the information listed in the box. Also, if the user clicked on the Listbox, nothing happened. No highlights, no color changes...

vbaInet, I actually have 4 listboxes with different Back Colors on each one so using the grey color won't work in this case. I tried that code in my Listbox when I first received it from MStef and I didn't get it to work. I'll have to go back and try it again. Maybe yours is a liitle different...

Rut Roh, I spoke to soon!! Changing "Enabled" to False kills all actions in the listbox including the scroll feature so now I can't see anything more than what is in the box. It doesn't allow scrolling through the list from top to bottom. Oh well, I guess I'll go back to where I was and leave...

spikepl, Thanks for your input. That did the trick. No more highlights, no more dotted lines, just a dead screen with info on it. Case Closed! :D

John, As noted in my last post I tried that. It still highlighted the top data row of the listbox when the user clicked anywhere in the listbox. Today, just for the halibut, I tried the lock command again and a strange thing happened. No highlight on any of the rows in the listbox!!! However...

Thanks MStef for the reply and the sample code but that is not quite what I was looking for. I tried to apply some of the code you sent to my listbox but didn't have any luck getting it to do what I want. I tried the "lock" command but that still allows a row to be highlighted. What I would...

Hello again, I have a listbox that I would like to use as an information only box. Is there a way to turn off the selector/highlighter in the box when someone clicks on it?? I've searched through the forum but didn't find any answers. Found a lot of other goodies that I've bookmarked in my...

Hello Again, Just so no one wastes any more time on this problem, I found a cure for it. The query was trying to find matching zipcodes in 2 tables to obtain the name of a county from table 2 for table 1. Well, table 2 did not have a complete list of zipcodes so the query could not fully...