Search results

What you are doing seems to be right. Why don't you try setting the Allow Zero Length=Yes property of all the fields you suspect will have null values. Then you will not even have to handle null value through NZ

How about adding an extra line on Form Load event DoCmd.ShowAllRecords Just a suggestion, worth a shot

can you please post you onclick event code and let us know whats not working?

You can always put a double-click event on the subform and then open detail form using link criteria e.g. Dim stDocName As String Dim stLinkCriteria As String stDocName = "YourDetailForm" stLinkCriteria = "[RecordID]=" & "'" & Me![MyTextBox1] & "'" DoCmd.OpenForm...

Doing what boblarson has suggested is the simplest and most effective solution. But if you really want to force movement of curson at a particular control than you can put a simple one line code on Open event of the form. Me.YourControlName.SetFocus or DoCmd.GoToControl ("YouControlName")...

A very simple solution maybe using Mod function Public Function ConvNum_Time(intVal As Integer) As String Dim strHours As String Dim strMinutes As String strHours = Format(Int(intVal / 60), "00") strMinutes = Format(intVal Mod 60, "00") ConvNum_Time = strHours & ":" & strMinutes & ":00" End...

Why dont try something like this On click event of the list box put Forms!MyForm!MySubForm.Form.RecordSource = Your Query Me.Form.Recalc I can explain a bit more if it fails to get you started

Personally I think it would not make much of a difference but I can understand that for visual reasons it will look a bit more professional to display blank list box at the start and then filter it as you press keys on Change event. I would suggest following strategy Don't assign any row source...

You need to shift focus to another (usually the next control or exit button) control first before making the active control invisible. You need to do something like this Me.MyNextControlName.SetFocus Me.MyButton.Visible=False Good luck

How about if you try Shell("Application Path",vbNormalNoFocus )

Hi, I presume that the newly opened form is pop-up. You can set the Modal=Yes property of the form to lock it on the screen. Hope it helps

Use form level properties Hi An easier way is to use following properties Me.Form.AllowEdits=False 'locks editing on the whole form Me.Form.AllowEdits=True 'Unlocks editing on the whole form Few of the other properties you might want to consider Me.Form.AllowAdditions=True/False...

Hi, In order to view what form looks at the design view, you need to set DefaultView of the subform to either Single or Continous. Hope it helps

Hi Is there any way by which I can loop through all text boxes and get 2 pieces of information 1. Control Source (Name of field) - I have already managed to do so 2. Caption of the attached label of the text box The objective is to give a list of label captions and their corresponding fields...

For more detailed description of the error and see the 4 possible solutions (one is indicated in the post above) see this article http://support.microsoft.com/default.aspx?scid=kb;en-us;319844

Do you an autonumber field in the tavble. If not then create autonumber field first and then instead of DateField<=DateField use Autonumber<=Autonumber. Good luck!

Hi Just by looking at it I can see that you are missing a bracket after sum in the inner select query. Try this SELECT Pro.[Date], Pro.[Person Id], Pro.[Course Code], Pro.[Course Name], Pro.[GLH], (Select Sum(Pro1.[GLH]) FROM [QryAllEnrolments Without Matching QryWithdrawls] Pro1 WHERE...

Use Imput Mask You can set input mask to the way you like. See help for input mask in Access to know what's best suited to your needs

One simple solution could be to create a frontend version with all the forms locked by setting Allow Additions, Allow Deletions, Allow Edits properties to flase at the form level. This will only prevent the data entry/deletion on form level but Pat Hartman solution is definitetly the ultimate one.

Use subform? How about if you use subform? I presume that images are bound to records. Create Search text box in parent form and then display search results with their images in subform. Regards Aqif