Search results

i dont know even what that it .. so :) my db will be located in local storage and up to 50 ppl will be using it via local network. 1-2 might be simonteniulsly.

i have an error i guess. not sure what i did wrong Private Sub Form_Current() Select Case [RiskCode] Case 1: txtb = "1A" Case 2: txtb = "1B" Case 3: txtb = "1C" Case 4: txtb = "2A" Case 5: txtb = "2B" Case 6: txtb = "2C" Case 7: txtb = "3A" Case 8: txtb = "1D"...

damn, and i just love my work. and yours as well as u guys helped me a lot with my project

and i have almost finished db (just polishing before it goes live) and there are tons of dcount and dbl click events. every cells has them

i have 25 bottons and user should just click on one of these while registring new risk. and I made info from buttons goes to Tmain!RiskCode , but not with Sivernity Likehood ID (like 1A or 2D) but numbers from 1 to 25. why ? cause i knew i will need tons of calculations later like IIF( bla...

i have 4 records and everyone of them has riskcode value. i already faced with this problem a month ago , when i put long code to control source. access doesn't like it.

hmm.. yeah, might be the case. thank you.

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

thank you for suggestion. i'll try to find something for me next week. i appriciated your help !

the reason i had to remove it , cause it gave me an error i he i hear ya :) what could u suggest for me as a person who knows only excel formulas well ... : ) so i can code in sql and vba ?

thank u very much, @mike60smart i had to remove this code Private Sub Form_Load() 10 On Error GoTo Form_Load_Error 20 DoCmd.Maximize 30 On Error GoTo 0 40 Exit Sub Form_Load_Error: 50 MsgBox "Error " & Err.Number & " (" & Err.Description & ") in...

hey @mike60smart, thank u very much for help is there a way to make the same, but in continiuse form instead of slip one and put it the filter to form header ? i switch it to continiuse form and it stops working

done. please have a look.

did the same as u suggest it SELECT LocationID, Location FROM TLocations ORDER BY Location; Option Compare Database Option Explicit Private Sub cbolocation_AfterUpdate() Dim strFilter As String If Me.cbolocation <> "" Then strFilter = "location = " & Me.cbolocation End If Me.Filter =...

that gets me even more wierd as i dont see here any IDs. its only data from Tlocation table from Location field. in dropdown list there are site # 1 , 4 , 5 etc

yes, with primary key

wierd. i removed current combo box and created a new one where i dont even drag locationID anywhere so now i have combo box row source SELECT [Tlocations].[LocationID], [Tlocations].[Location] FROM Tlocations ORDER BY [Location]; form record source SELECT Tmain.[RiskID]...

it was row source of combo box named cbolocation its SELECT [Tlocations].[LocationID], [Tlocations].[Location] FROM Tlocations ORDER BY [LocationID]; record source of mainform itself named FmasterList is SELECT Tmain.[RiskID], Tmain.RiskCode, Tmain.riskTitle, Tmain.isActive...

upd: Private Sub cbolocation_AfterUpdate() Dim strFilter As String If Me.cbolocation <> "" Then strFilter = "location = " & Me.cbolocation End If Me.Filter = strFilter Me.FilterOn = True End Sub @June7 suggest me to remove column(0). i removed it says was not found , but i filter the...

in sql view its SELECT Tmain.RiskID, Tmain.RiskCode, Tmain.riskTitle, Tmain.isActive, Tmain.RiskdueDate, Tmain.RiskDate, Tmain.location, Tmain.locationPricies, Tmain.risktype, Tmain.riskcolor, Tmain.reporter, Tmain.picafter, Tmain.picbefore FROM Tmain; yes short text