Search results

Hi folks, Hope somebody can help. In our database we have reports that are generated and need to be exported as either PDF or XPS files. We have a system where users can 'sign' documents by entering a password to add a scan of their physical signature. This is not sufficient for our needs...

I have an Access 2010 frontend which is linked to a view on SQL Server 2005. In the table if i enter a value in one field it will change the selected record to another record and auto fill the other fields with the data from that existing record. There is an identity column which should...

Hi folks, I have a form in datasheet view which is linked to a view on SQL Server 2005. When i open the linked view directly I can add/update records as usual without error. When I try to add a record through the datasheet form I get error #4405 "View or function 'dbo.Q_PSR_P6_FND' is not...

Just wondering is there any way to capture a window restore event (not a maximize) in Access 2010 VBA?

Hi folks, I have an annoying issue which i cant see the solution to so any help is much appreciated. I have a table with a number of columns. Most of the columns are computed columns, from the 3rd column on my formula is causing the error "Error validating the formula for column "Quotation...

Hi guys, Another SQL server issue. I have a view which consists of 2 tables in a left outer join. This view is linked to my Access frontend (Access 2010, SQL Server 2005). The view should be updateable but when a user tries to add a new record it comes up like this: #Deleted #Deleted...

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...

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...

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...

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...

Hi folks, This is a weird one. For some reason on my copy of Access installed on my work computer the Package Solution Wizard is in what appears to be French. How can I change this? jpg attached.

Hi folks, I have a bunch of .jpg files which reside in the same folder as my database. What i need to do is rename all of them at the click of a button. My database has a table with a column that lists all of their file names. What I want to do is add a column to the table that lists the new...

Hi folks, I am having an awful problem. I have an xml file structured like this: <root> <T_IMPORT> <VIEW_NAME>0001</VIEW_NAME> <IMAGE_FILE>0001.jpg</IMAGE_FILE> <T_COMMENTS> <COMMENT_NO>Comment 1</COMMENT_NO> <STATUS>New</STATUS> <USER>user1</USER>...