Recent content by George Hewitt

Re: How can my cursor get an "hand" shape ? only 12 years lol :o

Cheers for the help Epiek did the trick.

Hello Guys, So i today I am wondering if anyone can guide me with a calculation im trying to achieve. I want to take the sum of all records 'cost' i.e. record 1 - 2 record 2 - 4...

Yes it seems a lot more complicated than i first expected

Hello all. So i have another question I have had on my mind recently regarding Date. I want to limit the choice of dates entered so it only allows certain dates. E.G. Can only a date which resides on a sunday. If anyone has any general guidance on how to achieve this or manipulate formatting...

Cheers for the information.

Is Cumulative data bad for access? It must be! I am doing some work experience for a company and am convinced that entering cumulative data every week for a unique activity is bad? For example: data entry of records unique to a marketing activity date -------no.responses...

Thanks Plog for your assistance :)

Very true. My main question was in fact about the SQL programming as i have no previous experiences. Sorry to be a pain UPDATE Activity SET Activity.SRC_ID = Mid([Publication_Name],1,3) & "-" & [Activity_ID]; Publication_Name is in the Publication table was i meant to enter that somewhere?

Ok ill try explain! Well the system before the one im creatng now uses a 'sourcecode' it was something they made up. I suggested like you said just to use an atomic simple autonumber right but they needed to have this 'significant unique code' for each marketing activity (the code is publication...

Ahh ok thanks for the help, Yep i just relaised i shouldn't be using lookup values all over my database :( I'm going to approach the select query tommorow but i will post if i need any assitance.

Hey all, I am currently struggling with the following. I have created a table which has columns which are auto populated by related fields using lookups. For example: I have an Activity tbl (for advertising activities) and a Publication tbl (which is used to select which publication the...

Hmm im thinkng this may possibly involve VB code ? I am a massive noob! ;D Edit: I figured out how to do this by using an update query with the two fields i want! yay ;)

So i have been looking into this matter the past few week. I certainly understand the principals alot better. I can see that making a unique indexed field with the appropriate data values would make alot of sense. I have been searching and looking for material on how to achieve this in...

Sorry for the late reply jdraw I understand this alot better now. Infact i have deliberately been using autonumber everywhere in my design and it seems to be working fine :D So cheers.