Recent content by gwunta

Hi all I have an Access 2010 application that talks to SQL Server. Part of the application creates tables on the SQl Server and inserts data to it (I know SQL Server has its on data inport/export wizard and bulk insert capabilities but for reasons outside of my control it needs to be done from...

I know this is an old thread, but since no Access based solution has been suggested I thought I would post the solution for reference. You CAN conditionally format results in a query. In query design, go to the field you want conditionally formatted, then in Format property of the properties...

Thanks guys. Maosc I checked the properties, the Display When property is already set to Always so that is not the cause. DavidAtWork, I would really like to do that, but essentially its still building a query and because the data sets are so disparate, this is not a viable option. I would...

Hi guys, not sure sure if this is a shortcoming of Access or programmer error (most likely the latter). I have a report with quite a few subreports in it. There are a number of calculated fields on the form, most of which use Dlookup to retrieve at least one of the figures required for the...

Re: Return current view of report - Solved OK solved the issue. There is a way to determine the state of any Access database object. MSDN details it only applicable to Access 2003 but I tried it an it works in Access 2007. The code is as follows: SysCmd(acSysCmdGetObjectState...

Hi all, just wondering if there is a VBA command that returns the current view of the current active report. I am running code the uses the SetFocus Action, which works fin in Report view, but when I try to go to Print Preview view, Access throws an error stating that the command or action is...

After some investigation, I found that the table I am trying to update with the query is slightly different in its definition to the source table, hence the type mismatch error. The table I am trying to update is linked from a SharePoint list and uses a lookup to populate the field in question...

Hi all, Im hoping there are some people around who have worked with SharePoint and Access before to help me out with this one. I have been tasked with expediting the report generation based on SharePoint (SP) lists at work. The SharePoint server is located in Sweden, while our office in Perth...

You take extreme offence at my 'attack' after attacking those who choose to have tattoos and piercings? Its a bit different when the shoe is on the other foot isnt it? Mate, if I was so involved in self pity there is no way in the world I would have achieved what I have. I wouldn't bother...

Thanks Galaxion. Yes, I completely agree with you, special characters should never be used, unfortunately the people that developed the SharePoint lists didn't have the knowledge to do so, so even if I change the names on my local copy of the lists, the query to update the SharePoint version of...

OK so I found the issue - the hashes were being converted to full stops - arrrgghhh the curse of the programmer - cut and paste :banghead::banghead::banghead: So it now executes - to a point. Now I am getting a message saying that the records were not updated due to record locks. Could this...

Rainlover, it deeply disturbs me that the attitude you portray still exists in the minds of business people in Australia. Yes, I have tattoos, no they aren't visible under a long sleeved business shirt, but it does not seem to matter to you. What if I had no tattoos and a disability? It seems...

Thanks for the suggestion but I am not calling the query in any code at this point. I wanted to make sure the query executed correctly before I implemented any code that leveraged the query.

Hi all, I created an update query that is designed to update the data in a linked SharePoint. I have created the query fine but when I try to execute the update query I get an error stating: 'qryAMYPOCUpdater' is not a valid name. Make sure that it does not include invalid characters or...

Can anyone help??? Is there anyone out there who has any thoughts on this, even can suggest making a new query. I thought choosing a range like this wasn't that difficult. Cheers