Search results

Hello - I have the following SQL in a query... SELECT qryFlashHoursRP.WorkDate, qryFlashHoursRP.WeekEnding, qryFlashHoursRP.ReportOrder, qryFlashHoursRP.WorkCategorySubGrouping, qryFlashHoursRP.Hours, qryAdditionalGenOpsHours.AdditionalHours, Nz([Hours])+Nz([AdditionalHours]) AS RPHours FROM...

Hello - I feel like I should know how to do this but can't seem to figure it out. :banghead: I have two fields in a query "Goal Time" and "Actual Time". They are imported from an Excel spreadsheet and the imported data type is short text. The data in these fields is equal to the...

Hello - I have three separate databases that are all linked to each other and that are all used by multiple users. We have been using them for several years without any real issues. However, my company recently started updating PCs from Windows 7 to Windows 10. As they rolled out PCs with...

Hello all - The past few weeks we have been seeing a couple error messages on three databases that are linked together. The message is either "Unrecognizable Database Format" or that the database is in an "inconsistent state". It happens on all three databases but not all at the same time...

Hello - I have a table that has fields named Category, SubCategory1 and SubCategory2. I would like to create a query that will select the top three values in each of these fields (i.e. The top three categories are X, Y, Z. Of X, Y, Z: A, B, C are the top three subcategory1's. And finally...

Hello - I have a field called ScheduledDepart that is a General Date format. I have a second field called ScheduledDepartWithCushion that is a calculated General Date formatted field that adds 1 hour to the Scheduled Depart field. When the calculated field has a time of midnight the time...

Hello - I am using Access 2010 and have a report that uses the following query: SELECT t.CountOfCategory, t.Category, t.CountOfDescription, t.Description FROM qryTopThreeCategoryBehaviors AS t WHERE (((t.Description) In (SELECT TOP 3 Description FROM qryTopThreeCategoryBehaviors WHERE...

Hello - I am wondering if it is possible to create running sums across two different groups on the same report. I have a report in which I would like the tote cube column to increase as picks are added and the module cube column to decrease as picks are added. I do want the running sum for...

Hello everyone! I am wondering if it's possible to have a running total either in a query or using the Running Sum function on a text box on a report that will reset after a specific value. Here is what I would like to have happen: The RunningTotalCube field to reset when it has reach...

Hi everyone - I have posted this issue on this forum in the past so I apologize for posting it again but I have not found a solution and am getting to a point that I have to roll out this database and I need to get this resolved. My issue is when there are 4 records (store numbers) for any...

Hi everyone - I have the following code in a module to set certain formatting properties when exporting an Access 2010 query to Excel: With xlApp .Application.Sheets("Spoilage").Select .Application.Cells.Select .Application.Selection.ClearFormats .Application.Range("A1:K1").Select...

Hi everyone - I was able to find a snippet of code online that did what I wanted (entering blank lines on a report) and was able to adapt it to suit my needs. Here is the code I am using: Function SetCount(R As Report) TotCount = 0 R![RowNumber].Visible = True R![Position].Visible = True...

Hi again everyone - I have racked my brain for days on this problem and cannot see where I am going wrong. Hopefully someone will be able to help... I am attaching a sample database to this post because I think it would be easier to see it and be able to move through it than for me to post...

Hi Everyone! I have the following in a query to assign a sequence number to each record: (SELECT Count(*) FROM [qryPTLActivity] AS T WHERE T.EmployeeID=[qryPTLActivity].[EmployeeID] AND T.PickDateTime <= [qryPTLActivity].[PickDateTime] AND T.PickAisle=[qryPTLActivity].[PickAisle]) I have...

Does anyone know if it's possible to have the user enter the number of top records to choose in a query? I know that you can enter a number or percentage in the Top Values property of the query but I would like the user to be able to enter this number each time they run the query since it may...

Hello Everyone! I have seen many posts regarding how to turn on double-sided printing through code but I actually have the opposite problem and I can't find any solutions that have worked. In order to be as green as possible, our printers are set up for duplex printing. I have an Access...

Hi everyone - I have the following in the RowSource of a list box: SELECT Period FROM qryFiscalPds UNION SELECT "*" FROM qryFiscalPds Period is a numeric field and sorts perfect in qryFiscalPds but when I use the line above in the list box it sorts like this: * 1 10 11 12 13 2 3 I...

Hi Everyone - I have a form (frmAuditEntry) that includes a subform (sfrmAuditDetail). The user will enter audit information on the subform. There is a check box on the subform to identify containers that had errors in selection. When the box is check by the user, a pop up form opens where...

Hello everyone - I have a form which contains a subform. On this subform, the user will enter several lines of container ID numbers. If one of these containers has errors, they check a yes/no box and a pop up form opens for them to enter the details of the errors. I want two fields that...

Hi everyone - I have a .mdb database that is suddenly having issues running macros. Users of this database are on two different versions of Access (2007 and 2010). Everything was running fine for users in both versions until a couple days ago. Now, users with 2007 cannot run the macro and...