Search results for query: *

I have the need to create several hundred named ranges and have created a VBA script that will loop through and create them. However it puts quotes on each end of the definition when creating it and then I have to go in and delete the beginning quote and ending quote for each one.. Do While...

I am having some very strange issues when trying to update a pivot tables pagefields using VBA. The pagefields do get updated with the correct information but the output of that is returned in the Pivot Table is not correct. When I create a new PT and use the same selection criteria I get the...

Hey Everyone, I have a spreadsheet that contains two columns. Date and Currency Rate Date Rate 10/1/2012 2.0264 10/2/2012 2.0268 10/3/2012 2.02585 10/4/2012 2.023 10/5/2012 2.018875 10/8/2012 2.0306 10/9/2012 2.0297 10/10/2012 2.0355 10/11/2012 2.041725 10/12/2012 2.0426 10/15/2012 2.0426...

Hey guys I have an Excel workbook that connects to a website and processes data based on the user that is using the workbook. I just found out that they are moving the website app to another company and the login is just a tad bit different. I was just notified today that they are going to move...

I have several very large tab delimited text files that I need to import into access. When I import them using the import wizard all of the date values fail to import. I get a "Type Coversion Error" on every record when I try to import the date fields as actual dates. I have modified the...

I am having some problems when using a forms criteria to run a query. I need to be able to select 1 or N names from the listbox and then select a beginning date and an ending date. The query should then be executed with the selection criteria listed above. Can anyone tell me what I am doing...

I am having trouble coming up with a good search to find simular customer names within my database. A friend of mine suggested the code in red but it is really not doing what I need it to. I could have customer names that vary so I need it to match names like the example below. Lets say I...

I have a form in which I have a multiselect list box that contains a list of customer names. I am want to be able to select multiple customers and press a command button to run the query and pass the list box items along with it. I found this bit of code and tried to make it work but I cannot...

I receive a weekly spreadsheet that I have to manually adjust each column to be a certain type (numeric, text, etc) I want to be able to automate this process. Can someone please refer me to a good source of information for this. I am sure it will require some scripting. But being a newb to...

I have a table that has a product ids. All of these product ids are now changing to have two sometimes three additional characters at the end. How do I append chars to the end of an existing field using an access query. Product id ----------- abcd12 bcde13 cdef14 New Product id...

All, I am having a very strange problem with Access. One I have never seen before. Recently started seeing issue with my queries not working correctly. I have a query that has lets say 5 fields. And two of these fields have conditions on them. field one = Specific customer name field two...

I have a transaction database that I am trying to query a very select amount of data. I have a list of Product Codes. I have many Sales Orders that can contain 1 or many product codes. I have been working on a query that will only spit out Sales Orders that contain only 1 Product Code. What...

I am trying to use the transferText to create and import data into a table. I have created a specification file but the autonumber doesn't remain in the spec file when i save. Is there anyway to add an autonumber primary key to this?

I have two tables one is a transaction table and the other is a list products with special pricing discounts(SPD). Not all items in the transaction table will be listed in the SPD table. In my query I do a calculation to determine the discount plus some other calculations along with the...

I have a transaction database that I have to update once a month. I receive a text file with all of the transaction data (2005 to current) so each month I will have the new records + all of the old records in the text file. When I import the file I will get duplicate data as it contains all...

All, I am trying to build a query that will pull only specific records out of a transaction database. I only want to pull data from the database in which product_A and product_B are part of an invoice_id. Example: Invoice_id 1: product_A Invoice_id 2: product_B Invoice_id 3: product_A...

I am trying to build a complex query that will help me extract data that is not really easy to analyse Widget A = Product ID 100 Widget B = is made up of multiple id's = Product ID 200 = Product ID 150 <- this product can be used by with both Widget A and Widget B, C, D ...