Search results for query: *

I want the arrows to move from control to control in the same order as the tabs. This generally works, but then if I mouse click into a control, the arrows just seem to go dead! Any suggestions? RAF

Just follow the instructions at: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q278379 I used the second part, entitled " Creating the MouseWheel Event Completely Within Microsoft Access" Let me know if you come across any side-effects outside Access. RAF

It seems nobody has an easy work-around for the mouse-wheel problem. I went to MS page for their programmed solution. Since I don't know anything about ActiveX or dll programming, I opted for their VBA code embedded in my form. I cut and pasted everything per their instructions, and it seems...

It seems nobody has an easy work-around for this. I went to MS page for their programmed solution. Since I don't know anyabout ActiveX or dll programming, I opted for their VBA code embedded in my form. I cut and pasted everything per their instructions, and it seems to work. The problems...

I have a customer order form. I want the user to enter exactly one order, then close the form. (Closing triggers VBA code to do a bunch of stuff.) The record selector and navigation buttons are turned off, but now the user has a mouse with a scroll wheel. When he accidentally scrolled with...

I have a table of all transactions for several products. I want to see just some of them via a form used as follows: Choose the product via a drop down box. Enter starting date and ending date in unbound boxes. Have the selected records show up on a subform. Can I do this without vba coding...

I have a Customer Info Form. I use a combo box to go quicky to a particular customer. I want limit_to_list false so that if the customer is not there, I can get a new form and enter new data. The combo box uses a hidden CustID field (an AutoNum) but displays the CustName. It will not let me...

I have a table of Distributors, with a related table listing the SalesReps for each distributor. On a customer data entry form, I have a combo box to choose a Distributor. After picking a Distributor, I go to another combo box to choose a SalesRep. In the SalesRep combo box, I want to limit...

I have a project 2/3 done in Access 97 and have imported everything into Access 2000. None of my forms work. I get an error on the first line where I have dim db as Database After going through on-line help, it looks like I'm going to have to recode a lot. Is everyone doing this? Is there...

I have a 2/3 done project in Access 97 with lots of VBA code. I have imported everything into Access 2000. I get compiler errors on just about every form at dim db as Database I've browsed the help system, and it seems I will have to recode tons of stuff. Is everyone doing this...

When I use DoCmd.OpenReport with the 3rd parater as acDefaultView&nbsp;&nbsp;(Or whatever it is EXACTLY, I'm not near the code right now :-))the report still goes into a Preview.&nbsp;&nbsp;The documentation I have says that the default is print.<br><br>I am able to force it to print via a macro...

Whenever I disable a control on a form, it shows up gray on gray.<br><br>Changing the background/foreground information&nbsp;&nbsp;only seems to affect the control when is is enabled.<br><br>Is there a way to modify the colors used when a control is disabled?<br><br>Thanks<br><br>-- raf<br>

Thanks everyone - <br><br>The IsNull(XXX) does the trick.<br><br>I Like BFamous's comment<br><br>Can something equal NULL or IS IT NULL........<br><br>Obviously the latter.<br><br>--raf

I have a combo box called Whse created by the lookup wizard for my whseID field in a inventory table.&nbsp;&nbsp;The box displays the whseName, but it bound to the whseID. Limit To List is yes.&nbsp;&nbsp;This is all on a subform<br><br>Here is the problem.&nbsp;&nbsp;If I pick a warehouse and...