Search results

Thanks for all your input. I solved the issue at the source by making the word doc property read only. Me thinks I was thinking too deeply here.

Thanks for responding. Maybe someone else has an answer for me. I have the reverse issue occasionaly with open and Excel file. I would like to make that always open in a read/write state.

I am thinking of creating form help files in Word then the user will be able to open the specific file from a control on the form. I am concerned that the user can change the underlying Word document. Can a document be forced to open in Read Only with VBA?

Hi Bob, I don't think so. I am testing out a process where I export 11 different XL spreadsheets that are sent email to recipients to enter their data and when returned copied back down to the original file which is linked to the Access program to admiister credit card charges. The read...

I am using this code to write to an .xlsx file and when it opens it opens in ReaD Only. Can some one give me a cure for this? Function ExportToExcel() Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Set objXL = CreateObject("Excel.Application") objXL.Visible = True Set xlWB =...

Thanks NightMayer this worked.

Thanks for responding. When I ran this code all I received was the first line of data from the query. I also need to run all the queries (11 of them) at one time. Can this be combined, or do I need to build this for each query? Private Sub Command0_Click() Dim objXL As Object Dim xlWB As...

I am not getting what I need with this function. It sends the data to Excel OK but I need the Excel file to retain the macros set into it and this function seems to make a new workbook each time. These spreadsheet files get updated monthly and emailed to the CC holder for authorization of...

I was thinking possibly I could use the same outgoing and incoming XL file and set up a linked table to the XL file then the admin people could just look in the linked file to see if the employee updated the file. Then just run an append query to the history file when each record is complete...

George, Yes. The problem is the field employees all have laptops with office installed but no Access.

I am in the planning process on how to deal with this on going situation. We have a complete download from Amex covering all the current monthly cardholder credit card transactions. I want to create a monthly statement for each cardholder to approve each line of charge, assign the business...

Thanks Niel, It's actually M1 is last January and M13 is the previous January.

This is not a live update database. Without an inventory number attached to the Inventory Qty History number how would anyone know what each 24 fields represent? I have three tables that I cannot change, however I can and do query. An "Inventory Master" table, "In-warehouse Qty" table and...

I am at a loss here. How would you structure 10722 inventory numbers each with 24 different months of activity. My structure is in this manner: Labels Inv # M1, M2, M3 M4 etc. Are you saying I should have it structured in this manner, or 1 query for every inventory number? Labels M1 M2 M3...

Fields are labled M1 for last Jan M2 for last Feb....M13 for prev Jan and M14 for previous Feb...all fields are and numeric with no decimals and no blanks but lots of 0's.

Thanks Khawar for responding. If I understand you correctly, I didn't specify the lay out properly and didn't give a correct designation to my Excel example. The correct example is Sum(A1:A7). Sorry about misleading you. Usage is in a row for 24 Months, left to right M1,M2,M3 etc., for each...

I have searched for an answer here but I suppose I am not wording my search properly. I have a query with inventory records with a 24 month history of sales labeled M1 through M24. When analalizing economic order quantities and some other calculations to reveal excessive inventory by item my...

Thanks Niel, I knew it had to be something simple.

I have a query built from a linked Excel sheet. In the query I created a new field with an IIF statement subtracting one field from another, and if the result was lower than one of the fields it was to show the total, and if not, remain blank. Below is the expression: UnderOverLP...

I haven't the faintest idea why but I was able to make a query that seems to work. But I had to make two expressions one to add the fields together and the next to devide the Total by the number of fields. I guess I don't know how to state the arguments for the columns in an AVG function as I...