Search results

Ok this should work better. Wasn't too sure on how to set things up so as to get the results needed. I gave this a dry run on another work PC and it seemed to produce the same results.

Here is the downsized version with everything you need. Part of the report gets information from who the person is logging in. I don't know how to set it up to work off of a non work pc. My best suggestion would be to add a record to the CrouseHindsPersonalTable. The location of where that...

So beside the Qualifying that is already stated is it possible to qualify them further? Also Order and Filter have nothing on them they are blank properties. As far as Group and Sort are you suggestion I use that or asking what I am doing with that? If its the later, until you mentioned it I...

Yes the Tech DLookup will only ever return one record. You know what I think I was over thinking this whole section. If I generate a query that only returns TRNumbers that are related to that user, then use the combo box as the criteria to see if that number matches any of the results. That...

As far as I can tell I did that in both the SQL and in the Report. Though FullName isn't used in multiple tables as much as the key is in multiple tables. The query itself works. It returns all the values I would need for the report to be generated. Somehow the report gets hung up on something...

I have a report that pulls information from 8 tables. The query behind the report generates all of the required information I am looking for. Though when I go to open the report it says that a table could refrer to more than one table listed in the FROM clause of your SQL statement. The only...

Ok I think I understand what you mean about the DCount and Recordset being redundant. May take some working with to fully understand. The DLook up used for the Tech at that point may or may not return any records. That is what I am trying to assertain. Either way I am still having a problem with...

I understand that the nomatch would show if nothing shows up for the recordset but I am acutally looking for two different things. The fist part where I have the DCount is to see if any TRNumbers match the drop down menu. If there is I want the next query run but to see if any records returned...

PrepStartDateBlankQuery is based on a table called FinishedTestRequestsTable and UserReportsComboQuery is also based on the same table, but I has the related table of BuisnessNameEmployeeTable.

I am having a problem with retrieving the information I am looking for. Basically I am checking to see if a user has selected a TRNumber from a drop down menu and if that TRNumber matches any other records in the table in that field. If it does, is that Number already associated with the user...

Never mind solved the issue. Turns out the user never filled all fields out on his personnel information and that was causing some buggyness.

I have a form with a button that exports a report to the server as a PDF. If all fields aren't filled out the report is essentially blank. All the labels are present just none of the information is there. This works wonderfully and has for some time. Today a user had an issue(unrelated to this)...

@CJ_London I don't have an actual query for the recordsource of the form, though I am sure I could just put in the SQL in with my VBA. My reasoning for not, please let me know if I am doing something wrong, is that sometimes not all of the information has been entered into the record. Users have...

I am familiar with using the cascading combo box effect as it is implemented on my form in two sections. I have a harder time back filling the information though. The last combo box contains the foreign key that is saved in my main table. I will have to look into redesigning my whole form if I...

@pbaldy I think you nailed it. In the query I reference a text box on the open form so I know which records to pull. I won't know till I am work tomorrow. @vbainet, I do tie the text boxes into the combo box, I set the after update properties of the combo box. I will have to play around with...

The information that is being displayed on the form from other tables isn't information that is doing anything more than just being viewed. As an example, I have a field called CatalogNumber. A user selects a number from the drop down menu and and the next three fields autopopulate with...

I have tried on different forms using more than a few different methods to make recordsets happen and to no avail. My current reason for needing to use recordsets is because I am loading a form with information from different tables. Instead of using multiple DLookups, opening the recordset only...

I changed the code to add in the Execute instead of the RunSQL. Thank you for your patience and your assistance in helping me get through this.

Ok so I ran with all you have said and put this together and it seems to work. Here is the final code. If IsNull(Me.GoingToCal) Then MsgBox "You have not selected any items in the equipment list. Please select the items used before continuing.", vbExclamation Exit Sub Else For Each...

Sorry I haven't gotten back, didn't get much of a chance to work on things till today. I changed the final CalEquipment to = "IN" & "(" & Left(CalEquipment, Len(CalEquipment) - 1) & ")" which after doing the Debug.Print I got the desired IN(177,173,17,75)