Recent content by JulianKirkness

Hi I'm afraid there is no way to do this - desktop and web apps are quite different technologies. Julian

A while ago the Access team set up Access User Voice where we can make product suggestions and vote on those made by others. There are loads of suggestions for Access Web Apps (which has it's own page) - but it would be great if there were more votes and suggestions. Here's the link...

Unfortunately, this is not possible at the moment. You are able to import from Excel into Datasheet views or into data sheets in the Access App but there is no way to automate this. An ideal scenario would be to have a data macro which ran periodically to read an excel file and append any new...

Hi One thing you could try would be to use a 'standalone view' as I describe it - presented to a user in viewer.aspx rather than default.asp. This basically means that you don't get all the Access Web App navigation. Here is a link to a blog post I wrote on the subject...

This would be quite straightforward - simply make the web Views (equivalent of forms) read only.:)

Hi - you definitely can use CreateRecord inside ForEachRecord loops (I have many times) so I don't quite understand why you are getting an error. It may be worth a) trying to use Aliases for ForEachRecord and CreateRecord actions and b) try using Data Macro Tracing to see where the error occurs...

It looks to me as though you are looking up a record in [qry_developedchecks] and then testing fields in [developedchecks] - could this be the problem?

Hi To be honest, I am not at all sure that this is possible... As a point of principle though, using a query as a rowsource for a combo box will require the query to be able to get everything it needs from the back end. One thing you could try is to save the ID of the current record to a table...

Hi Jared You're correct that you can't use VBA in Access Web Apps (AWAs for short). However, I have built a full blown HR system with self service features for employees to request holidays, process online Appraisals etc all with email based workflows etc. I have also created a CRM system and...

Hi You're correct that AWAs don't have append queries - so the only option open to you is to use a data macro to crete a new record and set all the field values you wish to duplicate. This could be called from a button in the UI. Essentially, the macro would: Lookup a record (the one to...

Hi As you know, you can't use either VBA or write SQL code in a Web App - so... The way I do this kind of thing is to write a value (UserDisplayName()) into a hidden field on the View (form for desktop users). This can be done with a macro or you could simply use the default value property...

I'm pretty certain you can't do what you want - because the datasheet is based on a query. I think you're best bet is to have a datasheet for entering the HrsLog data with a combo box or autocomplete control for entering the project.

There are no built in security features for protecting data in AWAs however there are ways to achieve it. You may be aware that you can find out the user's Email or Display Name from Sharepoint using the UserDisplayName() and UserEmailAddress() functions. One or other of these (note that only...

Hi Samantha I have been building Access Web Apps for about two years now - they are sold on the Sharepoint App Store - I have often run them on my iPhone and have just tried one of them this evening and it was working fine. One thing you could try because there was a problem a while ago is to...