Search results

Fanstastic! got rid of the comma before the 1, and it did the job. Many thanks :)

Can't use the trim as first and surname are both in same column separated by a space. The code kind of works, just unsure where all the ............ <dots> are coming from.

@GeorgedWilkinson. Have tried your code, but it updates my table column as per format below: john.smith........................@company.c The code is Dim db As DAO.Database Set db = CurrentDb db.Execute "Update tbl_employees set Email = replace(Name,' ', '.') & '@company.com'" Any ideas?

great will try a little later. Thanks

hi all, I have a table full of names in format first name <space> surname. How can I create a string that joins these together with a Dot in the space and then add @company.com at the end? I aim to write this back to a table column called email address when done. Thanks

Thankyou guys, finally got round to testing it and all sorted now :)

Hi Guys, i am having a right game trying to delete some records from a simple table on my SQL server. Say for instance the table dbo_Resource contains these records, where tasknumber 4 has 3 persons against it e.g. tasknumber |person 4 | paul 4 | andy 4 | steve and...

I have an Access mdb that contains 10 linked tables to my works SQL server. Each time I start my mdb is brings up the login to SQL dialog box, (user name/ password) so it can access the tables. Could someone kindly advise me if I can use some VBA code to perform an auto login when accessing the...

Hi Bob, absolutely spot on! it was a missing primary key that was causing me the issue. Once that was established, then writing to the table was solved. Many thanks to you all the other guys that contribute to this great forum.

Hi Guys, The driver is SQLSRV32.DLL Ver 2000.85.1132.00 And it's SQL server 2000. The connection to the SQL server is done by making the connection in Control Panel/Administrive Tools/Data Sources ODBC/ In the system DSN tag, i just put my server name and password and the connection is...

Hi Bob, thanks for the reply. On point 1. I will ask the server admin tomorrow if he has set me up a primary key. On point 2. I log into the sql server Using a ODBC connection.I have linked the table direct to my ms access application. I am able to open the table in Access, but all the cells...

Hi all, I have been using the code below to create new records in an MS Access table called dbo_suppliercontact, and this has been working fine. Last week, we moved this table onto our works SQL server, so everyone can access it. I am able to link the table to my Access project via ODBC, and i...

Thanks, and very usefull, however still struggling to get the query to output to the specific sheet. Have tried DoCmd.OutputTo acOutputQuery, "Distinct_Result", acFormatXLS, ExportDir & ExportFile, True, "A:J" and 'DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

Hi all, could someone please advise me how to send the records returned from a query to a specific sheet in an excel spreadsheet using VBA if possible. The bit of code below will create all the sheets i need, but it's missing the code to paste the query result to selected sheet. I hope i've...

Hi all, I cant export my table to a spreadsheet using Access 2007, yet it works fine in Access 2003.Heres the code: DoCmd.TransferSpreadsheet acExport, 6, "tb_parts","C:\out.xls", false I've read that transferspreadsheet does not work with Access 2007? Is there a workaround as i can't find...

No luck! To make things easier i've uploaded a database that contains a table of the typical data i want to sort. I only want to show records that shows a price change between two records,assuming the sort is done earliest date first. Thanks

Hi all, I have a table that contains the columns Price item description date buyer I am trying to sort the data in my table so it will only show the distinct records when there is a change in price. So for example Price item description date Buyer £1.00 101 PC 3/3/9 hardrock £1.00 101...

Already tried that mate.... problem is it works ok with Excel2003, the problem only occurs with closing an Excel2007 file down?

Hi all, I'm using the below code on a button click on my form. The code works by opening an existing spreadsheet and formats it. How do i get rid of the nagging prompt "Do you want to save the changes" when the the code executes? Thanks ' Open up the spreadsheet Set xlapp =...

Many Thanks PBaldy. Works a treat now!