Search results

(I am working on trying to get the db to where I could share it, but until then I hope the screenshots would help.)

Okay, I am going to walk this back because maybe (read probably) I am going about this all wrong. My form is a split form with a few user-input controls (see attached). My original needs were to show all jobs, filter jobs by date range, filter jobs by source, or filter jobs by date range and...

Would it work if I don't attach the backend? I am not sure how helpful it would be. I tried creating the query with all three (date, jobsource, outside normal work hours) and added the sum with the Totals for that column. This is where I got stuck before. How do I join that total to the query...

Okay so that is how I originally tried this, I made a separate query that selected only the jobs where Tidutanforarbetstid was true, and totalled those jobs. However, when I joined it and ran the report, it showed the total as 75 hours (the current total for all jobs outside of normal working...

Okay now I am just running amok. I usually say I know just enough to be dangerous. This is obviously not working. What have I done? Delimiters are killing me. I tried to separate it out so I could more easily see things (I still can't) I should add that Uppdragsstallare is a dropdown box...

I have an interactive form that creates a report based on criteria input by the user. The user can select a JobSource and a Date Range and the report shows how many hours in total were spent on the jobs that fit those criterion. The report is based on a query with criterion based on the...

I see, yes, we have that for our own inventories. What we deal with in my department is outside the context of those manuals (foreign materials).

Thank you SO MUCH! I cannot begin to tell you how much I appreciate your taking your time to look at this for me. You are right about the autonumber ID field. Many tables were made very early on and I haven't updated them all as switching to an autonumber and changing all related code and forms...

I work in the military actually. I am the one (frightening enough as it sounds) upgrading the old lists to something slightly more usable.

Thank you so much! I am attaching a copy of the backend database. Would you need the front end as well? I am simultaneously excited to hear your input and embarrassed to have you see what I have done as a novice. :) Edit: I should note that there is a big of a language blend here, so there is...

I am trying to work this out in my head and so far I am having little luck and thought perhaps all the geniuses here might have some insight for me. I apologize ahead of time if I supply more information than needed but it does help to talk it out. Thanks for your patience! Short story: I have...

The source of the form is a query, however, I noticed something. Somehow the Control Source on the Country field was from the table, while the row source was still listed as from the query. I have no idea how that happened. But that is the one that "works". As a test, I changed the Control...

Thank you, but it is still behaving the same way. If I quick filter one field, the other fields turn to text filters.

Thank you for your reply. I am a bit unsure what I am supposed to do. I found the "Don't display lists when more than...", which was set to 2,000. But what do you mean by "type as many 9 to the textbox?" My database currently has just over 10,000 records, and the number climbs regularly, so I...

I found another thread about this here, but it unfortunately has not helped me solve this problem. https://www.access-programmers.co.uk/forums/threads/problem-with-datasheet-quick-filters-when-form-record-source-is-sql.255286/ In the datasheet part of the form, some of the text fields show up...

@theDBguy and @MajP Thank you both so much! Those are both very interesting and actually solves another issue that I had with another form so I greatly appreciate it! I am going to try to implement that asap. Like the newbie you mentioned, I also was trying to get the functionality of the...

I have been toying with this concept for days but is there a way to add something like: sWhere = "1=1" If Not IsNull(txtStartDate) Then sWhere = sWhere & " and [Arendedatum] between #" & txtStartDate & "# and #" & txtEndDate & "#" If Not IsNull(cboFilterUppdragsstallare) Then...

Thank you so much! Here is the screenshot and the string that was printed when I selected dates but no Agency: ?sWhere 1=1 and [Arendedatum] between #8/1/2020# and #3/24/2021# Here is the second attempt where I selected Agency and Dates: ?sWhere 1=1 and [Arendedatum] between #8/1/2020# and...

I absolutely want to learn this and get this right, you are so right. I have tried putting the stop on every line in the code just to test it out and literally nothing comes up when I run it. Tell me if I am totally doing this wrong. I put a stop in the code by clicking the grey border which...

I am sorry because I am very much a beginner here but as I wrote earlier today, I followed your instructions and there was NO string to post here. It only said the word True. It is quite possible that I did something wrong, but I have researched and tried and nothing else gave me any string at...