Search results

So I'm trying to get the following code to only run once per change. The issue being changing 1 value in the document can cause 100s of changes on the sheet this code is associated with and thus it runs 100s of times not just once per change. What do I need to do/add to make this only run once...

for some reason this if statement never returns true and builds the sql statement and i can't for the life of me work out why background to this is importing a load of updated data using transferspeadsheet replacing current table which has been renamed it then should fire up a load...

Just a quick one I suspect. I'm currentyl using transfer spreadsheet to import 2 tables, I've just recieved a new data set and my boss now wants to know what's changed where as before he was happy to just overwrite the old data. I'm thinking I'll need to import the data into a new table run...

Ok this is a new one I've not seen anywhere and I'm wondering if any of you guys can offer some advice on what on earth is going on here. Basically this process rips a load of data from a query and dumps it into a new sheet in a workbook. and there in lies the problem, in order to get it to...

I've got a series of macros I've written in excel, is there a way of saving the module so it can be loaded into access and run on a newly created spreadsheet? I'm currenly looking at something like this where the .ManipulateData is the last macro in the module that runs through the others in...

having a right mare of a time getting some conditional formatting working based on some data exported from access basicall the range of data is D2:AC100 D2:D100 contains the value i want to base the formatting on for each cell in the rest of the range E2:AC100 If the cell is empty do...

apologies for creating a new thread about what seems to be a done to death topic on here but i've tried most of the solutions I can see from searching I need a count of how many classes a piece of equipment is fitted to, at the moment i can get the number of different types of equipment fitted...

I have a query that pulls data from my database in the following format: EquipmentName Catagory Platform PlatformClass what I need to do with this is product a spreadsheet that has the EquipmentName along the Y axis, the Platform listed along the X axis and the cell to do a presence check to...

Having fixed my previous issues I'm now trying something else, I want to use 2 list boxes on a form to input to a query but can't for the life of me get the SQL statement to work properly Both my functions to build the lists of selected items from each list box work fine and report correctly...

It's been a long time since I've used Access but I now find myself producing a database at work and i'm provided with Access 03 I'm currently trying to run a query from a value selected in a list box which I will want to enable multiselect on but as I can't even get it to run on one value I...