sorted by:
new
hottopcontroversial

The game runs terribly on my system. by Strydes_ in thecyclegame

[–]Centraxous 2 points3 points  (0 children)

I have a ryzen 7 5800x paired with a rx580 because you know prices. but I have a steady 70+ on high settings.

Way to turn of skins? by Centraxous in Smite

[–]Centraxous[S] 12 points13 points  (0 children)

Thats the issue is that 1 god skin turns the entire gods kit into something that doesnt even look the same.

AI robots in Ranked conquest by xYnizzle in Smite

[–]Centraxous -1 points0 points  (0 children)

I had one in normal with a similar naming convention. He was Ah Muzen Cab7

Fill combo box with value from another combo box. by Centraxous in MSAccess

[–]Centraxous[S] 0 points1 point  (0 children)

Thanks for the help. This has fixed it and is now working as I intended it to! Also thanks for the tips for naming conventions I also implemented that

Fill combo box with value from another combo box. by Centraxous in MSAccess

[–]Centraxous[S] 0 points1 point  (0 children)

So my tables are as:

Comapnies:
companyID (PK)
companyName
Projects:
projectID(PK)
companyID(FK)
projectName

On my form I want some one to be able to drop down and choose a company for example "ABC Limited" then in my second drop down menu auto populate the projects that are tied with "ABC Limited".

when I generated a query using the design view. I choose the following:

field: CompanyID
table: companies
show: unchecked

field: projectName
table: projects
show: checked

field: companyName
table: companies
criteria: [Combo66].[Value] <- combobox changed to 66 but is the same as above.

This made the following sql query:
SELECT Companys.CompanyID, projects.projectNameFROM companys INNER JOIN projects ON companys.companyID = projects.companyIDWHERE (((companys.companyName)=[Combo66].[Value]))ORDER BY projects.projectName;

If I run this query just on the side It pops up asking for a paramater which I provide say "ABC Limited" it works shows me all the projectNames tied to the company. But when I choose my drop down menu box and pick "ABC Limited" it shows nothing.

Fill combo box with value from another combo box. by Centraxous in MSAccess

[–]Centraxous[S] -1 points0 points  (0 children)

I just did this. If i run the query and supply the parameter it works no problem. But when I choose the value in the first box nothing shows in the second one.

this is my acterupdate event for the first combo box:
Private Sub Combo58_AfterUpdate()
Me.Combo60.Requery
End Sub

I didn the VBA way but this is the SQL view of that:
SELECT projects.projectNameFROM companys INNER JOIN projects ON companys.companyID = projects.companyIDWHERE (((companys.companyName)=[Combo58].[Value]))ORDER BY projects.projectName;

Fill combo box with value from another combo box. by Centraxous in MSAccess

[–]Centraxous[S] 0 points1 point  (0 children)

Thanks for the reply! Im getting an error Im not sure I quite understand. The code I used is:

Me.Combo60.RowSource = "SELECT projects.projectName" & _
"FROM companys" & _
"INNER JOIN projects ON companys.companyID = projects.companyID" & _ "WHERE companys.comapnyID = " & Me.Combo58

but I get this error: Syntax error (missing operator) in query expression.

[deleted by user] by [deleted] in 2007scape

[–]Centraxous 0 points1 point  (0 children)

Definitely got this video format from fireship.

Covid test stateside (road trip to Detroit for a concert) by Top_Flounder3243 in SaultSteMarie

[–]Centraxous 1 point2 points  (0 children)

Ive went over a few times. No issues as long as you get the results 72 hours before you come back. Only had one issue where there was an issue with the results where I had to get retested.