Replies

The new code uses the same number of characters regardless of the product, if there is no need for an option we populate that part of the code with null values. With the exception of the last three characters all options in the new code are two characters.

The table we have with the translation values has four additional columns in it for the start and stop position of the two options. in my earlier example for instance IA would have a start position value of 3, stop position value of 4, in the new product code, while having a start position value of 1, stop position value of 2, for its equivalent value in the old code.

Hans

OK, knew I should have included an example…. sorry

eg of new code: -VSIAL1AEF1CXA2H01

equivalent old code: -IA025F1CXA1H1

The codes are constructed from options, each character pair, or the odd individual, being the code for an option. It is the options I have in two columns (I really messed up explaining that bit) rather than the entire codes. So, by parsing out the parts of the new code that have an equivalent, in this case: –

VS has no match
IA= IA
L1 has no match
AE = 025
F1 = F1
CX = CX
A2 = A1
H01 = H1

I can find the old option value in the translation table, having found the options values I can rebuild them into the old code using concatenation. Where I’m struggling is to work out how to match my 7 parsed fields to the 7 records that will allow me to rebuild the old code.

I hope that makes more sense??

As usual, Hans and Wendell know more about what I’ve done to my databases than I do!!!!

I had overlooked the ownership of the forms, fortunately the datatables had been secured properley. Just had a very quick re read of the security FAQ and it’s not that obvious about the ownership issue (spotted it now I know about it, but…), I’d understood it that once the Admin user had no priviledges you were safe….

I must pay more attention at the back of the class in future.

Thanks again

Ian

I did have a vague idea that both Admin and User could not be deleted.

I also thought I’d removed all the Admin user priviliedges, I’ll have a better look.

Should I also remove the priviledges from the Admin User group?? I kept this as the easy option and simply removed the Admin user from the Admin group.

Live and learn, thanks.

Ian

Thanks for that tip, I’d missed that in the security FAQ.

Just checked the database I copied the forms out of, the admin user still exists, but the owner of the two forms I copied is my own user name, not the Admin user.

The Admin privledges are set to the user group and the user group privilidges are nil. Should I have deleted the Admin user totally?

Apologies for taking this off on a tangent.

Thanks

Ian

It might be possible to copy items out of a secure database, I just copied a couple of forms out a datbase I secured using MS Access security and could have had the tables as well.

The database in question uses a different MDW file to the one I have on my HDD, so it might work for you as well. I was surprised it let me though!!

Ian

I’ll give that a try, unfortunately it’s not the first time that will have been done to this database, I think it has got to the point that a major overhaul is in order.

Hans

Thanks foi the help, I’d tried the … bit, it takes me straight to my code, so it is attached to the right control.

The information I’m trying to update is in the datatable, it is not displayed on the form, nor is it in the query used to populate the form.

I have just tried adding it to the query and then updating a text box on the form, but no luck. I’m now fairly convinced that some of the problems are down to very bad database design, I’ve come across a few comments about spaces in field names not beng a good idea, this database has lots of them. While Access alters the name by adding an underscore when it’s dropped onto a form, the table still has the original name with the space.

I’ve looked into the database in depth and there are a great many occasions where this has been done, almost every field in every table!!

To confirm my theory I’ve copied a small amount of data into a new database, recreated the form and subform, the code works, so unless I’m wrong about the spaces in the field names it looks like that’s my problem.

Thanks again Hans

Ian

OK, here is what I’m trying to do: –

The database is used to record all work requests made to our maintenance department along with the response made by that department. Due to a lack of PC skills (the don’t like typing) I’ve been asked if it’s possible to enter the date and time by clicking onto a button or control. As there is a control (check box) that they have to click to identify what task they are currently working on I wanted to use this checkbox to populate the date / time field. It was at this point that I started to have problems.

To be honest, the database is a bit of a mess, mainly due to a host of modifications made to try and reduce the amount of typing to be done. This is just one more job.

It’s times like this that I start to think it would be a fun job if not for the users……..

Thanks for the assistance so far.

Ian

Hans

Thanks for the advice, but I’m still not having any luck. Although I’m now thinking it’s not related to the code. I’ve replaced all the code with a message box line and even that doesn’t appear!! Is there any reason that a control on a sub form might not allow code in its ‘on click’ event to run?

I had noticed the qDf was superflous, but as it was in the MS help example I put it in when the code wouldn’t work….. Result, no change….

I have persuaded the database to do what I want from my ‘test’ form, using the docmd.runsql line of code, however, even that wont work from the dratted subform.

I’m starting to think it might be down to this being displayed in continous forms??

Thanks for the help.

Ian.

Thanks for the replies, that tool tip ting would be brilliant if 2000 had it, pity we wont be upgrading to 2003 any time soon.

The properties window will do me, it even solved the long standing mystery of where the $ sign comes from in the error messages about tables not existing…

Thank You.

Ian

Great

Thanks for the help, all methods seem to work fine.

Ian

It’s the dates. For some reason the date is being changed to US style in the SQL ouptput in my immediate window. I changed the day and mopnth back to how they should be and now have a result from a query, by setting the EndDateTxt control to September next year I get results.

I’ve just gone through my PC’s settings and they haven’t been changed as far as I can tell, the date format is still dd/mm/yy style, is thre a way of forcing SQL, or Access to accept the dates in a certain format? Or, is there anywhere in Windows 2000 that controls the date format outside of the control panel?

Francois

Sorry, just noticed the one I’d posted still had the spaces in, bu tonly after you pointed it out to me……. Charlotte will be thinking I’m a bit thick…

Thanks for the time and trouble.

Ian

It’s the dates. For some reason the date is being changed to US style in the SQL ouptput in my immediate window. I changed the day and mopnth back to how they should be and now have a result from a query, by setting the EndDateTxt control to September next year I get results.

I’ve just gone through my PC’s settings and they haven’t been changed as far as I can tell, the date format is still dd/mm/yy style, is thre a way of forcing SQL, or Access to accept the dates in a certain format? Or, is there anywhere in Windows 2000 that controls the date format outside of the control panel?

Francois

Sorry, just noticed the one I’d posted still had the spaces in, bu tonly after you pointed it out to me……. Charlotte will be thinking I’m a bit thick…

Thanks for the time and trouble.

Ian

Hope a zip file is OK?