Search results

Brilliant! ListO that is fantastic, many many thanks. am going to be difficult though!! we have many ranges to input and this code only allows one range, i.e. 1,2,5,7,8-10 but the typical amount of ranges entered is below... i.e. 1,2,5,7,8-10,20-65,80-90 is there a way of when the code...

thanks Rich, I am a bit concerned about the risk of miskeying on a multiselect list.... due to the amount of batche having to be entered.. but it may be the best option. ta John

ok, this is a good one..! I have a dbase which one of my users wants to input the number of batches which are archived. Q is which is the best way to do it? there are 100 batches for each project. the user wil key in to the database the batches which have been archived for example...

I have a colleague who has a main dbase and a data entry dbase. the two main tables within the data entry dbase are linked to the main dbase......!!! she wants to make one of the fields in the data entry dbase a drop down list, but becuase the table is linked it cannot be modified. is there...

Success! thanks for persevering! no idea why it did not work the first time! that is great am much obliged. cheers john

sorry colin, that does not work. the box they enter the criteria date into is within the query itself, as soon as the query runs the criteria dissapeers becuase it is a temporary entity. therefore there is no way to reference to that. as far as I can work out! date column based on that...

I have a report that runs off a query. the reports data is based on a simple criteria box that prompts the useer to enter a date. the report then lists all the projects completed before and upto that date. the problem is that the prompt date box, is not in itself an entity. I want to put on...

ta! that sounds a good idea, thanks.. john

I am exploring ways of putting my user guide for my database into the database itself. the idea being that the user can click on the help button and the link will take the user to a word doc, or a pdf to the chapter which is relevent to the screen they are on. I may not have access to a...

ta! many thanks that solved the problem. regards John

I have a txt box that is stamped with the date when another box is changed to a code of 4. the problem is that if the user changes the code to 5 by mistake then changes it back to 4, the date is changed again. After Update what I need is if code = 4 and stage4 is blank then stage 4 = date end...

I have a textbox which the user types in an ID. this then brings up the records in a subform. I then have some msgbox code which says that afterupdate of text box if user id = user id on the subform, then we have a existing record for the user, otherwise we do not etc. but the msgbox routine...

Thanks thanks for the info Pat, I managed to get the syntax to work, it would have been good to have put in the previous job numbers, but they were only in paper format, so was decided not to update the table. but I will need to do a similar exercise for a another number in the future and...

I have required fileds within a table, and therefore a message box appears if the user tries to save the record without entering all the required data. when I take this table into a form, is there a way of changing the msgbox content, for at present it is pretty complicated text which I know...

hmmmmmm hi there, cheers for your patience, well still no luck I am afraid..... verified all that you mentioned. but no change. a Q.... does it matter what the module is called where you declare the ADHresize?? at present I have it called as frmresize... ta John

error! I am getting that it cannot find my table "new final table" where the job number is housed.... any ideas? John Private Sub DE_Job_number_Click() On Error GoTo Err_DE_Job_Number_Click DMax [DE Job number], [New Final Table] + 1 Exit_DE_Job_number_Click: Exit Sub...

thanks to you both! cheers to you both for the tips, I'll try both possible routes for this one.... its like some kind of syntax war!!! ta John

many thanks! cheers for the tips, thanks for the new education policy for me to try!! I'lll give it a go. ta John

I have a table with completed, active and inactive projects. basically the projects that are completed or active do not need job numbers. but the inactive projects once they turn active I would like to assign them a job number. as this used to be manual the next number to be used is 2180...

Update! well, have put in all the syntax, but unfortunatly nothing happens!! when I put in screen co-ordinates for 800x600 it still comes out in 1024x*** etc. any ideas? I have : Option Compare Database Option Explicit Private frmresize As ADHResize97.FormResize Private Sub...