Search results

Hi, I am trying to INSERT date form fields form with that code: CurrentDb.Execute "INSERT INTO 01_tblLocalVariables ( Value, VersionDate, WhatsNew ) " & _ "VALUES (" & Me.txtVersion & "", #" & Format(Me.txtVersionDate, "mm/dd/yyyy") & "#", '" & Me.txtWhatsNew & "')" where...

Hi, I need help to modify a code and implement it in my code. I found this а code on Provided by Allen Browne http://allenbrowne.com/AppSearchHighlight.html works great. Мy idea is if I can remove the combobox "cboField", by replacing it with a button "search". In the text field "txtSearchText"...

Hi, everyone! I need help building a query with a column to count the distinct id. What do I mean : That is my first query (Query1): SELECT tbl_Inspections.inspectionDate, tbl_Inspections.employee, tbl_Objects.city, Count(tbl_Inspections.inspction_type) AS CountOfinspction_type...

Hi all. I need some help. How to make that header and Navigation bar in html and css...?

Hello, I have a query in which I want to divide a number from one column into four other columns, i.e. bus stations (100) -> first quarter (25), second quarter (25), third quarter (25), fourth quarter (25)

Happy New Year to all! I wish you all happiness and health! How can I remove that border, which remains around the button is pressed?

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...

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...

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...

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...

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...

I am working on the following problem - I have a main table "tblAnimals" with fields "id" and "TypeOfAnimal". In that field "TypeOfAnimal" I have different types of animals - "dogs" with id 1, "cats" with id 2, etc. Then I have 2 tables of subspecies of these animals - "tblDogsSubspecies"...

Hi, I have 2 tables - tblObjects and tblInspections tblObjects has object_id (primary key) and object_name. tblInspections has inspection_id(INT primary key), inspection_name, inspection_date(Date/Time) and object_id (INT foreign key) I need to build query to show me all objects that DO NOT have...

Hi, I have main form (Single Form - View) with unbound subform (Datasheet View). Тhese two forms are created with the same table. On the main form I have control buttons - "first", "last", "next", etc.. So, I need on the subform be show all entries and when I move previews or next record on the...

Hello, how to disable only "paste" in excel?

HI all, I need to create UNION query in VBA like this: SELECT [Inspector] FROM qryInspectors UNION SELECT Top 1 "- Department DZK -" FROM qryInspectors; Do I have to declare a variable like Dim sSQL As String sSQL = SELECT ....... Then I need to match with combobox like this...

Hi all. I need some help please. I am trying to change Row Source of ombobox depend of function "GetAccessLevel" I have Public Function GetAccessLevel() GetAccessLevel = Nz(DLookup("AccessLevel", "tblUsers", "UserName='" & GetUserName & "'"), 0) End Function and I have...

I need help to calculate a few columns, but I don't know how to do it. So: I have a workbook with 8 sheets - day1, day2, day3, day4, day5, day6, day7 and totalDay. In each sheet I have same table with 6 columns - column1, column2, column3, column4, column5, column6 Cell in each column is List...

Hi everyone, On my unbounded pop up form "frmProducts" I need to write code that when I press Exit button onClick evetn to refer that: If combobox (cboType) on my subform "subfrmPSD" is = "somename" then DoCmd.GoToControl "InspectionTab" ElseIf my subform "subfrmPSD" is = "somename" then...