Search results

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 that can successfully remote into the BE at one time. Any thoughts?

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 maintenance in. Our office staff uses the database sa well. Right now, the BE sits on our server...

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 with the same "property assigned". I'm not very good at VBA so I've been using the "Create Macro"...

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:

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 right. Below is what I'm using. =IIf([FullRenewal]=No,[Report].[Test],[Report].[KeyPickUp]) I...

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 file and upload it to our vendor software. However, I need certain text to appear in cell "A1"...

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. Thank you again for the time you've spent and sharing your knowledge - I appreciate all the help!!

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 look at this at some point over the next few days (I am inspecting all weekend) and will let you know...

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 beautifully based on my testing thus far. One thing that I am unsure of is how to create the query that...

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?

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 everything works out. Again, thank you so much for taking the time... :):):)

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 reattached. 2A)I see what you're saying here - I initially thought it would be as simple as just...

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 signings, maintenance items, rent collection, paying the owner, etc. I need the database to be...

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 no doubt that you're correct... I am just not experienced enough to know what works best. I welcome...

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. When I run the query, if there are multiple applicants for one unit, the guarantors are...

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 functions well. I'll definitely get rid of those spaces and special characters. I have a lot to...

Sorry about that. Once I used ridders above fix for the space in the field name, it stopped asking for parameters. I then had to update the query properties to show "Unique Records - Yes". The code now looks like this: DELETE DISTINCTROW Roommates.*, * FROM Roommates INNER JOIN Applicants ON...

I got it figured out guys... thank you all so much for the time and the assistance!

Well then.... :( I tried back ticks around the field names and am now getting a message that says "Could not delete from specified tables"

You have to bare with me - I'm rather new at this!! I took snip its of both tables in design view - not sure if that helps?? Yes, there are lookup fields and the "Roommate Name" field in the Applicants table is actually a calculated field (Roommate Name=Assigned To)... reason being that the...