Search results

Go to the link below and download the Navigation Button sample database. This should help you disable your Next, Last, First, and Previous Bttons. Navigation Button Sample HTH RDH

Domain Aggregate functions can be slow in returning the needed result if the table contains many records. My choice would be the "FindFirst" method. RDH

Try: UCase(Format([YourDateField],"mmmm"", ""dd")) HTH RDH

Use the Nz() function with the DLookup. Here is and example: Nz(DLookup("CountOfAccount_ID", "qryCount400Accounts", "CUSIP_ID = '" & CUSIP & "'"),0) HTH RDH

Use the Int() function to round the values down. HTH RDH

I've had apps the convert with very few problems and I had others that had major issues. So there is no solid answer here. You can convert your app(s) to see for yourself what the result will be. If you have issues ... then you many need to alter the converted database and distribute the newer...

DateDiff("yyyy", DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB))) "DOB" should be the Date of Birth information. HTH RDH

Use the forms' "On Open" or "On Load" event to run the following line: DoCmd.Maximize RDH

It should be: DateAdd("yyyy",6,DateStart) "yyyy" is for adding years. "y" is for adding Day Of Year. HTH RDH

The limit is not based on the "number of records" ... it is limited to the "Size of the database file". RDH

Set the "Key Preview" property of the form to Yes. Now use the Form's "On Key Down" event to do what you ask: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) Dim intAltDown As Integer intAltDown = (Shift And acAltMask) > 0 Select Case KeyCode Case vbKeyF4 If intAltDown...

Make sure that DAO 3.6 is enabled in the split databases after you use the Database Splitter. HTH RDH

Error$ should work .... you may have a library reference problem. RDH

Have the form open as the applipcation opens by using the "Startup options" under Tool/Startup options in Access main menu. Use the On Timer event of the form to open the next form and close the splash form. You set the time for this to happen by setting the Timer Interval property of the form...

Basically all the Abs() function does is return the "absolute value" of a number. If the result from your Sum() function is 125.72 The return from the Abs() function would not change ... it would be 125.72. But if the return from the Sum() function is a negative number .... such as -125.72 ...

Go to the link below and download the utility there. You can set the shift key property using this utility so you can get back into your database. Bypass Shift Key Utility HTH RDH

It's usually not a good idea to combine data in a single field. You would be much better of leaving it seperate and concatenating on the fly if needed. But as Travis has replied ... "it can be done". RDH

Pat is correct (as usual). It could be a missing reference that is realy not missing. NT place files in different folders than Windows does. If the app is trying to reference a libary that should be at a specific location and it not there ..... "Missing" library reference. This will cause many...

If you want to implement an actual animated GIF ... go to the location below. You should find what you need there. Candace Tripp's MS Downloads HTH RDH

I would think the result would have to be divided by 100 to get it to a percenatage (or multiply by .1). So try: Me.Q1_Diff = ((Me.Q1_Actual - Me.Q1_Budget) / Me.Q1_Budget) /100 Or: Me.Q1_Diff = ((Me.Q1_Actual - Me.Q1_Budget) / Me.Q1_Budget) * 0.1 HTH RDH