Search results

MarkK, All my field names are fields in the tables that make up the query. Now not all of the fields have a value in them when the query is run. That is to be expected for some records while others will be fully populated. As I said the query does return a single record as I want it to do, just...

I am currently working on enhancing my database at work. I am trying to open up a recordset. The problem is that I get an error that says too few parameters expected. I am using a query as the recordset and it does return the one record that I want it to return. The recordset though doesn't seem...

I got the query working. I changed the Count for Sum and it gave the desired results. TRANSFORM Sum(DateDiff("d",[PrepStartDate],[ResultsDate])) AS CatalogNumber SELECT "Days on Products" AS Title FROM (TestRequestTable INNER JOIN FinishedTestRequestTable ON TestRequestTable.FinishedRelateField...

Ok So I admit when it comes to crosstab queries I am pretty much clueless. I have gotten a few to work in the past and have a general idea of the mechanics. That being said, I am trying to pull some metrics for the year from the database I designed. What I am attempting to do with this...

I have been using different methods to make sure there is never a duplicate record. I recently changed how my form works. I used to manually update the form and run a delete query when exiting out of the form or access. It wasn't a full proof method, sometimes one would slip through. Friday when...

So I have a bit of an interesting situation. I created a database to track test requests from engineers. They fill out a form and things work from there. Well to increase the speed of them inputting requests, because some are virtually the same, with the exception of one item, I use a a copy...

Another idea may even be instead of worrying about what day the classes were on is to just keep track of the classes that were attended and in the tables with the class information have how much each class is. You could get into more complicated matters to include keeping track of the number of...

At this time there isn't anything in the Input Mask of the date field. It seems to work initially. It just seems to stop working unless the end user quites out and goes back in. Users can close the form and go back in and it isn't guaranteed to work either. I don't get any runtime errors or...

I am running into an issue with the date picker(the little calander that pops up next to the text field). I am using Access 2010, the field is set to date/time. The problem is that users suddenly can't use the picker. They can type dates into the field and it works. Just looking for any ideas as...

@JDRaw, I thought that by having Email_Subject, Email_From as string made all variables strings. If that is not the case please let me know. I haven't run into any problems with that code yet and rather not run into any. I use it twice in with my email section inside of the loop...

Ok so I got it working once than I added in an extra SQL statement and it stopped working again. Not sure why it wont go to the next record when I use .MoveNext. Here is my code as it is. Dim FSO As Object Dim FromPath As String Dim FromPathCheck As String Dim ToPath As String Dim...

Pr2-eugin, Would I need the criteria if the query automatically gives me all of the results that I am looking for? The query is just two fields one that is the autonumber, the other is a number that I use here. The two bits of criteria I used in the query check if one field is true and...

I am working on setting up a loop that will get information from a query. I can handle the rest of the code once I get the primary piece of information. Which at this point I can not get. I am trying to get to the next record of my query. For some reason I am stuck on just the first record and...

I can't thank you enough for all of your help. I feel like I have taken a huge step forward. I had plans of reorganizing my code and optimizing my queries. This will make my improvements that much better. I am looking forward to implementing all I have learned.

Ok I understand now what you are saying about that Dlookup and totally agree. Maybe my other question was poorly stated, as I don't usually have multiple records, how would I return multiple files from a single record using a single Dlookup as you mentioned is possible earlier?

I guess to try and answer your question about the Dlookup which I guess I have poorly tried to answer is that I am merely getting multiple values from the same record. The reason I have no criteria is because the query returns only one record. Sadly I have become very good at reinventing the...

Yes all of my variables are defined. I am no where near great with programming and wouldn’t be surprised if I am over engineering a lot of stuff. I did change out Tech to be Tech = Me.TestTechnician a field that is on the form I have. I use a lot of queries because I am still learning SQL and...

Ok finally got a chance to implement the changes I needed to get the results I wanted. Here is the final code, mind you that I went around the need for a recordset by building a better query. Tech = DLookup("ID", "UserNameQuery") MsgStr = "Another Technician has put a start date on this test...

Ok got the freport to open up. Made a sub report that gets just the submitters name of the request and put that into the main report. It is working like a charm.

So how would you recommend doing that then? The problem is I need the FullName of two records because two bits of information are required.