Search results

Hi, I have Access 2010. I am looking for a function for a query that will have a group number and then the next group number is a sequence group number as follows: Table1 Function: Col1 Col2 GrpSeqNo 3100-E-001 a 1 3100-E-001 b 1 3100-E-001 C...

how do you bring up the conditional formatting box on a check box?

Hi, Does anyone know how to. In ms access 2003 I have a form in DataSht View I have a text box (DisableControl) with either a Blank or "disable" in it. I have a checkbox (Yes) When the form loads or opens I want to disable the check boxes (Yes) that I have "Disable" in the DisableControl...

Hi Beetle, Thanks for your help I did get the code to work I have expression and not by Group by Thanks again Bryyan

Hi Beetle,Thanks for your help I tried that and I get a syntax error in string in query expression WorkOrderID = 24 And DrawingNo = 8167-44 Not sure what that means

Hi Beetle, I have a Form - WorkOrder fm in that I have WorkOrderID & WorkOrders I have another SubForm Welds Fm in that I have WorkOrderID,WeldsID, DrawingNo, WeldNo, TestPackNo and ClosureWeldNo. Related is the 2 WorkOrderID,s I want to Concatenate ClosureWeldNo and get this result...

Hi, Can Someone Please help. I am using Duane Hookom's Concatenate Module. I am using this right now in my query CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl] WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID]) It Concatenates by the WorkOrder But I want It to Concatenate...

Hi, Sorry, I may have not explaned what I was looking for well enough What I was looking for was to add onto the Where statement to this CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl] WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID]) After the WHERE WorkOrderID...

Hi, Can Someone Please help. I want to Concatenate in my Query a textBox the CL-No's by WorkOrder and by DrawingNo. I have a query with WorkOrder, DrawingNo, ClosureWeldNo, and some other stuff.... For this Query I have 2 tables - 1 is WorkOrder tbl (With WorkOrder in) and The other is Welds...

Thanks that works perfect! On the second code - I see how you did that So the mid needs a start number and a end number. By using the instr function you can return a number for this mid function and even can use the +1 and -1 at the end. Thanks again BBryan

Hi, I have data that has been exported from excel WO-20653276-welding [9101 Injector 1 Steam Heel Broken Drain Valve] WO-20660073-welding [9309 Injector 7 Toe Broken Drain Valve] WO-20634112-welding [8500 Fab & Install Piping ProducedWaterLine] I would like to extract in a query these 2...

Hi GalaxiomAtHome, Thanks for your all your Help.

Hi GalaxiomAtHome, Here is the Database The form is Workorder from Thanks BBryan

Hi GalaxiomAtHome, Thanks for your responce I am not sure how you call this - but what I have is a Form in Datasht view. The Form is called WO fm and with in this form is the sub called (Info fm). All in the same form. In Datsht view I have the plus sign when opened goes to the Sub form (Info...

Thanks I wanted to use this as a datasht view because it is easier to see all of the data vs Continuous also the use can copy and paste whole Row if it is simular(For Quickness). I will have to use the Continuous View thanks again

Hi, I have a Form (WO fm) and a sub form (Info fm). In the Form (WO fm) I have a checkbox named [Active]. In datasht view I want to click on the plus sign (to Open the subForm) for a certain WorkOrder. I want a checkbox [Active] to be checked (true) and all checkboxes [Active] to be unchecked...

Thanks I see that covers everything about nulls.

Thanks Bob, That was easy. I must have missunderstood how the NZ Function works. Bryyan

Hi, I can't figure this out. I want to add and convert by muliplying 3 fields together But some of the fields could be Null. I have this but it doesn't work. Length(InMeters): Nz(([Length(ft)]*0.3048)+([Length(mm)]*0.001)+([Length(m)])) Thanks