Search results for query: *

This is a really fun one. I have an elaborate Excel 2003 formula calculation workbook that is saved as a template with multiple Vlookup tables that get their data from an Access database, I have them set to refresh on open. With the one generation of it everything works fine but I have set up a...

I use a form to enter new records and update existing records in my DB and use a combo box in the form header to look up the record I want to edit. This functions perfectly but what I want to be able to do is to use the same form to also view records in read only mode, I have tried this by...

I am working with a simple IF/OR formula in Excel that I want to return one of several predetermined values based on the content in the reference cell. The data in the cell is text and I am trying to use a wildcard to match the criteria so that if just part of the text string is in the cell it...

I'm starting to see a lot of issues with several of my databases (Access 2003) on our network not saving edited/added data to the tables. We used to run on a Novell network but this was changed in the last year or so to a Windows based Active Directory environment. I suspect that the problem...

I have a data entry form in my database that is based on a query. I want to be able to let the user duplicate the current record to the next record in sequence with a function button to allow them to modify a few pieces of data but not have to re-enter everything. The underlying record set...

I have an Excel 2003 spreadsheet that retrieves data from an Access database and have it set up to auto-refresh the data on open, three sheets in the workbook are set up to pull data over from separate tables in the database. Everything is working fine although I had some fun when I wanted to...

I have an Excel workbook that I have automated with macros to copy two of the sheets out to a new workbook and then break the link and remove some formatting to retain just the data as a copy of the results in the parent workbook. All was fine until I set it up as a template on the network...

I have an Excel workbook that I have automated with macros to copy two of the sheets out to a new workbook and then break the link and remove some formatting to retain just the data as a copy of the results in the parent workbook. All was fine until I set it up as a template on the network...

I asked this question in the MS Office group but received no replies so I thought I'd try here, since it's probably a VBA resolution anyway. I am working on a formula calculation spreadsheet in Excel 2003. It utilizes several tables of data that I do Vlookups on multiple columns of data. The...

I am working on a formula calculation spreadsheet in Excel 2003. It utilizes several tables of data that I do Vlookups on multiple columns of data. The data tables are a download from our old system housed on an AS400 which was my starting point. To get a better idea of what I'm dealing with...

Does anyone know if there is a way to increment the Column Index Value for a Vlookup when drag filling formulas? Something like the opposite of the $ absolute reference for cells, or an approch to automating the process without having to type the number in each coulmn? Any help would be...

I found a similar closed thread on this subject here that had no replies: thread68-616601 We have about a thousand Word documents that were originally stored on a Novell server that were migrated over to an NT server. Everything was fine until the original server was removed. We now have an...

In my Access '03 DB I am trying to set up several Monthend query functions for laboratory project tracking, there are records that go back several years as well as recent ones that could have been added since the first day of the current month, and I would like to be able to run the monthend...

This is an annoying problem. I have an Access 2003 DB that started out as an Access 2000 DB. In the Database window I can view Tables, Queries, Forms, etc. by: Large Icons Small Icons List But if I select "Detail" I see absolutely nothing! I ran into an archived thread asking the same...

I've been through this before and was able to use the DateValue solution but now it's not working. I am trying to set up a simple (yeah right, no such thing in Access for this one) parameter query that returns records between two dates: "Between [Beginning Date] And [Ending Date]" on a...

In my Access 2002-2003 database that I use to keep track of lab projects I would like to add a second table that records testing data, the first table stores information about the project itself, description, due date etc. I could skip all of this by just adding the fields to my existing table...

My DB is in Access 2002, I have a number of parameter queries that show a table of results. I often manually use the "Filter by Selection" function for specific records and then get the "Do you want to save changes to the design of query" requestor when closing the result table. This is no...

I have an Access 2002 DB that does not use any security other than being limited by Novell network permissions. I have a field in the main table for the user to enter their initials through a form but it is not restricted in any way, so they can type anything they want (not the best way to do...

I have an access '97 DB that imports data from DBF files via linked tables, I then create Access tables by a make table query so the tables are recreated each time an update is performed (the originating database is still in DBF format). I have a problem either with the import seeing the 2000...

I have unchecked the setting in "Tools, Options, Confirm, Action Queries" to try to disable the confirmation box that comes up when I run the "MakeTable" queries that are built into my Access '97 database but I still get the confirmation message and subsequently have to...