Search results

Hi all. I am trying to solve the following problem. I have 2 tables - tblObjects and tblInspections. When I build query with that 2 tables I want to create a criterion that allows me to filter for each type of object how many times in the quarter there are inspections - for each quarter (from...

Hello, everyone. I need some help. I have a form with name fmObjectsWithoutInspections. Thah form has a subform with name fmObjectsWithoutInspections_sub. On the main form I have combobox cboYear to filter the subform with the query (qry_ObjectsWithoutInspections): SELECT T1.ObjectID...

Thank you again arnelgp! With your code and the improvements you made еverything works perfectly. I greatly appreciate your help, the time you take to help me and the other members of this forum. Your tips and tutorials are very valuable to me! Regarding difficulties I had with the Report, I...

I attach a a simple database. What I am trying to do is to extract the required result through three queries. With query one I do the filtration and query 3 I use it for my report. I can't think of any other way to do this. I also attach a photo to show what I want the end result to be.

Okay, I'm going to rewrite a bit of the database into English because it's in Cyrillic. Thank you all for your help!

Same problem again! When the cbo is empty and no records are displayed in the query. When I select an employee from the cbo , only records for the employee appear! I wonder why when I use this criteria for range Date everything works: IIf([Forms]![fm_12Reports]![txtFrom] Is Null And...

PARAMETERS [Forms]![fm_12Reports]![txtFrom] DateTime, [Forms]![fm_12Reports]![txtTo] DateTime, [Forms]![fm_12Reports]![cboEmployee] Text ( 255 ); SELECT tbl_12ObjectType.ObjectID, tbl_12ObjectType.ObjectType, tbl_12Inspections.DateT, tbl_12Inspections.Employee, tbl_12Objects.Municipality...

Hi all. I have the following problem: When I define the parameter in the Cross Tab Query "[Forms]![fm_Reports]![cboEmployee] and make column expression: [tbl_12Inspections.Employee]=[forms]![fm_Reports]![cboEmployee] Or [forms]![fm_Reports]![cboEmployee] Is Null, I can NOT see all records they...

Sincere thanks, again and again! As always you arnelgp are accurate and unerring with the decisions!

I'm trying, I can't do the task. A little help please

Hi all. I need some help in compiling the following query. I have two I have two tables - tblInspections, tblSampling and tblSampleType(with 3 fields - KD, PD, RD). The tblInspections has fields: id, date, employeeName, inspectionType The tblSampling has fields: id, sampleType, numbersOfSamle...

Тhank you all for the answers and help!

I figured out what the problem is with the very slow calculation of the values into the textboxes. The problem is that on the main Form I have unbound textbox with name "txtTime", which shows me the current time. On main Form I have event procedure "On Time" with the code: Private Sub...

Unfortunately, my base is in Cyrillic and will not be readable

11 409

what is your proposal? It is about a few minutes...

Hi all, I have subform with query "qrySubform". On the Form footer I have unbound textboxes for my fields, that have the following expresstions - =Count([field1]) or =Sum([field2]). Unfortunately, these expressions are very slow to load values into my unbound textboxes. Do you have any idea how...

Thanks everyone for your help!

hi all, I need to create function to lock them for typing new values. I have that code On Key Down event, but how to build that as function Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case vbKeyTab, vbKeyReturn, vbKeyDown, vbKeyUp 'Do nothing...

Thank you very much for the help, CJ_London! I used this very useful method http://www.baldyweb.com/CascadingCombo.htm, as an addition: If Me.cboAnimals = "Dogs" Then strSource = "SELECT ......." & _ "FROM ......"