Search results

Dear all, After putting in fields there were checkboxes into a Union Query, they now show up as -1s and 0s. Is a -1 a blank, and a 0 checked? Thanks, Bill

Yes, CreateDefaultDepartments is the custom Sub that I am executing. Sorry for not mentioning that explicitly. Your code works! Thank you! I knew this shouldn't be too difficult! Sincerely, Bill

Thanks for your reply. I looked up the link and created the following code, but I am still getting an error: Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("Area") With rs .FindFirst "PlantProgramID = " & iPlantProgram Do While rs.EOF = False...

Thank you I will try that!

Dear all, I need a little assistance on creating a small loop to run code. This should be relatively simple, but I'm just not thinking of it properly. It should go something like this. For each record from AREA with PLANTPROGRAMID = VARIABLE Then (execute code here) Next record In this...

Dear all, I have form in which I modified the record source to include another table. Because I did that, the code no longer recognizes my combo box, Plant_Combo. See below. DoCmd.RunSQL "INSERT INTO Plant_Program (PlantID, ProgramID) VALUES (" & Me.Plant_Combo & "," & Me.ProgramID & ")"...

Hi David, Thanks for the tip. Unfortunately, that method still is incapable of closing it. My code is as follows: Sub test30() Dim Source1 As String Dim ExlObj As Object Source1 = FilePath(CurrentProject.FullName) & "Resources\HPUCPUDataEntry.xlsm" Set ExlObj =...

Thanks for your replies. I tried wb.close, but it's possible that there are other instances of excel that are already open. If so, that code doesn't do anything. I checked up on GetObject, but I'm not sure how to close the workbook I get from GetObject. My code is as follows: Sub test30()...

Dear all, I apologize for the thread. I have looked up similar threads, but am still having trouble. Any help would be appreciated. This VBA Code is being executed from Access. I am trying to make a code to check if an Excel workbook is open and if it is open, to close the workbook. The...

I just need a way to be able to easily tell when someone is typing if there is already a similar issue for that problem. That way I can just mark the issue as an incident of one problem.

Dear all, I run a database for defect detail, tracking, and resolution. Often times we have the same type of defect occur multiple times before the problem is resolved. Currently the process is that every time a defect occurs, it gets entered into the database, and whenever it gets solved...

I ended up finding a solution. Unfortunately, it meant that I now have 3 queries. SELECT qrySustainingEngNotFixed1.Department, qrySustainingEngNotFixed2.TotalNotFixed FROM qrySustainingEngNotFixed2, qrySustainingEngNotFixed1 GROUP BY qrySustainingEngNotFixed1.Department...

Dear all, I am trying to create a clean database and code to generate a report. Your assistance would be much appreciated. I am trying to count the number of null fields in one of my queries: However, because of this expression, I cannot carry other fields with it. So the end result looks...

Thank you both for your replies. I see that I am not alone in this desire. I found similar threads: http://www.access-programmers.co.uk/forums/showthread.php?t=59123 http://www.access-programmers.co.uk/forums/showthread.php?t=147352 I found that I could create a command button for users to...

Dear all, I have a database that consists of linked excel tables. I derive reports from these linked excel tables. I routinely have multiple people in my company open up these reports but only one person can be in there at a time; I would really like any number of users to be able to get in...

Dear all, I want to make a simple FrontEnd for my database for users to open reports to print them. I don't want them to mess with the linked tables or queries feeding into those reports. I want the front end to display a list of every report in the database that they can load up and use...

Query changed to Min Thanks! --Bill

Thank you very much plog. Your suggestion to use First Worked! Now I have the unique set of data I was craving. You helped greatly, Bill

I have a year Field as well. For the moment January 2013 is not an issue, I'm compiling data for 2012. Thanks, Bill

Dear all, I have a slightly complicated set of data that I have to be careful to correctly extract. Any help on making this simpler would be appreciated. I have a field called Claim # and another field called Month and another field called Quantity. A Claim will appear only 1 time in any...