Recent content by TIDMAN

Thanks for the fast reply but this will stop any data being entered into that field, i need it to allow data entry and then stop any updates if you know what i mean? Thanks again.

Hi there all i need to set a field on my form not to accept any updates to what ever was typed in the field before it was saved the first time kinda like After update event = no updates :confused: Any idea on how this can be achived please. Thanks so very much in advanced. TIDMAN.....

Hi there all I have 2 tables related by ID both set to primary key, I have enforced referential integrity, by doing this I was hoping that I would not have any issues with the ID number but this is what I get when I try to add a new record to one of the tables You cannot add or change a record...

Thanks so very much bat17 works like a charm. TIDMAN......

on the first text box check if the date field is Null before wrighting. I dont have a date field in the first text box? where would i input this code? if isnull(me.MyDate) then me.MyDate = now() end if Thanks in advance for any help. TIDMAN....:confused:

Thnanks guys, i will give that a shot.

Hi there all, I tried the search option on this board but maybe its just that i dont know how to ask the question. I have a text box on my form with and afterupdate event that inputs todays date in to another text box on the same form, can this be set so that once that date is apperas in the...

Hi there all, I am in desperate need of assistance here as this is causing me some real stress at work as the deadline for this fix is getting closer by the day. Here is the problem, our A2000 DB has an export function which generates a text file for orders the company that I work for decided...

It is proberbly a $50 saving some place in the organization lol. I get compilation errors just by useing access 2000 to convert. Thought that it would be way less time consuming by purchasing software. :cool:

Hi there all the company that i work for, are upgrading to access 2000 from access 97, is there software out there that can be purchased that will convert these databases over to Access 2000? Thanks in advance for any suggestions. TIDMAN..... :confused:

Worked Perfect. Thank you :D

Thanks shadow, 3 of 9 is exactly what i am using, i will give that a shot. thanks again. TIDMAN..... :D

Hi there all I have an Access 97 DB that creates cards with a barcode on them our barcode scanners need an *before and after parts numbers and quantitys how can i tell access to automatically insert the * thank you in advance. TIDMAN..... :confused:

Anyone Please?

Thanks fot the help Pat I am not quite sure when it comes to master/child links i have attached a link to my DB for a better idea, the main form is called frm_COPS_ToDo you can then see the names of the sub forms could anyone see if this can be set up master/child and let me know if the main...