Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Bra81ndy

  1. Bra81ndy

    Custom Order for Continuous Form

    Thank you for the help. The solution incorporated the advice from both GingerR and lameid. I made a table that outlined the order I wanted for the Test values called QC Index. Then I placed this code in the record source for the form. SELECT [QC Results].LabNotebook, [QC Results].Test, [QC...
  2. Bra81ndy

    Custom Order for Continuous Form

    I want to specify a custom order for a sub continuous form. I tried an IIF statement like IIF([Test] Like "Viscosity", 1, IIF([Test] Like "Viscosity 0hr", 2, 3)) in the Order by property of the sub form. The Form basically ignores the statement. Also is there a way to force the form to order...
  3. Bra81ndy

    Data entered into form does not immediatly update underlying table

    Thank you for your help. I believe I have solved the problem. I added a macro that uses Runcommand to Saverecord. I put this macro on the controls in the After Update field for which I want to immediately update. So far this is giving me the results that I wanted to see. I need certain...
  4. Bra81ndy

    Data entered into form does not immediatly update underlying table

    I opened the form in design view. I opened the properties for the control and wrote me.refresh in the box for After Update. I switched back to form view and inputted a name for a formulation. When I tabbed to the next control it gave the following error, Microsoft Office Access can't find the...
  5. Bra81ndy

    Data entered into form does not immediatly update underlying table

    A main form is used to enter data for glue formulations. I create a new record and enter the name for the formulation in the specified control. This data will not show up in the underlying table unless I switch records or click on a sub-form. I feel that I need some kind of code in an event...
See more

Part and Inventory Search

Back
Top