Search results

*Using Access Web App in Access 2013* Hey Folks, I've got two tables CustomerSites and CourtesyCalls. I've placed a new ActionBar button on the CustomerSites view to enable people to log a CourtesyCall to that site. The CourtesyCalls log is linked to the CustomerSites table via a Lookup to...

Hey, are you using A Web App or a 2010 Web Database? If it's a Web App then it sounds like you need to open the query designer and click the parameters button at the top of the page. You'll need to declare the parameter here (make sure you use the correct data type or you might get a conversion...

Hi Guys! I've recently built my first web app for work and we're really happy with it. I've hit a few snags along the way but with a little help and Jeff Conrad's book I've managed to navigate most of them. I have been using the UtterAccess forums but it's not very active there so I'm looking...

Thanks Minty - yeh I was hoping to be able to attach the functionality to one of the action buttons but it looks like that's not possible. I've defaulted to using a static Hyperlink control with a static 'Help' text for each form I'm using. Cheers for the help anyway! N

Hi Minty, :( I can't get this to work. Is this for Access only or do you know for sure it works with Web Apps? It just won't save the new command.

HI All, I don't think it's possible but i wanted to ask: is there a way to configure a customer action button / or any button to open a hyperlink? I'm creating some help documents for the end users and would like a '?' action button which opens the relevant help doc for the page. Help docs will...

Does: Table ConditionAuditcomments View ConditionAuditcommentslist Where [ConditionAuditcomments].[ID]=[IDTextBox] fix it by any chance? assuming that ID is the ID field in the ConditionAuditcomments table?

Hey Aubrey, Don't know whether it helps but you can call the same functions the action bar buttons call as well as run a macro too. e.g. you can delete the Save button and replace it with another button with the same icon which you can make do the following: - Save Record - Run data macro -...

Yeh, I'm being a bit dumb. The solution to this is to: - Create a visit lines table which has a serial number lookup to the Instruments Table - Create a separate field in that table with a instrument description lookup to the Instruments table - Disable the Description field, preventing the...

Hi Folks, I want to allow users of my Access WebApp to upload files to our SharePoint site and then place a link to that file's location from within the app. To migrate existing data, I've uploaded all the files and I've created a table from the SharePoint list, importing the file names (a...

Err. OK, sorry I'm lost. I already have three tables set out: Instruments, Visits, Visit Lines. Instruments contains something like: Serial Number Location etc Visits Contains Visit ID Site Visited Date or Visit etc. Visit Lines Contains Visit ID [links to Visits table] Instrument Serial...

mind you... it might have been helpful if I'd actually mentioned the fact I'm using a web app in the question... {face palm}. Sorry!

Apologies Ranman, I am still pretty new to all this but is the answer you posted related to Access proper or to Access Web Apps? It's a web app solution I'm needing but I don't recognise where I would put that code into the web app system. I'm likely being dim though... N

Hi All, I have two tables to track our engineer visits, one tracks the visit as a whole and the other tracks the individual instruments the engineer worked on during that visit. This way I can track visits to customer sites separately to the visits made to an individual instrument. Right now...

Ah thanks spikepl - I hadn't realised this; I found the board through JeffConrad's responses to Jayne in the long post below which was very helpful. I thought this was the place as a result. I'll repost in the WebApp forum and ask a Mod to close this thread. N

Hi All, I have two tables to track our engineer visits, one tracks the visit as a whole and the other tracks the individual instruments the engineer worked on during that visit. This way I can track visits to customer sites separately to the visits made to an individual instrument. Right now...

Hi All! I have a the beginnings of an Access 2013 Webapp which I'm using to track the laboratory instrumentation we cover at work. My ultimate goal is to use each service engineer's visit records to help create a full service history for each instrument. My issue right now: Each instrument in...

OKay, I figured it out. Following the part in the macro where you set the new reference to the local variable value, the variable value needs to be set to 'Null'. Otherwise, everytime the lookup fails and there's no value which corresponds to the old reference the macro just input the variables...

Jeff, I wanted to start by saying thanks for going to all that trouble - it didn't just help Jayne it helped me immensely. I've now got my head around the way the lookups work but I am having a few issues with macros populating those ID values: The main issue I have is that blank or unmatched...