Search results

I typically use the F11 key to open the navigation pane in Access, but Im using someone else's laptop. How to I open a navigation pane thats hidden? Everytime I try to use F11 it adjusts the volume. This is very annoying. I dont want to set it to stay open I just want it to openso i can look at...

At the end of every month I, or someone else now, need to export a query named qMonthEndMaintenanceData to an excel workbook with a tab named qMonthEndMaintenanceData. The Excel file is already located in a folder named for the previous month and workbook named for the month. I can do this in...

So my newest challenge is creating a button from which I can open another application, and then enter a userid and password in the form that pops up for that application. I have an example below of my method to open the application, Im not sure what to do after this. Would this be specific to...

It is February 4 and I am trying to query a table to get all items in my ADDDATE field that have been added in the past three months. When I run this query I get items with an add date all the way back to October. What am I doing wrong? <=DateAdd("m",-3,Date())

Ive been using the same database for quite some time. The only recent change has been that I have code to backup the db on closing. Here's the issue. I have a series of steps (with buttons set up) to import data, analyze data & Export Data. I click on these buttons from a form. The last two days...

Trying to export table. Seems simple enough, but my problem is that the user needs to be able to have a dialogue box that pops up, enabling them to either update the current saved export destination path, or browse to the new location. The table that’s being exported is going to a month end...

I have a list of accounts in an access table, they may include a line with a debit and a line with a credit or a line with more than one of any entry (like maybe 2 debits and a credit all on the same acct). Im trying to identify the items with account numbers that match, and then return them in...

I asked this questio once before, almost 2 years ago to the day. I never got an answer that made much sense and Im back to it again. On the product details form in the Northwind database there is a "Go to Product" box that has the coding below as its row source. I cant make out what the <>Nz...

Goal: Create display field on form showing the current number of items processed this workweek, from TableA.FieldQ Current Situation: I currently have TableA with a field FieldQ, in this field the total items worked are entered each morning. At the end of the day, and week I would like to be...

I am trying to create a query that looks at a table to find the average score for each day. I need to query the table and find the Distinct dates, these could be multiple records with the same date but different scores, and then average the score and end up with my Date & average score for the...

I am trying to perform a variety of things from a VBA module in Access to open an excel workbook and delete a sheet and it doesn't seem to be working. I am using Access and Excel 2013, and am trying to delete a sheet in a workbook. The module runs and gives me the process complete but when I...

I have 3 access queries all of which I would like to export to an excel spreadsheet that has three sheets named for the queries. The VBA I have written exports the data out to the correct sheets, but I would like to add code that will delete the existing data on the three sheets before adding...

I have an access db where I have written code to export the results of three queries to an excel workbook. The workbook will contain, or may contain data from previous exports and I would like to have the new data from my db overwrite the existing data in the workbook. I have used the...

I want to enable people to delete records from a form that I have created. On the form I created a button, using MS Access dummy tools to just delete the record. My problem is that I would like to save a copy of the record to an alternate table with a timestamp and the users id, which I have...

On the product details form in the Northwind database there is a "Go to Product" box that has the coding below as its row source. I cant make out what the <>Nz function is doing here. Could someone please explain this? SELECT [ID], [Product Code], [Product Name], [List Price] FROM Products WHERE...

I have a field expression for a query as follows QR#:[TOTAL*0.02 this this obviously returns 2% of my total field. My desire is to get the number 1 if the result is less than 1. How would I go about this?

So, I have a table with a date column populated as mm/dd/yyyy this table will store rows from dates throughout the year only (meaning at the end of 2017 a new table with 2018 dates will be created). I have a query that I am creating in access from that table (the table is called tTeamScores) and...

I have a form that I have users enter/select information on but I would like to add another feature where they can be provided a comment once they completed their data entry, to paste into an outside application. This comment might say "Ive added this to the Other database". Is there a way I can...

I have a table on which I post the volume of items, total less than 10 days aged and total greater or equal to 10 days for three separate ledgers each day. What I'm trying to do is write a query that looks at this table and returns the total of the three items for the three ledgers combined...

I have the following formula to use in an access report to populate it with the previous business date. What I need to know is where/how to add to this an additional part that also excludes any holidays from a range or separate table. I guess I could place all the dates that I know are holidays...