Search results for query: *

I have upgraded my Windows 7 OS but would like to recover the previous product key. The original key was on a sticker on the bottom of the laptop but has worn off. Is the previous key stored anywhere that I can recover or has it been overwritten?

I have created a module that removes/replaces part of a string for the purposes of client matching. This code is run against both existing client data and any incoming bulk imports to the client list to create a linking field (which in turn is used to help prevent client duplication). The code...

I'm having some issues recreating the issue so I don't know if an xlt would remedy the problem. When I launch any excel file from outlook and attempt to save it it states that the file is read only and forces me to choose a save location (Office 2010). I'm going to assume the default behavior is...

I generate routine excel reports (in access) for a user and then email him the result. The problem he is encountering is that he frequently launches the file directly from outlook and forgets to save it locally. Any work he does on the file is subsequently lost. To help with this issue I can...

Hmmm. I turned the visibility on and the chart has been created successfully. I'll just make it ignore this error in the error handler but tis tres odd...

Thanks for the pointers. I'm sure I would have had to find these the hard way later on! I'm still getting a run time error 13 "Type mismatch" on this line objExcel.ActiveChart.SetSourceData Source:=selection Is it due to the fact I am controlling excel from a MS Access application?

Im trying to create a chart based on the selection. See code below. Dim objExcel As Excel.Application Set objExcel = New Excel.Application objExcel.Visible = False objExcel.Workbooks.Open (Me.txtDirectory) objExcel.Cells.Find(What:="date/time of last account table update", After:= _...

I made the amendments and it does seem to have fixed the error. As a warning to anyone else attempting this type of update query - opening it in designer seems to break the code somehow. Re-opening it and re-running it directly works fine. No idea what the query designer is up to however. Might...

I have two tables containing name and a postcode data. I need to do fuzzy matching between the two. I can join the two tables on postcode but want to fuzzy match on the name string. I have a code that generates a statistic of similarity between two strings and creates a greater value for a...

I'm having trouble making sense of it myself. Here is some sample data GroupID AccountIDs AccountCreatedDate AddressPopulation 1 51223 06/09/2010 20:04:24 1 1 51600 04/11/2011 12:14:28 4 1 55460 04/11/2011 13:14:28 5 2 73353 04/11/2011 12:14:28 4 2 131134 02/09/2011 11:14:21 4 3 130881...

I have a query which groups together duplicate accounts within a database. It has the following fields GroupID, AccountIDs, AccountCreatedDate, AddressPopulation (GroupID indicates thats the AccountIDs belong together) What I want to be able to produce is 1) A Count of AccountIDs within a...

Wow that's all new to me but will be most useful in the future. Thank you very much!

I need to allow a user to run a series of action queries based on an order he/she chooses on a form. At the moment I have a series of combo boxes where the user can type the order (1,2,3,4,5 etc). Dim vControl As Control For Each vControl In Me.Controls If vControl = 1 Then...

See Subject...

Thanks PHV I can now finally see a way forward via a simple update query. Nice!

I'm importing an xml file to a new table in MS Access but the time/date format (yyyy-mm-ddT00:00:00) isn't what I want. I undertstand what it means just fine but is difficult to work with after. Has anyone ever experienced this and has a solution for converting it back to a standard time/date...

Unfortunately I have 5 lines to cater for... But thank you for your response!

SELECT CASE len(CAST([ADDRESSDETAIL] as varchar(1000))) - len(REPLACE(CAST([ADDRESSDETAIL] as varchar(1000)),CHAR(13),'')) WHEN 0 then '0' WHEN 1 then '1' WHEN 2 then '2' WHEN 3 then '3' WHEN 4 then '4' WHEN 5 then '5' END AS COUNTOBREAK FROM dbo.tblClient

--Comma Count SELECT len(CAST([ADDRESSDETAIL] as varchar(1000))) - len(REPLACE(CAST([ADDRESSDETAIL] as varchar(1000)),CHAR(13),'')) as CommaCount, REPLACE(CAST([ADDRESSDETAIL] as varchar(1000)),CHAR(13),',') AS BREAKPOINTS, [ADDRESSDETAIL] FROM TABLE

Ok part 1 of solution. Finding the comma locations.. --Comma Positions SELECT CHARINDEX(CHAR(13),[ADDRESSDETAIL]) as Comma1 FROM dbo.tblClient SELECT CHARINDEX(CHAR(13),[ADDRESSDETAIL],CHARINDEX(CHAR(13),[ADDRESSDETAIL])+1) as Comma2 FROM dbo.tblClient SELECT...