Recent content by EFox

Hello all, First of all, I just want to say that I am upgrading to a newer version of Access for a company as they were on Access 97 (first time upgrader). They are still currently using this old version until I complete the upgrade. I upgraded from 97 to 2003, and eventually I need to upgrade...

Ignore this post. I found out that the previous developer used a DLookup on most of the reports. I removed them and my response time went back to the way it should have been.

Hello! I migrated from Access front and back end to Access front and SQL back end. I started by hosting a local SQL server locally on my machine, and now I am ready to push it out to a hosted SQL server. We moved the back end to a local server on site to test with and I noticed some latency...

I have been looking through SQL documentation, but I thought it was a little strange that I couldn't even open the application in development mode using the shift mouse clicks. It could turn out to be all a SQL issue but I just thought that part of it was strange. Thanks for the reply.

Hello, I have two applications that are identical except for which database they connect to. These are Access 2013 applications that connect to a local SQL server that has two databases (one for each application, the only difference to the apps). Both applications function fine on my local...

I understand what you are saying, and I appreciate your concern. The owner has 1 apartment complex, and this is just one of his side businesses. There is 1 apartment manager on site, and everything (currently, even the new SQL db) is stored locally on that managers computer. So only one person...

One person at a time. It is an apartment manager application loaded only on 1 computer. The owner remote desktops into the computer when he wants to look at things. When I first started to take over the application I migrated the back end to SQL 2008 because he wants to eventually make a web app...

Yes I am sorry for my bad lingo. I am only 4 weeks into upgrades/changes to this access application and I had no experience with access before this! I really apologize and thank you for sticking in there with me! Attached are two pictures. One of the form in design view, and the other in form...

On my previous post I inadvertently said I was going to print them from a report(fingers were typing faster then I was thinking!). What I really meant to say is I have a form, that was created before I started working on this application, that displays the query in a "child" box(form) on the...

Hello, I have a query that simply pulls back each tenant from a tenant table. Each row has a bit field that I use for check box's. This check box is true or false depending on the balance they owe. I currently use it to print off late reports and people that have this field set to true have a...

As soon as you asked about the grouping on the form I thought back to when the form was created and it probably set a default sort by to the unit ID (which is the first field in the group. I right clicked on the transaction ID and enabled sorting on that and everything works great! Sorry for...

Hello! I have a query that I am using to pull transactions from a table. In the query I sort by transaction ID in ascending order. When I run the query the datasheet view looks perfect, sorted by transaction ID. However, when I run my report it no longer uses the sort that was created by the...

Hello, I inherited an access application front end and back end and I changed to a SQL server back end. There are fields that seemed to auto increment from a previous record number (no not primary key that is set to autonumber). These fields are never given a specific value, but from previous...

I just wanted to thank BlueIshDan for helping. It turns out after we got the query working properly that I needed to just recreate the report. I'm not sure why it fixed my problem, but thanks for the help on my query!

I assume that for the field it needs to be: DepositMonthlyQuery.* and not just the * I got an error when I chose the query as the table and only input * as the field. When I run it this way it pulls back each record per date, but it is giving me a copy of them. So for each date I have 2...