Search results

Lookup table Nearest value Tks Rich Ok heres an idea of what I am trying to do The look up table contains a series of adjustment values,related to the base value So i could have the follwing situation Value lookupvalue 2 4.3 2.5 5.6 3...

This is a repost from queries which failed to get any response over the last 10 days. I need a method similar to VLOOKUP in XL, that can find the nearest value to the specification from a lookup table. The basic problem is that the data is in round figures,but after I apply a percentage...

Vlookup in XL seems to do what I want,but I cant find anything similar in Access. As per the title,I need the query to select the nearest number from another table to that specified in the query. The lookup table has (say) whole numbers,but the query may be looking for a range in between...

I am getting a number of Import error tables as the result of importing from an excel file. Depite these tables being generated I am getting the correct answers imported into my access table,so rather than spend heaps of time trying to correct it,I really just need some suggestions to auto...

A belated response but many thanks Newman. It took a while to come to grips with that,especially as I needed to increase the delay to 300,000000,to finally get it to work. I actually run an AMD 1300 so its not exactly slow,its just the xl spreadsheet is very slow. Anyway a very simple solution...

Output to Many tks Col. Yes I converted the Macro to vb,and it works fine Many thanks Captnk

Output to message Tks Col. Yes i get that,but even so I dont see how I can automate the "kill" in the macro. U can delete access files ,but i cant see how u can point it to an external file. Thanks anyway

I am using the "output to method",in a Macro to export a table to an .xls file. However even with warnings set to NO,the damned thing keeps asking me if I want to replace this file. Is their anyway to get rid of this message as I dont want the programme waiting for input at this point Thanx...

Call a module from a Macro Tks Softboss....Unfortunately that doesnt work either. It now tells me it cant find the item. I.m really stuffed on this, Because I desperately need to stop Access while an xl spreadsheet calculates (Im currently achieving this bu using a message box,)but long term...

I want to call a module (a timer event),from an Access Macro . However I currently cant figure out how to get the macro ,using "run code" to run the module. The module works fine on its own,so does the macro ,but Iam at a loss how to attach it. Help Please

Thanks Newman. Thats a really interesting Idea. I will give that a shot and see how it goes Captnk

I have an export from access (Transferspreadsheet method),which then calculates in XL and is then reimported. However I need to have the Macro "wait" at that point (1 0r 2 seconds) for xl to finish its calc before reimporting. Can this be done from the Access "macro" design form pls. Captnk

Syntax Thanks. Yes Iam using the TransferSpreadsheet method. It works when I reference a single page spreadsheet,what I need to do is reference a "worksheet" within that spreadsheet. Tks

I need help on the correct syntax to import a specific sheet from a multipage XL spreadsheet. I have no problem where a spreadsheet is a standalone item e.g: d:\myprog\myxlpage.xls The problem is to reference a sheet within a multi page spreadheet e.g d:\myprog\myxlpage.xls????????????? Thanx

I think I got lucky and appear to have solved my own problem,by changing the Tab order. Design view/edit/Tab order Captnk

I have a form with a subform. When i open it ,it always opens a few rows from the top,necessitating scrolling up to see the data. On tabbing to the next page it again reverts to a view a few lines from the top. I have tried saving it when in Correct view,but that has not changed the result. On...

Is it possible to limit the number of decimal places to (say) 5 in a standard SQL query. I am trying to do a query on a query to save making a number of unecessary tables,however I am getting a "type mismatch" quote which appears to be the result of the excessive decimal places where access puts...

Ok, so its easy to pull the top 2,3 or so of a field by using the drop down list on the toolbar. however that only seems (or its all i can make it do),is give the top x from all the items in the table. What i want to do is be able to find the top 2 or 3 or so items value by CATEGORY. Before...

I need to be able to subtract fields in a column from each other. eg [date] [expected answer] 27/12/99 9 18/12/99 16 2/12/99 14 18/11/99 12 6/11/99 (The answer being the difference in days between each date) Its easy in a spreadsheet,but I need...

I have a 3 column list box narrowed so that it only shows 2 columns on the form. It would be useful if the horizantal scroll bar could be hidden. Unfortunately list box properties box doesnt offer this option. Anyone got any ideas on this please Regards