Search results

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?

Hi, I am making a database for a project for a new MIS system we are implementing, which details training requirements. We are trying to analyse what programs in the various systems people use and will then train them on the new systems equivalent. Where I am stuck is I have a load of...

Hi, You can't have two autonumber fields, but you can change your current one to a number field and setup a new one. HTH, Roly

Hi, I have managed to get it to work and it tests OK aswell. I put a tiny, invisible textbox up in the top left hand corner and set this to tab 0. This makes the form start up as it should do, but the starting cell needs to be the Name textbox. So I put some code to goto the top textbox and...

At work, where the database is to be used, the resolutionis 1024 x 768. At home, my resolution is much high and it is OK. It looks fine at work when you go on to the next tab, but won't start like that... I tried some code to maximise the form on open,m but this didn't help. Do you know of...

Hi, Here's the file. Thanks, Roly