Search results

I not having any luck with that.

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...

Thank you for helping

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...

Thank you both. I think I see whats going on now. I guess I dont understand what would happen if the entire where clause were left out of that statement.

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...

That actually gave me a pop up box prompting me to enter a parameter value for vbMonday

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...

Sorry I wanted to post my example a bit different DATE SCORE 8/1/18 95.60 8/2/18 93.95 8/1/18 86.32 8/1/18 75.90 RESULT: DATE SCORE 8/1/18 85.94 8/2/18 93.95

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 figured out the problem. :) slight bit of stupidity on my part. Thanks for your help!!

I applied your suggestions to my code and it seems to e working but I am trying to now export my access query to the same workbook, and its giving me an error. Private Sub Command0_Click() Dim xl As Object Set xl = CreateObject("excel.Application") With xl .Workbooks.Open...

I appreciate your quick response and I applied your suggested fix to no avail. With the fix you provided I still get the Successful msgbox bu the sheet is not deleted.

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...

Im open o anything so long as my data ends up in the workbook. Could you advise how I could do this or point me in the right direction?

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 don't want to delete the entire workbook because it contains multiple other sheets with information that is needed.

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...

If I set up my form with a delete flag, is there a way to set a field that can record when that flag was flipped? In other words. If I put a field on the form that says archive this record y/n can I set timestamp to register when that was done? I suppose that if I just set it to stamp when 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...