Search results

I appreciate the visual and renaming. The 4th record without a duedate puts #Type!, I don't foresee this ever coming up, but could we add "No Date" if "" Other than that, I thank you all for the efforts.

That make sense. I will have a text box set to unbound to display the calculated status, for the sake of it I will call the label [CalculatedStatus] and the text box field [Text45]. I will just disable the unbound control so the user cannot interact with it. This will also allow the user to...

As I mentioned in the beginning, the Status can be manually updated. So I am working on calculated fields with manual entries. That's why I'm having trouble understanding the passing of values from unbound to the table when the user selects completed or review as a status.

I'm sorry for asking so many questions, but I'm trying to think of how the user will interact with this. So you want me to change Me.Status to my unbound Me.Text45? If I do this on my display form, it changes every record to that update. And if the user wants to update to "Completed", how...

CazB, Thank you for the response, and that makes sense. Three things. 1. I want it to loop through all the records, not just the current. I created the test database/button for example purposes. I'd really like to launch on form load/current. Is this possible to loop through all records? 2...

That eliminated the error but nothing is happening. Based on the code, what will happen if [DueDate] is blank? Here is the coding and attached database. Function: Option Compare Database Option Explicit Public Function get_Status(in_rd As Date, in_dd As Date, in_s) ' determines Actual...

Passing the var I would just put it like this, no? Private Sub Command40_Click() Call get_Status(RequestDate, DueDate, Status) End Sub When I do, it keeps saying Invalid Use of Null. If I manually give each a status, no error.

Thank you for the feedback. I decided to create a sample db to test the information until I return back to work. When attempting to call the function i get a Compile Error, Argument not optional. Based on the sample database provided (both formats), can you point me in the right direction.

This is great. I added the additional values at the bottom. If the value is null, Id like "Enter Date" to the value. Question: you mentioned earlier to not store the values, which i normally dont, but because the user defines the value in some cases, I should continue to store it, right? Where...

I am horrible with functions, and I cannot wrap my mind around this. Could you assist. Option Compare Database Public Function get_Status(RequestDate As Date, DueDate As Date) As Boolean On Error GoTo Err_Execute Set db = CurrentDb() Set rstsource = db.OpenRecordset("tblIssues"...

I've been playing with some sample code but having a difficult time with the information I am trying to capture as listed above. My pdf is 2 page, with multiple fields. Any recommendations? http://www.eileenslounge.com/viewtopic.php?f=30&t=5907 Public Function...

Through searching, I have seen a lot of post regarding 3rd party downloads to extract pdf data to a table, has anyone developed coding or a sample database that doesn’t require 3rd software? I found a site that does the opposite, but wondering if it could be reversed engineered. In the end, I...

Thank you for the response. The only reason I was storing the value was because of the manual selections on either "Review" or "Completed". A user would have to determine this, rather than a query. But you are saying run my Expr1 in the function, looking for either of the manual selections above...

Main question: Would I use an update query or function to complete my task? Task: Automatically update [Status] based on DateDiff calculation of [RequestDate] and [DueDate] Issue: [Status] can be one of 6 values, the user can manually select Review or Completed. [Status] values: Review...

The database is from the Microsoft main site here: http://office.microsoft.com/en-us/templates/results.aspx?qu=issues&ex=2&av=all#ai:TC001225348|| I tried your solution before, the appropriate boxes were checked. Any other suggestions?

Good morning, I have a question about an Issues template database provided. I’m not sure why I haven’t been able to grasp the idea, but there is a query labeled “Issues Chart Source,” that is referencing two queries and a table. The two queries are “Contacts_OpenedBy” and “Contacts_AssignedTo”...

Good afternoon, I am building a code via sharepoint that follows the lines of ms excel. 1st Code =DATEDIF([EOD Date],Today,"y")&" years, "&DATEDIF([EOD Date],Today,"ym")&" months, "&DATEDIF([EOD Date],Today,"md")&" days" -In my first calculation, if [EOD Date] is blank, it will return...

When I run the reports seperately, they work fine. When I add both reports to a new report as subreports, it will only print M1 and then a blank sheet. It isn't until all of M1's records are completed where it will run M2. How can I have it collate where it prints record A001 on M1, then A001...

Between a few queries, some coding, and a form...I was able to get the actual results I wanted, which in the end was 31 lines to display on the form. The query produces results up to 124 individual line items for a single vehicleID, just in case, even if the fuel entries for the vehicleid do not...

Thank you for your feedback… Let me attempt to work on your suggestion before posting my DB. The only issue about it writing to the table immediately is that if a user decides they want to cancel the bag before finishing, the changes have already been made to the table where as the temp table...