Search results

Jen, Please reread my 1st reply. Simply make the update query do what you want it to do. If you want it to update 1 row, then include the where parameter so that's exactly what happens.

If that's the case then modify your query used to show the classes to filter on the session. Select * from Classes where Session = YourParam.

Jen, include a where param in the update query so that it updates only the row you want. Update YourTable Set YourColumn = 'x' where ID = YourParam

Not sure exactly what you want to do. I downloaded your db and added a simple radio control that will allow you to show and hide two subforms. hth, bob

DELETE [Initial COBRA Sent].* FROM [Initial COBRA Sent] INNER JOIN [No longer benefits elig_to remove from table] ON ([Initial COBRA Sent].[SEQ NUM] = [No longer benefits elig_to remove from table].[SEQ NUM]) AND ([Initial COBRA Sent].EMPLOYEE = [No longer benefits elig_to remove from...

Phatus, as Skeeter posted.. The "After Update" event should handle this for you. (I was moving to fast and mistakenly put OnCurrent ) Anyway... if your underlying recordset is a query, and from what you are saying, the textbox control on the form that displays the TOTAL is a calculated column...

did not download the file but try this.... in both textboxes put something like this in the OnChange Event. tbTotal = tbAmount - tbDiscount

Colkas, Instead of recreating the Report and all the subreports.... can you put code behind the two buttons that open the report that changes the recordsource for each sub? If the structure of the subforms is good for both reports and the only thing that needs to change is the data, I'd explore...

Steve, are you working in an .mdb? Are you looking for a simple query to copy a row into the same table? If so... just create a query where the PK parameter is pointing at the row you want to copy. Then Add all fields EXCEPT for the PK. Make it an append query that is appending to the same...

I have a parent/child setup. A parent table that stores the "Name" of a recipe. Then I have a child table that stores order of ingredients and instructions with the "Name" of the recipe from the Parent Table and the order being the relational key. --You might want to make the PK an...

have you tried... setting the orderby = null and orderbyon = false prior to resetting it? hth, ..bob

Can't say I've had the pleasure of any correspondence with you Friday. That doesn't make me any less happy for you! Congrats on the GREAT News! sincerely, ..bob

>> I played with the code a little and amazingly for me it works pheww. -- Congrats Colkas! Sometimes it takes a bit of trial and error. Sometimes that's the best way. You now have these tools in your toolbox so that future projects needing similar requirements will go together easily for...

>>Can I ask please if you wouldnt mind walking me through the formula you used. SELECT Sum(tblAccount.Income) AS Inc, Sum(tblAccount.Expense) AS Exp, Sum([Income])-Sum([Expense]) AS Remainder FROM tblAccount; Altin, If you are using the QBE Grid as opposed to the SQL window, the tool bar...

Open the form in design view, and make the Recordsource for the form the new table you just created. Basic functionality will allow you to add and edit existing rows in that table.

May I suggest that you try posting some of the things you have questions on.... There is an abundance of people here that are willing to try and help if they can.

what do you need help with pappu?

sure... just set the txtBox.visible property to No.

>>>But I cant get a space in between the user name and the position. tried , " and all sorts. Any ideas. For the space.... try.... Try...Forms![main].Form.txtCurrentUser = rtrim(Me.cbo_user.Column(5)) & " " & rtrim(Me.cbo_user.Column(3)) >>It would be Colin Preston IT --- txtbox1 =...

Altin, After opening the .mdb I can see that you have Categories like Car, Income & Shopping. If you want to aggregate by Category, you can certainly do that easily enough. You can't aggregate by date because the dates in your table are all different. You would get the same result as a select...