Search results

Yes, this process is still in development stage so I am just testing everything to my printer. I converted this code from a macro. I don't know if that has anything to do with it, . I wouldn't think so as all the other reports print fine, also, this is the first page of a tab form. I don't...

I designed all 21 of the the reports exactly in the same color scheme as I mentioned in my post and when I run this report from print view it prints in the correct manner as do all the other reports in the series. When I run these reports in code the one I mentioned runs in grey scale and all...

Thanks Bob I really appreciate the help

This doesn't make sense to me. These reports are generated from a command button base on a check box. All reports have the same Autoform Trex. This prints in grey scale from a color printer If Me.RouteA = True Then DoCmd.OpenReport "rptDailyOrdersForRouteA", acViewNormal, "", ""...

Thanks Ken

The check boxes are on a form. If check box value is true then I need to print the report associated with the checkbox.

I have a tab form with 21 reports that I want to print depending on the True/False value of check boxes. I am not very savy with Access VBA. I need to print all the reports daily but this is in the event one or many of the reports need reprinting. I was thinking of using a select case statement...

The row source is the table being updated and has both fields in the rowsource. Could I limit it in the Rowsource something like is null? Because if the field was updated it would have a value in it otherwise it would be empty.

I have an unbound combobox to select records for my form. When selected there are 2 fields that get up dated then another record is selected. Is it possible to eliminate the records that have been updated from the combobox list?

I have gotten this error before but I don't know what's causing it. Error 2001 "you canceled previous operation" occured when I tried to selected an unassigned order from the unbound combobox in SplitForm view. This is the code assigned to the combobox afterupdate. Private Sub...

New problem has arisen. I don't want the RouteID to change value if it already has a value so I am trying this code but I get a "424 Object Required" halt. At first I didn't have the Me. in front of the field name but after putting in the Me. I still get the error. To make your previous help...

Thanks twice today Gamma, I appreciate your input. Skip

Thanks Gemma

I understand that. I want the user to just use the tab or enter key and move through the pertinent fields and return back to the first of the three fields to start again. Is that possible?

The RouteID is the bound field. PegRoute is the unboud field. I need RouteID to always be the value of PegRoute. When I want RouteID to change to a different value I put a different value in PegRoute. I hope I am clear here. Thanks for responding.

I have a form that only three of the 10 fields are used the rest are table values for information only. I would like to eliminate the information fields from tab order and just beable to tab to the three input fields. Is that possible and if so how do I do it?

I would like to place a value in an unbound textbox and have a bound field retain the unbound value after update, Have tried using the bound fields default value and using code in the afterupdate event but I can't make it work. I am trying to do a work around from a previously unrequited post...

Wayne, I am assigning a route and sequence number to approximately 500 orders in this table. These orders are in hand and manually distributed to each route basket. I want to assign upwards to 35 orders to a route and seqence them in delivery order. I need those values in RouteID to stay until...

This is my code I meant to add to my original post. The form is bound to the table I am updating. Private Sub DeliverySeq_AfterUpdate() If Not IsNull(Me.DeliverySeq) Then Me.DeliverySeq.DefaultValue = "#" & Me.DeliverySeq.Value + 1 End If End Sub Private Sub RouteID_AfterUpdate() If Not...

I am tring to get these two controls to keep the value in them after updating until the user changes the value. One is text and one is numeric. These are the AfterUpdate codes I am using from some previous help on a similar issue. The problem is they go away after updateing occurs. So I am...