Search results

No I haven't touched that yet.. except maybe accidentally.. Personally.. I think I have hit some option accidentally and messed it up.. so if oyu can think of an option that controls this...

Easy Question ?? I didn't find this an easy question.. but I thought about it for a little.. I think some of the problem is because you dont appear to have a Key value or if you do it probably wont help you much in this query. So here is ueber brilliant way to do it.. OKay maybe not.. If you...

No problem... Yeah they aren't linked or anything. It might not be that they are write-protected just when it wont execute the delete query the only thing the computer animated help thingy (Mine is the cute robot.. ;) ) tells me is it mgiht be Read Only.. soo....

Internal... No I am creating it from a macro in that database. J

I do not know why.. and needless to say to it is really annoying me... Every Make-Table Query I make creates the table as Read-Only and I dont know why or how. I dont think Acess 2000 has done this the whole time i have been workign on my project.. but only remember this happening half-way...

Try looking at Expression Builder button. It looks like a magick wand with sparks coming out of it. It has lots of useful calculation things. You can get at fields from here w/o misspellings. ;) I particularly suggest Functions -> Built-In Function -> Date/Time -> DateAdd DateAdd takes a...

I think a slight simplification might be to check that both addys are: First -- Same State Second -- Same City Last -- Street Addy Because there are likely to be more irregularities in Street Address that state and City.. J

I think this would work... I am trying to get teh syntax right... but just use Expression builder... Build a query in Design View. Add the two different Student record types (i.e Fin aid, Reg, etc.) Build a relationship linking SSN# (Guess you have this so far....) Double click on one of the...

Actually I just came up with a neat way to solve this. My workplace the weeks are Sat to Sat and it is easier to input data as week numbers. But then you have problems with years so here is what I do. At the beginning of every year the manager I am writing my program for has to specify a few...

if (wdate <> NULL AND wdate < date) then ... end if AND means both sides have to be true. If wdate is NULL then it cannot also be a value that is less than date. (Null isn't a value) Access looks at this and says it is impossible. Any other language would always return False to that...

I was so aggravated at this yesterday because it was 4pm and I wanted out of this Cubicle. So today I sat down.. felt my temperature rising.. sat down posted.. then actually thought about it... turns out.. You know that >"0" condition? If I converted this update to a Search Query it didnt...

Well I tried that... I have tried it without the AfterUpdate option. It still didn't work. That was an attempt to make it work... =/ Thank you for that help though! Jewelz

Oh yeah... YEah.. There is no error nothing.. I have the Emp ID default set as 100 and it just doesn't change from 100. I also do not have a primary key set but there is a distinct record number.

Here... UPDATE [DMS Employee Info] INNER JOIN [Sample Enter New Employee] ON [DMS Employee Info].EC = [Sample Enter New Employee].[Employee ID] SET [Sample Enter New Employee].[Employee ID] = [Forms]![Add Employee]![EC].[AfterUpdate], [Sample Enter New Employee].[Specific Entry Num] =...

Hi- I am an intern with Verizon and I have a pretty big project in Access 2000 that I dont have much techinical help with. I have run into a major problem though, so in surfing the great garbage heap of an Internet I found this site. I am trying to build a program that helps schedule employees...