Search results

hello everyone ! i have a query with sql TRANSFORM First(IIf(r.QResponse=q.CorrectResponse,"✓","✘")) AS ResponseResult SELECT e.TrainingAttendanceID_FK, e.EmployeeID, e.FullName, e.JobTitle, DCount("[EmployeeID]","[Employees]","[EmployeeID]<=" & [e].[EmployeeID]) AS RowNum...

hey guys ! every time i add new employee's data it also saves all SiteTitles (8) times all trainers (3) and i get 24 records. not really sure what i set up incorrectly. i checked everything and nothing found. here is the db. it should open main menu nav. click on "add training". add basic...

hi guys ! my set up: form - frmTrainingPage combo box - cboCustomerName SELECT Customers.CustomerID, Customers.CustomerName FROM Customers ORDER BY Customers.[CustomerID]; combo box - cboSiteTitle SELECT CustomerSite.CustomerSiteID, CustomerSite.SiteTitle FROM CustomerSite WHERE...

hello guys ! im stuck with another issue that i just can't solve. i've tried to google it, youtube it, AI it , but no luck for me. spent like 2 days in a row per 17 hours and 0 success. i have a simple training database where i have training, employee (attendees) trainer and some questions and...

hello guys! i have tables and relationship i have a continuous form where i put group option so a user could input data (response to some question) i have sql of its form SELECT Employees.EmployeeID, Employees.TrainingID, Employees.FullName, Employees.JobTitle...

hey guys, how do i call a query to show me only whose ID from Tmain (parent) that doesn't have any records in Tactions. (child) so i have i tried to set "not equal" but doesn't work. sql SELECT tmain.riskid, Tactions.RiskID, [RiskID]<>[RiskID] AS Expr1 FROM tmain INNER JOIN Tactions ON...

hey guys ! so i have Private Sub CmdMap2_Click() Dim strMessage strMessage = FormattedMsgBox(DLookup("nonEnglishText", "Tmsgbox", "msgID=7") & vbCrLf & vbCrLf & DLookup("nonEnglishText", "Tmsgbox", "msgID=8") & vbCrLf & DLookup("nonEnglishText", "Tmsgbox", "msgID=9") & vbCrLf &...

so i have 2 continues forms and their data source is a crosstab query but one shows locations without specified records and another form - doesnt. this doesn't work for me , as those forms are in my main menu and both located next to each other and location data should be exactly next to...

so i have 2 union queries. 1. SELECT * from qryCountSiteActions UNION Select * from qryCountSiteOverdue UNION Select * from qryCountSiteStatusNew Union Select * from qryCountSiteStatusInProgress UNION Select * from qryCountSiteStatusCompleted ORDER BY 1, 3; 2. SELECT * from...

i would really like to take a minute and honorably thank @MajP this man has helped me so much. i would like to ask AWF reps to give him some kinda MVP. well , if u have such though :) thank you VERY MUCH @MajP. hats off. wish u good health to you and your family. there are so many amazing ppl...

hey guys, hope u r doing well today. i have a vba code with dialog pop up like If Me.DueDate < Date Then rtn = MsgBox("Due date is in the past. Verify this is correct. If correct select OK if not select CANCEL", vbOKCancel, "Verify Date") so i created a table how do i vlookup...

hey guys, do u have any simple ideas \ solutions that record every changes* made by anyone ? no admin \ users log in system required. like it does it automatically ActionLOG table 1. [tablename][filedname][recordID] changed from X to Y or something like it upd: *im looking to track changes...

hey guys, i read and tried myself that its not possible to bring any objects to front over subform. MAYBE there is a way to do it. ...

hey guys, i almost finished my db, extracting all attachments out of db, making it lose from 200Mb down to 21Mb and it thought its gonna be much smother, but i was wrong. i dont remember, but someone here told me that im gonna face with similar problems. so my db is 21Mb. network works fine. up...

hey guys, i was just trying to play with vba, to see if i can code something at least. might take it as a basic vba lesson :) i wanted to add some OK CANCEL confirmation before delete action. but something went wrong :) Dim DelPic As String DelPic = Me.picafter1filepath If...

hey guys, im literally at final stage to run my db at work network, but the folder which my db is gonna be placed has non-english directory letters and looks like vba doesn't like it much is there a way to fix it ? i need russian letters.

hey guys, i can't figure it out how to set a criteria for subtable if all related records will be with lets say status "completed" 2 example: main table: ID ------Isactive 1 --------true sub table ID--------status 1 ---- in progress 2 ---- completed main table: ID -----Isactive 2...

hey guys, i split my db so i have now 2 db 1. tables only 2. forms, queries, reports and links to tables. then having #2 opened , i go and save as but it says... why ?

hey guys, it didn't take long until i face with another problem for me lol i have a Continuous Forms and Attachment as field type, but now im in a process of switching to storing pic outside of db. so im gonna need to remove attachments soon and .... my Image Object type which does its job...

hey guys, is there a way to code on click event to refresh (F5) current form ? sorry for simple question, couldn't find on the internet.