Search results

Hi. i am facing a fairly complex problem: I have a search form with 6 Combo box use to select the criteria of a query with 14 fields bound to a continuous subform. Thanks to UNCLEGIZMO (forum user), I managed to insert in my database a code that allow me to select all the data for each combo...

Is there a function that could give me a string without the first character: Function???(Russian) = ussian

I have a problem with the combo box, after using it a couple of time, the format function disapear and I need to reinsert it in the row source query. I don't understand??? (The combobox is unbound and located on a single form)

Spot on Keith, I didn't think it would work but it is working. Thanks for your help. Fred,

Keith, you are right, Access is only evaluating trhe first row of the records. I understand the formatting method but this will only highlight the field "boolean", the ideal situation would be that when the field "boolean" is highlighted for 1 record, all the corresponding field are highlighted...

I have created an unbound "search form" with a subform bound to a query. The default view of the subform is set to continuous which, allow me to see each record of the query in a single row (all field are tagged "Row"). One of the the Query field "Boolean" as a Yes/No format. I have written a...

Thanks you so much. I am going to have a look at it.

Thanks How can I get a variable to be equal to a specific table field value using code?

What is the usual way to store the weight in a Bill of material database? Do you store the weight for each assembly and each component or only the weight of the smallest components (where the weight of each assembly is calculated by adding the weight of each component)? The way my table is set...

I am trying to build a function using a set of 3 constants. I wanted to store all the constant values in a single table (with only 1 row). Is it possible in the declaration of my code to set the constant value to the corresponding field of my table constant? What would be the basic syntax to...

I am not sure my explanation is really clear, but here is a more precise example: Tbl1 FldX FldPipeID Tbl2 FldPipeID FldPipeSize Query shows all the record from Tbl1 and the Field FldPipeSise from Tbl2 *Join property are set up to show all the record from Tbl1 *Tbl1 & tbl2 are Linked by...

Thanks Hi Gizmo, Thanks for your code it's really helpfull, I think I managed to make it work but there is still some point that I don't totally understand, what is the function of (*) in a query. Why do we use the SQl "LIKE" with the functions in the criteria of the SfrmQuery? This method is...

Thank you very much it's working: SELECT DISTINCT Format([CasingOD],'00.000') AS [Casing OD] FROM TblCasing WHERE (((Format([CasingOD],'00.000'))<>0)); Cheers,

I have an unbound Form with a Subform bound to a query. The query parameters are selected by the users via Unbound cboboxes. The form is working but I would like to add a feature on each cbobox that would allow to show "All" the data (ie:Show the data like if there was no parameter on that...

I am not sure how to deal with the weight of my items in my BOM system. I have got a TblItem Linked to a TblComponent that establish the relationship between each items (Assemblies made of various parts with assemblies and part stored in the same tblItem) I have a field weight in the TblItem...

I have a problem with one of my combo box. The format setting of the combo box doesn't change anything to the way I see my data. The row source is based on a query of which the 'data sheet view' shows my field with three decimal number. Whatever setting I change on my combo boxe parameter, the...

Vive la France This is just a thought, has anyone else felt that some of this is an in-direct result of their complacent attitude... Hey, I am french, What do you mean by Complacent attitude, never forget my dear friend that French people are very touchy... The stuff hapening in France just...

Can't F*!!!*g believe it! That really suck men. Ken fit I meen...

I was wondering if it was possible to add a parameter to the record source Query of a form depending on the value of an other field on the open event of the same form? I was thinking to use 3 Sql statment SQL1, SQL2, SQL3, on the open event of the FrmOpen. On Open then the RowSource of FrmOpen...

This is the first time I am trying to use the Dcount Function and I can't make it work; I don't see why? This is my code which Is very simple, is anybody sees any mistakes? Private Sub TxtDrawingFile_AfterUpdate() Dim StrDrawingCount As String StrDrawingCount = DCount([DrawingFileID]...