Search results

Thank you Rich, that works fine. Strange thing is first time it did not do anything but now it works after checking as you said. Thank you Mike A2k

Hello, I would like to change the colour of the back ground of the cell (field name) when data is wrong on a report. I have the following code which worked before on a form but seems to be a problem in a report: If Me.SCHED_DATE <> Me.Committed Then Me.SCHED_DATE.BackColor = 255...

Thank you very much my friend. I just did not see what you meant by empty module. but now I understand. Best regards Mike

:confused: hmm I have done this just left the form open and run the query but it still gives the same error message :( I have attached it so you can see. Kind regards Mike

Now message: Undefined function 'RemoveSpacesAndDashes' in expression. So how do I make it use this function which is in a form? Thank you Mike

ok that would be great but I have never done an update query before? it is easy to do? And how do I store my function in a query? Thank you Mike

I have written this function to remove all "-" or spaces in a string and it seems to work fine. But as I go record by record and remove them it don't seem to store them in the table :( here is my code: Private Sub Remove_hyphens_Click() On Error GoTo Err_Remove_hyphens_Click Set db =...

Thank you Rich, works perfect, thanks for your help stuck it on a button :) Regards Mike

Doe's anybody know of a way to add to the top bar special characters e.g. Ű ő æ å ø I have a lot of addresses to enter that are from Germany Norway etc so I need to be able to enter these extra letters in there address line. Thank you in advance Mike

I have the formula: Format(DateAdd('m',-6,Now()),"mm/yy") in my query but I want it to show six months back to now but it only shows the month from current -6 months :( how can I get it to show the other five months in between? Kind regards Mike

Thank you Fofa but how do I create a :dialog type form to ask for the file with a browse option. Kind regards Mike P.S. my current code is: DoCmd.OpenReport "QuotationEmailCables", acNormal, "", "

I am trying to prompt for where the file is I want to attach. Thank you for you help

Hello, I want Access to prompt for Attachments when I send an email. I currently use the line: myemail.Attachments.Add "c:\progra~1\adobe\acroba~1.0\PDFOut~1\Custom~1.pdf", , , "Custom~1.pdf" But now we are going to place customer quotes in folders and I want to be prompted to save this to...

Thank you again :) as I was looking how to do what you said I found under properties there was a section saying "unique records" and it was set to no. So as you can guess after changing it seems to work fine :))))) Thank you for your right directions :))

I have a problem, I have a quotations database I have two tables one for customer details with the quote number and one to hold all the part numbers for that quote. Now I what to generate a query that will show all the quotes for that area e.g. UK. Problem is it show all the quotes but with...

Well that would be ok but I have business class and office munchkins using this database and as you know there not too bright to click a simple button before they open the excel document would just be too much. So I have to find a way that would automatically write the file. as soon as they...

Hello, does anybody know how to append an exported excel file from access 2k? I have the code: DoCmd.OutputTo acOutputQuery, "QuotationEmail", acFormatXLS, "QuotesUpdate.xls" I do this on every quotation completed so you can see what happens, it overights the last one done and I end up...

Still no luck I still have not found a way to do this? anyone?

I have a problem with a continous form :( I have a combo box that I can select items after I select one. I would like it to drop down one line so I can select another line and so on, keeping my main input line at the top of the screen and the previously selected items scrolling down under...

Thank you but I am not on the subform I am on the Customer subform but the notesquery subform is open any other ideas?