Search results

Hi paul, No i dont think i can do this as in the full query (as seen above, probably pretty sloppy but hey) there is CASE THEN ELSE statements which base themselves off of the previous [...Forecast] date field. I'm very surprised that this cascading works fine in Access (which i'm converting...

I have tried doing it outside the View builder by building a query without the graphical view designer. It allowed the " marks but it didn't fix the issue :(

SQL Server does not allow me to do this. If i put in "d" it automatically changes it to d if i put in 'd' it gives me an error message.

I have removed all the unnecessary code below. Maybe someone could try and re-create my issue. Create a table in SQL Server called dbo.Q_PSR_P6_FND, add a field called MW_PSR_ID as your ID field and one called [Issue for Technical Analysis Forecast] and enter '2012-08-09 00:00:00.000' then run...

Hmm, im not using any VBA here!

This is the code: SELECT MW_PSR_ID, [Issue Technical Package Planned], [Issue Technical Package Planned] AS [Issue Technical Package Forecast], [Issue Technical Package Actual], DATEADD(day, - 14, [Quotation Received From Vendor Planned]) AS [RFQ Issued to Vendor Planned]...

Hi folks, A strange issue i'm having here. I have a view with a chain of dateadd()'s in it. They are calculating fine up to a point where i have a dateadd which should add 3 days to the date but instead it is adding 69 days. This makes no sense to me. DATEADD(day , 3 , [Change Order Issued...

Tried the NZ() function. Didnt work. I noticed though that if i change the Field Need Date that the FDD changes i really dont understand why the FDD doesnt update when the lead time is changed. Funny thing is the same query works on another database but not always which is strange. Some...

Date 1 is a value in a field though. I could post the entire query if you like its huge though.

Hi folks, I have a strange issue with a query based on a linked SQL 2005 table in Access 2010. The query is quite big and contains a chain of calculations where there are a number of columns which are calculated in a chain from one to another. I am having trouble with the final link in the...

I have a query with a float/delta column which is the expression: Float: [Date1] - [Date2] When I try to change the order by in the column filter drop-down i get a data type mismatch in criteria expression error. Does anybody know why I might be getting this error? Thanks in advance for...

I have a strange issue where im importing an excel using docmd.transferspreadsheet. I have a memo field which is importing fine and is not being truncated but I have another which is being truncated every time. The destination field is set to memo and the top cell in the excel is over 255 chars...

Hi folks, I have a database which has some SharePoint lists linked as tables. The database works fine when I am on the same network as the server but not via the internet. I can view the lists through the SharePoint site in the web browser from the web but Access cannot see the list unless it...

I did it! Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt As Outlook.Attachment Dim saveFolder As String Dim cmd As String saveFolder = "C:\IFF\ATTCH" For Each objAtt In itm.Attachments objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName Set objAtt =...

The accdb file is always in the same folder on my C: drive. The rule moves emails with a specific subject (containing "IFF") into a folder in my inbox called IFF. It then runs a macro which copies excel attachements from the email in the IFF folder to a folder on my C: drive (C:\iff) After this...

Hi I need to to open a accdb Access Database (2010) when I receive certain emails. I have a macro that needs to run before opening the accdb and I cannot change the order in which the outlook rule runs (the rule can open an application but not after running a script!) I have a rule set up and...

Thank you for you help! Much appreciated!! :)

What references do I need to run that code? * Thats ok found it (Active Data Objects)

Hi folks, I am sent regularly an XML file which I have to import into access. Sometimes however, the XML file is missing some end tags e.g: <T_COMMENTS> <COMMENT_NO>Comment 1</COMMENT_NO> <STATUS>Old</STATUS> <USER>User1</USER> <COMMENT>blah blah blah</COMMENT> </T_COMMENTS>...

:confused: I have a report with a lot of charts and graphs laid out like a large info-graphic. The report work perfectly in print preview mode but it doesn't show up correctly in report view, everything except for a few text boxes is blank, and when i re-size the form everything goes blank. I...