Search results

I am not sure about the querydefs stuff but for the name ApXL.Application.ActiveWorkbook.SaveAs FileName:="O:\Medical\Enhanced Services\Enhanced Services 2011-2012\Reconciliation\Practice sheets\excel.xls" dim newExcelName as String newExcelName = "myNewExcel.xls"...

That is not that hard and I suggest you have a go at it. Post back here with how you go and the errors you get. strTQName must be already the full path to where your excel sheet currently is. So all I am suggesting is FileCopy strTQName, destinationfullpath/excelname & ".xls"

You can certainly do a "saveas" with excel and the object model, but I would like to suggest that you do this differently. You original master file should not be changed. As least I dont like that in case something goes wrong. So I do the following. get full path to excel file make or get...

Thank you for helping out. Ok now I got it. Yes I would love to do all this. But in this case I am getting the data from a database I have zero control over. So the field is what it is. In fact what my search is attempting to do is to pick up on the problems of the other database, both...

I have been doing a little bit of reading of the timestamp datatype. I know it is not a time stamp (holding some date / time) :-), as far as I understand when a field of a row is updated so to is this timestamp field. I also know that my Access Front end deals with all this for me. But my...

q_eval_reason is a nchar type of size 690. I might need a little help with this comment. I am sorry I am not very fit when it comes to SQL Server and SQL query language.

Sorry maybe I explained that wrong. It appears that the linked table query or JET query is not working with the len. The passthrough seems to handle it ok as the passthrough returns rows where the field is empty. I will however test what you have put above as I will eventually be using ADO...

The pattern is that the linked table query produces much less. The only real pattern I can see is that it is not returning all the ones where len(q_eval_reason)<11. Especially where q_eval_reason is empty and would have a len of 0.

What is a screen dump? If you mean a picture of your screen then you can attach images to your post.

I dont have 2010 so I cannot check this out. How does it work? In the developers reference here http://msdn.microsoft.com/en-us/library/ff868407.aspx I do not see this, so is private user defined or is there a private check box there?

Open up outlook, make a new contact and tell me which field has private in it? Or which field there do you want to check and say if this field = xy then it is private.

Welcome to the forum. How are you importing? What version of office are you using? How do you expect to determine that a contact is marked private?

Hi everyone, I have 2 SQLs which unless I am mistaken are identical. The difference is that from The Access Queries Objects 2003 I have one executing on the table LINKED, the second is a pass through directly to sql server. What I do not understand is why I am getting different results. Could...

I certainly don't, but I might mean something like this Set sourceRange = Worksheets("Sheet1").Range("A1:A2") Set fillRange = Worksheets("Sheet1").Range("A1:A20") sourceRange.AutoFill Destination:=fillRange When all else fails click ME and then ME.

Ok so your question is that you have a table in a database which records tasks. These task relate to a project and also then relate to a user? You want to know how you can CHANGE the user of a task or do you now want to have more users allocated the same task? A change is most likely easy but...

what is a "diary" then if you are not using outlook.

I dont have Access 2010 and at this stage have not looked at your file. Could I first understand what you want to do. You database shows a project with a number of items that need to be done by a certain time. The items that need to be done depend on who the user is. So lets say user1 is...

I dont really have an answer for you as I have not had this problem. But my suggestion or what I would do if I had this problem is to instead of using SELECTION I would try to get the range as a range and then call the autofill.

I have a feeling you are not going to like this, but my answer is I do not know how to do what you want. This is because folder structures can be unique to your setup and sometimes are not available. So here is what I would do. First I would look at what is returned by the...

The line in red needs to be deleted. and objAppt is now your calendar item.