Search results

Ok... Bump! Some tell me it is a reference issue. Some say it is not... Nobody has been able to provide an answer. I am sure other developers have faced the same kind of issues. The application is working perfectly fine on any computer running full Ms Access, but once running on machines with...

I would expect that to be because of the difference between Date in VBA and the function Date(). Actually Date without brackets in a module is the same as VBA.Date Correct me if needed but that's how I would interpret the issue you just described.

Mihail, I have not tried yet but I would expect that the result is the same. I also have an issue with the function date() in the RT environment. Funny enough if you substitute Date() to Now(), it works fine. Even stranger, I have another Access application that use the function Date() and works...

Alright, if this is a reference problem, I guess that what I need to do is: 1. Get a list of all the files that are being used by the Access application 2. Get a copy of those 3. Include them in the package solution (with the Package Wizard) Am I on the right track or not?

I have tried it in a query and in a form (unbound field with the expression) I haven't tried it in a module. Do you mean I should create a VBA module and do this operation through coding?

Hi, There are plenty of documentation on this on the web but nothing that seems to help. I have a LEFT function in a query that does not work on Access RunTime 2010 while it works perfectly fine on Access 2010. Basically, I have a memo field called Notes and in the query I create a new field...

Thanks! I'll read the article tmrw as it is 1am here in HK. The reason I'm asking is just that I have an Access desktop application that was built for a split Access BE/FE configuration. Now I need to move those BE table to Sharepoint. The tables have data macros and my simple thinking was...

Hi, Is there a way to review / edit the actual SharePoint workflows in SharePoint created by Access Services after a web database has been published?

Can anybody help? Record Lock when an Update Query runs on a record in a SP list when that record is open in an Access Form. What would the work around be? Thank you!

Btw, I'm using SharePoint Online (365), which is the same as Foundation I believe...

The situation is exactly as you describe it. What would the work around be in that case? Should my macro close the form first and then execute the update query? Any other way? Another question (and apologies if it's not directly related to the thread) is there a way to keep table macros when...

Yes it is. It works very well in a local or linked table environment but not with Sharepoint. Why is that? What is the solution? Thank you for your help.

Thank you for the solution... But I'm still struggling with it. I have an update query that does not work because of lock violation. Well, actually it works if I run the query manually but if I run it from a form I get the lock violation issue. I have unchecked the Cashing Web Service and also...

Hi, I want to create a planning tool that has 36 tasks. Each task displays 10 weeks with a list of names (listbox with checkbox). I want the user to be able to click in these check boxes to select who is performing what task in what week (see the print screen). So, in order to keep a history, I...

Ok... No risk for SetWarning off, providing that your application is setup with necessary warnings to prevent users to screw the whole thing up. Hence, in the On Open event of all the Navigation tabs use the DoCmd.SetWarnings False Cheers

Alright, SetWarnings False for all the Navigation tab did the trick... However, now they are always off. What's the risk here?

Hi Paul, Thanks for your reply... Not sure I am following you on the "polite" part though. I cannot see where I have been impolite. I was just expressing the fact that I have been through all these threads but it seems that none provide a final solution, as well as my hope of getting a super MVP...

Well, I tend to do my research before posting anything... If I post, it really is because I couldn't find an answer anywhere else. So yes, these are the kind of thread I have read. I just hope that an Access super MVP on the forum would come up with a solution.

Ok, after a lot of reading: There is a difference between Standard Macros (SM) which are independent and Data Macro (DM) which are bound to tables. When you split a database into FE and BE, these both work independently. This means that a SM cannot call a DM. DM will still work within the BE...

How can you stop this prompt? I have checked everywhere on internet and cannot find an answer! I have a Navigation Form in Access 2010. First page has two subforms: Datasheet1 and Chart1. Whenever I click on another tab of the Navigation Form I get the mentioned prompt! (unless I do a control+s...