Search results

Why do you need to relink the tables ... If there are users accessing the BE file .. the relinking will be painfully slow as you have seen. You should avoid any relinking if possible ... RDH

I hope those are not the actual names of your fields .. as all 3 are Reserved Words in Access ... Now .. you can get the values you ask by creating a Totals query and Group by the name field ... RDH

Not that I know of ... What changes are you talking about that happens in other forms without intervention ??? RDH

Fizzio ... you can still format a message box as you could in Access 97 in Access 2000 and 2002 ... You just can't do it the same way as in Access 97 ...... Here are two examples show how it can be done. Eval ("MsgBox ('Your Bold Text Here.@Your Normal Text Here.@@',0,'Your Title Here')") '...

You can retrieve the User Level Security ... Group, User, and Password information if you have the right software. This software is very expensive. Also ... it is illegal to break the security of a secured database without the permission of the owner of the database. RDH

All I can think of is that the combo is not bound to the field in the table on the form. RDH

If you want to use a "true" animated GIF file in Access .... go to the link below. There are other ways to emulate the GIF animation by capturing the images and using a timer to animate them. There are examples of this method in the same code archive forum also. Animation with Animated GIF's in...

1) If the field is for a balance ... I would think the datatype should be currency and not text. So if the datatype was numeric or currency you would set the Default Value to be 0 .. and the problem would not exist. 2) Usually a "balance" is the result of a calculation. The result of a...

You should not double post your problem in the forums ... This only confuses the people attempting to help you. Myself and Pat Hartman has replied to your other post. RDH

Pat is absolutely correct in avoiding the problem. If the Time values will never span more that 24 hours .. got to the link below for a work-around. StartTime-EndTime Results in a Negative Number RDH

If the numeric value is not being "Indexed", used to sort the records, or used in a calculation within the app ... change the datatype in the table to "Text". Else .... you will have to format the numeric value to display in your wanted format wherever it is needed in the application. HTH RDH

Executing the Row Source query will show the 4 decimal places .. but not the the combo display. To get the information to display in the combo as you want .. you will need to create a "field expression" as I suggested in my first reply. This field expression must be created in the "Row Source"...

You need to format the value in a field expression in the combo's Row Source query .... and show that value in the combo. If you want all value to appear as 4 decimal places and show the trailing zero's ... use this: myPrice: Format([Price],"$#,##0.0000") If you want all value to appear as 4...

Why are you opening the form in acDialog mode ?? This will cause the code to pause until the form is closed or the forms' visible property is set to False ... Also if "contro_id" is a numeric datatype the code should be: DoCmd.OpenForm "bincard_record_view", , , "[contro_id] = " &...

LOL ... Jack I guess I was just "Johnny on the spot" ... RDH

You need to find the "Section Index Number: and use this example: Me.Section(3).Visible = False Change the index number to the correct section index number. HTH RDH

LOL ... sorry Bob ... I've been tied up on some some Admin things at the "other site" ... and have not seen the post. It appears that the solution was found and "all in well in Access Land". RDH

If you are only entering the Time values .. you will have a problem when the end tim spans into another day. But if the elapsed time will never span more than 24 hours .. go to the link befow for information and a work around. StartTime-EndTime Results in a Negative Number HTH RDH

Try this instead: Select Case Me.myfield Case Is < #12/13/02# Case #12/13/02# To #2/14/03# Case Is >#2/14/03# End Select HTH RDH

I hope I understand your question. The format will have to be different due to the range can fall into two different months. Here is an example that will return ... May 28, 2003 - June 03, 2003 based on todays date (06/03/2003) I assume this is for display purposes only ... Place the...