Recent content by Geordie2008

Do you have the exact code for this? Ive tried and tried and cannot get any code that actually does this? M

Hi, Just to give a bit more background.... coz I really cant find an answer to this one anywhere on the web.... I am trying to add a primary key to a table that already exists using VBA or SQL code.... Tnx, M

Guys, I make a table using VBA, and I want to put a primary key on a field using code Any ideas? Ive trawled the web with no joy. M :-)

yep, sorry, managed to work this out seconds ago.... I added:Me.[mandy subform].Form.Requery to the afterupdate of the text box. Cheers, M

Hiya, I have a form where a user updates the textbox "Criteria" Once this is updated I want the results of the query to return in a subform. I have designed the subform and created the query... How (and where do I put the code) to make it update? Do I need a button? Also can I get a...

Ah, of course, if you do it in order you dont need the other restrictions...... Thanks, brain is not functioning logically today then.... M

Hi All, I cant find the answer tp this one using the search, although Im v sure it must be a common problem..... Im trying to do the following. If [Limit] = 0 then "No Limit" If [Limit] > 0 < or = to 1000 then "Limit up to £1,000" If [Limit]>1000< or = to 5000 then "Limit between 1,000 and...

yep - only once Tnx, M

Hello's I have a huge strings of text in a column. When the word "exclude" is found in the text I want to print all of the text to the right of it into a new column.... can anyone help me with the formula please? Tnx, M

Afternoon All, My user occassionally inputs incorrect data and wishes to delete it from the main table. They sometimes input the same new employee twice with slightly diff spellings etc. When they notice this they want to be able to open the form with the incorrect data in it and delete it...

Mmmmm..... was hoping to avoid all of that pointless code.... will have a think about if its really required...... Thanks anyway. M

ah, Im speaking in excel terms again, sorry. When I said Macro I meant VBA code.... I have the code, it works fine, I just need it to be run everytime something changes amd I dont know on which "event" I need to out it... Thanks, M

I already do a further check on close. It wont let them close a form if the data is not a valid entry.... I just want the cells to be coloured for problem areas and then go white when they are resolved...... Is this poss?

loops through each field and assesses if the data within the cell is valid. If yes, the cell background is white, else red. When the user updates a red cell with a valid selection, I want the cell to go white, so I need to re-loop the criteria..... Thanks, M

Hi all, Im not sure which "on" event I want to use.... Everyime a user updates a field on the form I want the form to loop through on of my macros.... so everytime a change is made I want the code to execute..... I didn;t want to have to put an "On Change" on every individual text and...