Search results

Yes that would be the best practice, but I am having trouble getting a calculated field to work in my query. If i'm looking at this right I need to modify this: DateDiff('d',#15/10/2003#,#22/11/2003#) to calculate the time in minutes between Endtime and StartTime. So 'd' would be 'n' for minutes...

Access 2013 Web App: I have an activity start time and end time and would like to calculate elapsed time. How do I set this up in a calculated field on the table. While I am on the subject, is there a way to use a date field calculation to return the name of a month, not it's #. Thanks

I only wish I could use vba but alas this is the Web app and it is not allowed.😯

In my Office 365 Access app, I have a table Activities, a table Contacts and a join table for activities/participants (contacts). In my form for entering/editing an activity, the related item control would be the contacts assigned to that activity, all fine. Now when I pop up a form to assign...

I am trying to design my web app for ease and efficiency and I am kind of stuck in several areas. The first is as follows: In my db I have a contact table, like my big general address book. I have forms set up to get all the data pertaining to each Contact, into there, however, I also have to...

No neither of those. Just a query based on a table.

I have a query based on a single table and for some reason when I view the results they are not able to be edited. In other similar table/query set ups, this is not the case. What am I missing or do I need to change to make it possible to edit the table, i.e. add records when using this query in...

Actually I agree with you, I was looking at it from a weird angle, and I when I stepped back, I can see your point. If I enter everyone as a contact in the contact table, perhaps what I need is a related table object to enter the first contact data for that contact which stores the data...

Actually, I already do that from the main contact table when a person is no longer part of our organization. What I need to do is partially automate adding a specific kind of contact to that main table, while keeping a table of them for another purpose. Like this, Susie Kabloozy calls us to get...

In my web app I have contact table / list for associates of my organization, staff, volunteers, clients. I need another table for a specific kind of contact, call these potential clients, some of whom will never be added to the associate table, but that I still need to track, some but not all...

Not sure what these are called in the web app environment, but what I need to do is this: I have a table view set with a list view for adding new data to the current record. So table Team view gives me a current team. Related control Assignment List, lets me add people to the team. Ok, so far...

I realize this is an old thread, but your excellent resource helped me solve this exact issue. Now I have another question. My popup view shows all members in a specific location. Is is possible to set this up so that when I click in the popup on a specific member, the main form with all that...

I found an old thread that covers the exact issue I'm having. Not sure if I should post in that thread, pm the person who was so helpful on it, or start a new thread here? What is the best way to handle this? The solution for the original issue was looking like what I needed but it involved...

Thanks for the links, some of that was new info, and helpful, but still doesn't help me resolve the problem I'm trying to solve. I appreciate the help though.

I am building (rebuilding) my db as a web app and running into several struggle. My main challenge is not finding any good step by step tutorials after the basic "how to get started". I have found nothing online that explains in simple terms the various parts, how they work, and more importantly...

Well that's a step in the right direction except, I want my end user to see, and the choices available before appending, and be able to select them not have to enter them in manually. and I don't need to choose the contact because this would be on a subform with the main form being one contact's...

I would like to use a listbox set to multiselect to add records to a junction table. I've been using code to accomplish this with checkboxes (love how it looks and works) but after moving my tables to Office 365 as the backend, linkedto a local frontend, sql does not like this particular set up...

The whole no VBA thing is one reason I am working hard to make a hybrid approach work. At this point I am trying to see if moving the tables to my site as a backend, and then pushing the whole thing to a web ap (which I may or may not ever use) as a front end that can be shared, is the right...

I have an existing database in 2013, and I just got Office 365 with a Sharepoint site up and running. Now I'm trying to wade through all this, esp the differences between using Sharepoint and creating a web app. As I understand it, if I use a web app, I will have to rebuild quite a bit of my db...