Search results for query: *

To be safe, I do this. Me.Requery Me.Refresh Me.Repaint

First, create the new field as type text and a size that will ft the concantenation of the fields. Then, create an update query that inserts the this expression: [Field1] & " " & [Field2] & " " & [Field3] into that new field. Field1: "City" Field2...

I've got the switching colors to work. Any thoughts on why it seems to pause when there is only one record?

Perhaps someone can help me with the problem expressed in this thread thread702-641814

(inputweek-(cint(inputweek/100)*100))+((52-(10+cint(inputweek/100)))*100) The ()'s may be off, but this should work if inputweek <1199, assuming your always using 52 week years, and that you have another routine to get the first few weeks of the year. This can get you values at the end of the...

Set the DisplayWhen property of the button to Screen Only.

Check the code behind you BeforeUpdate event. Make sure that the keys are posted in the right order. You may have to verify that all required fields on the form have been filled in first.

It looks like all you are missing is the rst!Message = Me.txtMessage Do this before the update and that should put the message from the txtMessage control with every selected LogID.

Thank you for the star. It is much appreciated.

I have a continuous form with a text box that will display one of two values. If the value is X, make the background green. If the value is Y, use the default Red background. The form works great and the formatting works, unless there is only one record. If there is only one record, the Form...

FindPO = InputBox(&quot;Enter the PO #&quot;, &quot;Bionetics PO System&quot;) DoCmd.OpenForm &quot;frmPO&quot;, , , &quot;PONumber=FindPO&quot; Should be FindPO = InputBox(&quot;Enter the PO #&quot;, &quot;Bionetics PO System&quot;) DoCmd.OpenForm &quot;frmPO&quot;, , ...

Can you run the code if the parameter is declared as Optional?

Here's a small example: Public Sub TestSplit() Dim arr Dim t As Variant arr = Split(&quot;h,i,t,h,e,r,e&quot;, &quot;,&quot;) For Each t In arr Debug.Print t Next t End Sub

Check the referential integrity rules in the relationships window. You will need to make sure you updates are done in the right order, or do not enforce referential integrity.

You should create a query that pulls data from the two tables and base your form on that. The recorset fromthe two table should update the fields you need.

I think this is the right syntax for you Forms!Formname.field=True Does this help?

SELECT * FROM tablename WHERE week>Me.UserWeekNum-1000 AND week<Me.UserWeekNum Something like this will work. The idea is that 1 week ago is thisweek-100. So if this week is 3003, last week was 2903, and ten weeks agos was 2003, or 1000 less than this week. Does this help?

Yes. What you want is possible. If you use the toolbox in the form design view, select a combo box and make sure the Wizard tool is also selected. When you go to create a new Combo box on the form, the wizard will ask what kind of combo box you want to create. Select the options that says you...

Create a form for the user that has two button on it. One button will display the report to the User, the other will open (or send ot Excel) a query with the report data in it.

For the record source of the report, create a field that is Order_By_Date: (SELECT Min(Date) FROM Orders WHERE Order_Number = [Order_Number]) Then do your first grouping on Order_By_Date. Everything else should stay the same.