Search results

I am using this to populate a spreadsheet but my data is way to large (10,000+ lines in 31 columns) to use this effectively. Help indicates transfering data in an array is the best way to go but I can't figure out from their example how set this data from a query into an array. Below is my code...

I can't seem to get this to work. I am trying to force ListMargin to 0 if Cost or Sell is 0. This is the statement I am trying to use. It gives me an Undefined functin 'IFF' in expression error.It's quite possible I am misinterpeting MS Help. I would apprecate someone setting me right. I get my...

Yes I have and as I said in my post, when I import the tables I don't have a problem with them just as they are. As I found in researching this issue that it isn't happening to a lot of people but I am not the only one and no one has found an answer yet that I have been able to find and...

Thanks Pat, I found a docmd.deleteobject actable, "tablename" which seems to work and then I ran DoCmd.RunSavedImportExport "SavedImportName". I should have checked it out before I posted.

Is there a way to run a saved import of tables through VBA? Or must I do a separate import for each table?

I have search all over including this forum but there doesn't seem to be an answer to the problem. When I try to go to Microsoft support I can't get any help unless I am a volume or contract user. I am trying to link 4 tables to a data base from another access data base that gets update daily...

Still getting this error when combining two linked tables into one query. I can only view in SQL not design view. When I try I get an Invalid name error and it will not let me proceed. I am able to make a query of each table separatly but I cannot combine either one. I tried making a new table...

I would like to populate a field in a form based on a table and have it's value come from a query thats not part of the forms record set. Is that possible? To clarify I have a query that provides the average unit sales. I have a table of inventory items the buyer looks at to determine a...

I want to make a function similar to this one provided to me from PBaldy and I don't know how to make it work for me. Originally when working with Paul I had queries built for each month of the year and this would run what ever query that matched the month the process was occuring in. I am...

Thanks Ned, I will give that a try.

Thanks for your help

Thanks for working with me Ned. Here is my query SQL: SELECT [IN Part Master].INPM_PART AS Part, [IN Part Master].INPM_DESC AS Description, Left([IN Part Master]![INPM_PART],3) AS VCode, [IN Part Master].[INPM_1U/M] AS UOM, [IN Whse Quantities].INPM_BQOH AS QtyOnHand, [IN Whse...

I have a table tha holds inventory data, some of which is, Line Point, Order Point,Econoic Order Quatnity and Recommended Buy qutantitiest that part of some computations using the average of the last 8 month units sold amounts. Of course this rotates to a new average depending on the month the...

I created the query to build and update a table so the query was made first Are what you telling me that if I run the query to make the table would I then change the number format in the table structure? But if so wouldn't the table format change each time I run the make table query?

I have tried to do this with no success so I am wondering if it is even possible. Can you update a field in a query from a textbox on a form?

I have some calculated fields in a make table query and one field allows me to set the decimal places and the other doesn't. I have both fields set to General Number format. This has come up in different queries and I don't understand the dynamics. Thanks for looking. This one does SP...

Thanks for your input. I will experiment with these suggestions and come back with issues, as you suggested.

I am confused as to how to get results I need from a select query. I have three queries Inventory, Quantity on hand and Quantity on order query. What I am trying to get is the inventory part number and description along the the amount in inventory and the amount on order from a vendor. When I...

I am building a database to give our buyer a tool to find under and over inventoried items and develop a recommended buy report by inventory item, vendor and warehouse location. I am working developing this information from a nightly download from our main server into Access. With this...

I can't get the database down small enough to post. I thought I was able to make a separate query for the records I need from each linked table then combine the queries But that didn't work either. I am going to try and create make table queries on the linked tables and see how that works. I...