Search results

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...

Genius, thanks!

:) Afternoon all, I have a combobox so the user can select values that are valid. I only just realised that the can type directly in the cell and ignore the values in the drop down if they want (eeek!) How do I MAKE the user select a value from the drop down and not be able to type...

Hi all, I have a drive called ="T:\Team Data" I need to export a file to this drive... A colleague has this same drive set up as his K drive and I want to know how I find the address of the drive? The full name of the drive is: Wb2p on 'NetApp Filer - Manchester, 208 Bishops cab 20/01...

My report is now down to 5 seconds to run! (was c.1min20 seconds) I am SOOOO glad I emailed the forum. Thanks again, Have a great w.e! Mandy

its taken me a wee while to test this.... and make it work for my queries..... but this has made my Friday afternoon much more enjoyable..... Absolutely ingenious!! Thanks so much for advice with this! Mandy