Search results

You can change the colum the control is bound so that it is bound to the name instead of the number, you can do this in the properties of the combo box.

You can't check for "" instead you need to check for null as shown below. Private Sub txtReason_Exit(Cancel As Integer) If IsNull(txtReason.Value) Then msgbox "You Must enter information on this field" txtReason.SetFocus End If End Sub

DLF, as you can clearly see these things grow branches of their own. The query scenerio I had previously provided would probably be the easiest for you to visually see since all I was doing then was opening a form with the query results and comparing the values returned in the forms fields with...

Try using a memo field to store your addresses and setting the scoll properties accordingly

Here is a sample database I created that searches on the same form.

If you are using the subforms event move the code to the master form. I had the same issue and I put the Docmd.Maximize on the OnOpen event of the Master page.

The best you can do is convert it to an MDE so that the code and design can not be changed.

Remove the acdialog so that it opens in default mode.

Try simply putting Like [Forms]![Search]![BoxNo] & "*", this should return anything that starts with C1 but not things that do not start with C1 so MyC1 will not show, if you want the users to be able to build their own search then provide to text boxes, on 1 they select "Like", "=" and then on...

If you find the "You are about to update..." message annoying shut off the system warnings while you execute the code. Sub Runquery cmdbutton_onClick() DoCmd.SetWarnings False Docmd.Runquery "YourQueryName" myform.Requery 'If the Requery does not work try this: Docmd.RunCommand accmdRefresh...

Another way to get the effect using the tab control is to set the Caption to a space so that no caption displays and set an image with the color and name you want on it. This will be like setting an image button on a web page so that you get the rollover effect, except that it will be for the...

Try me.Control.value = Empty Sometimes you just need to set them to something other than Null since null is considered a value.

DLF, you can use Dmax to achive the same results notice that you must check for Null value since the 1st entry for a new week will not return any records from the table and will return Null, you will get an error "invalid use of Null". Checking for NULL allows to enter 1 on the week period so...

DLF, try looking at the attached file. It increments the weekperiod depending on the week number entered. Should be pretty simple to understand.

MattP, after testing the attached database I noticed that since I have the Event on Lost Focus for the Report button it closes out the Report Options form. To correct the problem I moved the code for the On Exit to the on Enter of the 1st textbox. The code can be entered as a sub and called by...

To ensure it is always displayed correctly I suggest adding it to the main form and simply hide it, then display it when the button is pressed. If you set the resize option it should show correctly. Check out the new trick I used to display it as a dropdown list. I used a subform with no...

I had a similar request where I needed to have a reminder open to let me know when to run a report. I ended up adding a control to my form that checks what day it is and if it is 1 day before the report is due it shows Run Report Tomorrow, if it is due today it shows, Run Report today, if it is...

Not sure what is the use for this but here is a database that does what you need. The database uses a hidden form to check if the values of the week and week period exist and takes action according to the results of the form recordset. The hidden form's recordset is a query with criteria set and...

Check any of the form events and make sure nothing is being set through VB Code that restricts what the forms display, check the query criteria to ensure there is nothing that might be restricting the information. If all else fails post or send me your database and let me take a look at it. If...

Jancliff, you can leave the code as it is and write an undo event once the criteria is met, or change the code so that it warns on the 39th record and set a message stating, you have now entered the 40th item, you can not add any more. What is happening is that it waits until the 41st record and...