Search results

hello everyone ! i have a double click event where it opens up for me a master list. i tried this one ="RiskID In(SELECT RiskID FROM QddallA WHERE Site='site1' and duedate<date() and isactive=false and status='In progress' or 'New' and duedate<date() and isactive=false)" and this one ="RiskID...

hey guys, i face with another problem. in my countinius form i have riskcode textbox bound to Tmain!Riskcode. Its numeric only from 1 to 25. every code has sovernity \ likehood code (identifier) for example riskcode 1 = 1A .... riskcode 7 = 3A .... i put unbound textbox that should display this...

hello everyone here :) do u have any form filter \ sort templates ? i have a continuous form and i would like filter some one the fields by drop down list (combo-box). looking for a simple solution in google as well.

hello everyone. Im moving forward , just solved my issue with your help of course and i face with another issue i can't figure it out myself, so please help. i have a 2 tables (one to many). 1 record (risk) has many actions. i have a dashboard with my statistics in countrol source of these i...

hello everyone. i can't figure it out how to set formula so it opens up a form with new record. this doesn't work i have done it so far via on click event but i dont like it as it opens it up in a seperate window where as navigation form opens it in build in window, but ID=1 set by...

hey guys ! i have a form and in this form a have a textbox where it gets date by Expr (calculated date) and i need to save this data (date) to one of my field of table. i tried to play with VBA , Private Sub Text63_BeforeUpdate(Cancel As Integer) dueDate = Me.Text63 End Sub but it doesnt work...

hello guys :) and im here today with i think easy question for pro-access users here. i have 1main table and 1 sub table (one to many) main table has general info. sub table has few records per 1 record from main table. all focus to date field in sub table. how do i return min. date into main...

hello everyone ! hope u guys r doing well today ! i have a question that i couldn't find any answers for even in google. is there any way or is it technically possible to create some kinda heatmap. imagine i have a jpeg uploaded in database. and i have a records. is there a way to store a...

i have a main table with one of the 2 data type when i add these 2 fields into a form, one of these 2 acts very wierd for me. it adds "FileData" into a countrol source without me wanting it. when i manually go to change countrol sourse it already set *FileData to it. and chaning it...

Hey guys, im stucked with Dcount. i have 2 questions how do u return all values in certain filed. ? i was using =Nz(DCount("riskcode";"Tmain";"riskcode = '1'");0)+ =Nz(DCount("riskcode";"Tmain";"riskcode = '2'");0) but how do u return any values (like there is no criteria). i was trying to use...

Hey guys ! i have difficalties with DCount. it says Invalid syntax. im trying to count how many records i have using 2 criteria in 2 fileds - status1 and status2. =Nz(DCount("status1";"Form";"status1='" & "rejected" & "' and "status2"="new'");0) please help me out...

hey, guys ! hello everyone. im exited to join u here. i love Access and work with it in my personal life and mostly for my work. i dont have VBA or SQL programming skills. my level is - decent enough to make a good excel spreadsheets. so i very often face with lots of issues in my Access db...