Search results

I am looking for a break down of how the double quotes work in the following from Allen Brown http://allenbrowne.com/casu-17.html : If you wanted to look up the city for the CompanyName in your form, you need to close the quote and concatenate that name into the string...

I have a small database that is split and used by 25 users. The users are in 5 different cities, in two states. Currently the BE is on a server and each user has a copy of the FE on there own PC. I've been looking into converting the Access DB to a web application. My reason for possibly...

Thanks guys for your great help. I managed to get the outcome I need by using your suggestions. I added to the query that feeds the report, the following two expressions: 1. ProjectPriority1: Nz([ProjectPriority],"NP") 2. sortorder: IIf([ProjectPriority] Is...

Right now I have it set up this way: Running the report gives the following where the Project Priority is the second column from the left: As you can see, the letters "OBL" are coming before the numbers 1,2,3, etc. Any ideas how to change that easily?

Unless you include in the report a Sort By 1expr in the report. Right?

I have a report that I want sorted by a text field called [ProjectPriority]. The field can be null, a number or text. If it is null, I want the field to read "NP" for No Priority. If it is "OBL" then read "OBL". The field is set to "OBL" once a award date for the contract is entered. OBL...

Thanks Pat!! I was stuck on that. I used the alternative and in 3 seconds the problem is solved. Appreciate your time.

I have query that was working fine until the GrandTotal number went beyond 100. The query is meant to sort projects by their CustomNumberForOrdering but, at the same time showing the decreasing Balance and increasing RunTotal for each project. SQL expression for CustomNumberForOrdering is...

Using 2016. I was using 2019 but when I decided to encrypt the back ends of a couple database, I ran into trouble. Not all users had 2019 and thus did not have 64 bit encryption. So now I’m back to 2016 with 32 bit encryption. That’ll probably start another topic I suppose.

Found it! And now it works.

Here's my code. This is from an online class I'm taking through udemy. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) On Error GoTo ErrHandler 'Private is it only works here. 'KeyCode and Shift are buckets to hold values Dim ctl As Control Dim fldName As String Dim rst As...

Neither one is working. With either the DAO.Recordset or the ADO.Recordset, it throws an Compile error: User-defined type not defined. To add them, I would look in Tools/References correct? I do not see either but, I'm not exactly sure what I'm looking for.

I'm trying to learn about RecordSets. When declaring a rst as a RecordSet, it does not show up in the dropdown. Why is that?

And indexing is just done in the table, per field, by setting the indexing field? With the exception of auto numbers, do you normally choose to index with Yes (duplicates ok)?

Oh…so much faster! I’ve been a little scared to dig into using the SQL view for queries, so this really helped me get introduced to it. Not as scary as it first appeared. Thanks to you guys.

Ok, I found it. Need to add a "=". (...A.CustomNumberForOrdering<=B.CustomNumberForOrdering...) SELECT [A].CustomNumberForOrdering, CCur([A].[MajorM&IFundTotal]+[A].[BEMARFund]-Sum([B].[TotalPoolRequest])) AS Balance, CCur(Sum([B].[TotalPoolRequest])) AS RunTotal, Count([B].[ProjectID]) AS...

As I look at this query more closely it's not working right. There should be 59 projects but the query shows 58. The highest scoring project, which happens to be ProjectID 1, is missing. ProjectTitle "Replace Generators & ATSs" for $750,000. But notice the RunTotal is counting it. ?? Below is...

Thank you for the explanation. That helps.

Oh my... that's embarrassing. I know exactly why. Thank you! That change speeds it way up! Queries are still the most puzzling to me. They seem so easy but there are more things ways to develop them then you can count. I need to learn more!! I certainly do not understand this non-standard...

CJ, I copied and pasted into a new query, but it gives the following error. What I'm I doing wrong?