Recent content by Roly Reefer

I want setup some databases and spreadsheets as freeware. i want to link up all of thed databases with reports and queries. and the spreadseets. to some of the databases. If people download say 1 or 2 databases will the whole thing work with links to databases which aren't there? Thanks...

i need to setup a load of queries on an access database with corresponding reports (pivots). i want to copy the data into the corresponding spreadsheet to the end of the data when each query button is pressed, so the reports are automatically updated when the query is ran. how can i do this...

Spot on Brian - thanks a lot. Thanks aswell baldy

I still cant find anything wrong with the code - when i run with breakpoints it just stops where they are. But still have 0 values for everything.

I have tried setting some break points but nothing changes - it stops at every line highlighted in yellow. i am not sure really how to use this feature.

I am learning VBA and have some code that i cant get to work. When the code runs on the combo box it doesn't pick up any of the values where it should. The code is definitely correct and i have tried a few things to get it working but nothing changes. In the four textboxes, avg, sum min, max 0...

I just thought you would be able to change them in vba as well as design view. I wont try again. Thanks for letting me know you can't do it. What do you use the form.allowadditions for?

Hi, I am learning vba and have some code to change to change the allow additions / allow deletions properties on a form, but can't get it to change the properties on the form (which i have set to no for both on the form - hoping to get them to change to yes, so i can then change other...

I am teaching myself Access VBA and have got a problem with setting up a new collection, which I can't resolve in help or google. I have been shown this code for setting up a collection, which is basically to set txtcustomers on form 0 (frmcustomers) as item 5. I didn't get the first line of...

Working perfectly - thanks a lot!! Works slightly differently in mid to right.

I am trying to get a mid formula that can start exctracting at the first space (which I can do) and stop extracting at the last space, which I can't get to work properly. My current formula is: MID([PRODUCT DESCRIPTION],INSTR(TRIM([PRODUCT DESCRIPTION])," ")+1,LEN([PRODUCT...

You can't update the query itself - you need to create another subform and link this to the table that the field is in and put it on the other subform. HTH, Roly

I know the database is awful, but it is only for a one off project and is just a short term thing. I didn't know about this query when I set it up, otherwise I would have done it instead of thinking about it first. Thanks for your help, Roly

There are going to be 4,500 rows, so creating that many queries would be to much to display in a form, or as a query - unless there's an easier way of doing it? Thanks for your help, Roly

Yes I am, can u do this?