Tedd- Steve's suggestion is correct. You can also open your form in Design view, select the section where you want to fix the tab order, then choose Tab Order...
Vishwa- If the Record Source is a query, is the field updatable when you open the query as a Datasheet? Do you have any code that might be setting the Enabled...
Your row source must be: SELECT dept.dept_code, dept.dept_name FROM dept ORDER BY dept_name; Set the column count to 2, bound column to 1, and display widths...
LT- Is InfAddress1 either a control on your form or a field in the Record Source? If not, then that's your problem. John Viescas, author Building Microsoft...
Navya- That's because Mod rounds both numbers to Integers, does the divide, and then returns the integer remainder. This should work: POINT = (Amt * 100) Mod...
still it reurns zero ony ....sir any option for geting remainder when it divides...in the MS excel Mod function works correctly...on the same query in ms excel...
It works for me. I went to the Immediate Window and entered: ?(CCur(123.45) * 100) Mod 100 Answer is 45. Are you sure there's a fraction in Amt? Halt on that...
A.D.J: Sorry, I reply you late again. But, I am avilable now.I will reply you as soon as I see your message. One thing I am not sure is the time difference: I...
A.D.J: Sorry, I reply you late again. But, I am avilable now.I will reply you as soon as I see your message. One thing I am not sure is the time difference: I...
it is right, it works in immediate window....but in form it is not appearing...the rest is not a matter...u will not get anything from that code because all...
Dear All, I have a NotInList event for a combobox like the code below. It works quite well. I wonder if is possible to add the NotInList input directly to the...
Wouldn't this work? point = (amnt - int(amnt))*100 if amnt is 123.65 or -123.65 the above should give 65 I am concerned that using MOD will return some strange...
thanks ....i got Jim C <liteways@...> wrote: Wouldn't this work? point = (amnt - int(amnt))*100 if amnt is 123.65 or -123.65 the above should give 65 I am...
I ended up using the View | Tab Order dialog. I've always just manually entered the order number in properties before and that's always worked for me. It may...
Kevin- Sounds like a corrupted database. Also check that you have the latest service packs applied. Choose About Microsoft Access from the Help menu to find...
Kevin- Sure. Delete the I = MsgBox and get rid of the If line and everything between the Else and End If. John Viescas, author Building Microsoft Access...
Thanks Steve, I do appreciate the assistance. I will admit though, that the pseudo code confused me a bit. I've settled the update information into a Table...
L T- Did you add the fields to the Record Source after you first created the form? Sometimes the form doesn't "wake up" to recognize added fields. Try ...
That's a pretty tricky way to do it, Steve. I've always used the Tab Order dialog, but with a form having many controls, it's a chore to drag items from one...
Thanks John! That is sort of where I was heading yesterday. I pulled those selected records that I knew needed to be compared (By ID)and began shuffling...
1. No, I didn’t add the fields to the Record Source after I created the form 2. I changed all the Me! to Me. 3. I compiled from the Debug menu and got a...
How do you get the window to pop up where you save a file and it lets you pick the directory, etc. I finally figured out a way to get a report to export to...
L T- Did you try changing the Record Source property and then changing it back? Do you see the field InfAddress1 when you open the Field List in Design view of...
The query itself is efficient, but you still have to run this query for each field, correct? Changing it from Fax to Addr1 to Phone, etc.? That's why I was...
You seem to have the code almost there, clsCommonDialog I guess is (someone's) wrapper class for the API calls. Within your With/End With you need execute the...
Nancy- Note that PID must be the Primary Key of at least one of the tables to make this updatable. It'll also run faster if you have and index on the Fax ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
