Search results

Under the Edit / Find tab I only see a section with Confirm record changes document deletions action queries not confirm deletes Do I use one of those????

I have a delete button on a form 9developed with the wizard) to delete a record. I have put in a message with the code showing like this Private Sub Command74_Click() On Error GoTo Err_Command74_Click If MsgBox("Delete record?", vbYesNo, "Delete") = vbNo Then Else...

If you like to catch all the textboxces that are empty and make their labels invisible, you can use this single code Set textboxes to the following properties to avoid having empty spaces in between visible labels/textboxes Can Grow yes Can Shrink yes Set the following code to the On...

Is your report bound to the table or query that contains the fields?

Need help with the code on the on click event of a command button on formA to stop formB from opening if the listbox on formB is empty

Dave I really appreciate you sharing the small database. It helped me with a project. Have a beer after work. Marcel

Rich just posted a solution for related to an incorrect entry of a date. It works when using the tab key to get out of the box. I need to go a step further yet and set a code that the same message shows up when any other action is taken (e.g. close the form or click on another object)

Rich just what I needed thanks

I just ran into this code today, so I have not tried it myself. Place the following code in the "On Current" event of the main form. Private Sub Form_Current() With Me![SubformName].Form .Visible = (.RecordsetClone.RecordCount >1) End With End Sub Let me know if it works

I’m trying to set a code to an event procedure of a textbox (Date/Time) that will alert the user when the date entered is greater than today and return the focus to the textbox for correction. Here’s what I used. It pops up the message box, but does not set the focus back to the textbox. Here’s...

SelectDate should be the name of your calendar control. If your calendar has another name substitue SelectDate with yours.

On the report (maybe the header) add a textbox and in the control source enter ="From " & Format([Forms]![FormName]![BeginningDate]," mm-dd-yyy ") & " through " & Format([Forms]![FormName]![EndingDate]," mm-dd-yyyy") FormName being the form that holds your calendar control

In the On Load event of the properties of the form that has the Calendar control

There are multiple publications and seminars that will teach the ropes of Access including setting filters to a form. I'd suggest to go that way.

I haven't done graphs lately, but recall this problem.You probably will avoid this problem by setting the criteria to the graph and not to the form bound to the graph. Open the graph's properties and set the criteria in the row source on the data tab. Clicking on the dots behind the row source...

Open properties of the fields in the table. Click on the data type tab. Enter mm/yyyy in the format box.

Did you set the Format property to Fixed when you set the Decimal property to 2????

I agree with Newman about looking to use more than one. As far as I know there is a limit on the controls you can use in a single database (don't recall how many) even counting the ones you used and deleted afterwards.

I assume you want to compare the total available hours with the total required hours?? If yes you can create this graph from scratch or by using the chart wizard. Make sure both the sum of each field are in the Y-axis. If you want to call the numbers for a specific time frame, you might also set...

Go to MSAccess help and look for the following topic Calculate a total or average for a group of or all records in a report It will show you exactly how to do it. If you need more help later please repost Marcel