Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 34
Search took 0.01 seconds.
Search: Posts Made By: HeatherO
Forum: Queries 07-02-2018, 02:45 PM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

Yes, the database will be split. The users will be logged into IPADS, in to a virtual desktop on our server. We get part time help this time of year because all of our apartments turnover at pretty...
Forum: Queries 07-02-2018, 11:59 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

I need to create a very user-friendly form that is easy for our inspectors to follow. As I've stated, this has been done 100% on paper for the past 20+ years. The way that I had this set up before,...
Forum: Queries 07-02-2018, 10:41 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

I actually have a database with all of the units and tenant information. We are very new to using Microsoft Access here. Everything has always been done on paper so we are building out our...
Forum: Queries 07-02-2018, 10:05 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

I think I am understanding what you're telling me and honestly, I can't believe I didn't put this together before. Grrrr...

Can you look at this for me and see if I'm on the right track?

Where...
Forum: Queries 07-02-2018, 08:44 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

I'm trying to wrap my head around this now but unfortunately, I only have a few days to either 1)make what I built already work or 2)redesign everything (on top of my other duties). I sure with I...
Forum: Queries 07-01-2018, 10:03 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

Absolutely. I appreciate any feedback/advice!!
Forum: Queries 07-01-2018, 09:44 AM
Replies: 16
Views: 482
Posted By HeatherO
Re: Need Query Help!

No, i dont have one table per item. I have multiple tables because I can only have so many fields in a table and our inspections literally cover every item in the apartment, right down to electrical...
Forum: Queries 07-01-2018, 09:11 AM
Replies: 16
Views: 482
Posted By HeatherO
Need Query Help!

I have myself extremely confused :banghead: My company use to do paper move-out inspections and we are now going to be doing them electronically. The tables are set up as follows...

KitchenFloor...
Forum: Access Web 05-11-2018, 07:07 PM
Replies: 5
Views: 1,998
Posted By HeatherO
Re: Remote Access to Database

The users would remote in to a virtual desktop that is housed on the same server as our BE. The FE is saved in that desktop.
Forum: Access Web 05-11-2018, 05:36 PM
Replies: 5
Views: 1,998
Posted By HeatherO
Re: Remote Access to Database

Today we were able to successfully connect to the BE using VPN. What would be the advantages of using SharePoint instead? Isn't this being phased out? Also, we are concerned about the number of users...
Forum: Access Web 05-11-2018, 10:10 AM
Replies: 5
Views: 1,998
Posted By HeatherO
Remote Access to Database

Good Afternoon,

I have built an Access database that I need our inspectors and maintenance technicians to be able to connect to (via an IPAD) from the apartments they are inspecting or performing...
Forum: Macros 09-21-2017, 12:55 PM
Replies: 1
Views: 469
Posted By HeatherO
Emailing a Report

I have a table called "Applicants" which lists applicant names, email addresses, and property assigned. I want to add a button to my form which will automatically email a report to all applicants...
Forum: Reports 08-14-2017, 12:30 PM
Replies: 3
Views: 532
Posted By HeatherO
Re: Select Sub-Report Based on Field Value

No luck with that. However, I did change the formula from [Report] to [Reports]. That eliminated the parameter boxes but now in report view, it comes up "#Name?" :banghead:
Forum: Reports 08-14-2017, 08:41 AM
Replies: 3
Views: 532
Posted By HeatherO
Select Sub-Report Based on Field Value

I am creating a report called "Move-In Letter". The first paragraph of the report will be a different sub-report based on the value of one particular field. I cannot seem to get the IF statement...
Forum: Queries 08-10-2017, 09:48 AM
Replies: 1
Views: 303
Posted By HeatherO
Exporting a .csv File

I have created a macro that exports my query to a csv file. The plan is to set up a task to automatically run the macro at various times throughout the day, and another task that will then take the...
Forum: Queries 08-08-2017, 06:02 AM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

UPDATE: I figured out how to do the report based on your suggestions!! I am currently working on building it out. Everything seems to be working great so far, based on the testing I've done. ...
Forum: Queries 08-04-2017, 02:59 PM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

I am just now seeing this - was out inspecting apartments all day. Yuck!!

I am familiar with a cross-tab query. I think what I don't understand is how to to create the report. I will take a...
Forum: Queries 08-03-2017, 02:01 PM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

Would you be proud to know that I actually figured that piece out before I read your response? Maybe there's a brain in this head after all?? :D:D:D

I have this set up and it's working...
Forum: Queries 08-03-2017, 09:14 AM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

I have attached the relationship summary - does it look correct? I am not understanding what I need to do with the units table? I think it should have a one-to-many relationship with residents?
Forum: Queries 08-03-2017, 07:40 AM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

Wow - this absolutely makes perfect sense to me!! You have given me so much to work with and for that, I am extremely thankful!! I am going to get started on this today. I will let you know how...
Forum: Queries 08-03-2017, 05:48 AM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

Thank you so much for the feedback!! I will take a look at those example databases.

Plog- To answer your questions...

1)For whatever reason, that table wasn't showing... I have updated it and...
Forum: Queries 08-03-2017, 04:47 AM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

I work for a property management company. We manage around 1,900 properties - some student rentals, some professional, and some commercial. We are responsible for everything from the showing, lease...
Forum: Queries 08-02-2017, 02:04 PM
Replies: 17
Views: 857
Posted By HeatherO
Re: Query Duplicating Results

I tried DISTINCT and wasn't successful.

Please bare with me - I was tasked with creating a simple database for work, and it has taken on a life of it's own. I'm learning as I go.

Plog - I have...
Forum: Queries 08-02-2017, 12:49 PM
Replies: 17
Views: 857
Posted By HeatherO
Query Duplicating Results

I have a query that uses 3 tables - Units, Applicants, and Guarantors. Each Unit is unique but could be assigned to any number of applicants. The guarantors are then tied directly to the applicant....
Forum: Queries 06-20-2017, 07:36 AM
Replies: 22
Views: 648
Posted By HeatherO
Cool Re: Delete query asking parameter value?

Understood.

I will work on getting this cleaned up. This was suppose to be a very simple database and just keeps growing (our vendor's software is not working properly) so I want to make sure it...
Showing results 1 to 25 of 34

 
Forum Jump



All times are GMT -8. The time now is 04:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World