Recent content by SoleAris

I also am still wondering in the specified query above why it works in NaviCat just fine but not in Access. I have checked and there is a T_ReportCodes table present and in NaviCat it clearly recognizes the table, yet in Access it can't find it?

So why are pass-throughs used in Access then? I was under the impression that keeping the tables completely out of our front-end was the idea here. Obviously it would be much easier just to have linked tables and then use our already existing front-end then? What potential drawbacks are there...

Hi everyone, My company has decided to stick with MS Access as the Front-End UI for our basic needs with the backend being held on a local SQL Server. I am in the process of writing pass-through queries that I will then build forms and reports from within the UI and am having some trouble...

Hi all, I have a database table in which I'm trying to pull sales data and generate sales reports from. The problem I face is that the sales data is recorded into a table with this structure: Year | Customer | Sales_Month_1 | Sales_Month_2 | Sales_Month_3 Rather than having a single field...

The tables are linked to a SQL Server back end. In past versions, there are only 2 users other than myself who access this database, so we've kept it as a single copy. Probably would be best with this new version to give each user their own copy of the database.

Hi all, Been actively trying and searching for a solution, however to no avail in the past couple of days. So here I am. I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database (through RunTime). I was hoping...

Yeah, edited my post because I found the real problem..I guess I somehow missed changing that name months ago when I transferred everything to a single backend

Aha! The Name is where it's located as "T_Requests"..had no idea that I needed to change that from the original table source. Such a small, yet frustrating mistake! Thanks for the help Paul, you were awesome!

Bizarre. Rather than putting in the actual table name "T_Machines_Requests" which is a naming convention we used to define child tables in relation to their parent table, using "T_Requests" works perfectly..But for the life of me I can't find a single record source that uses T_Requests!?

Converted the tables to local tables. My apologies for not realizing that earlier. Thank again for the help! I'm continuing to attempt to fix it on my own as well~

This gives me an "application-defined or object-defined error", which is one I haven't gotten myself yet. This may not help, but I was able to use the "DoCmd.OpenForm" alternative, which made the subform it's own window. From there, it was extremely simple to fill in the information needed...

Done. So for clarity purposes as you look at this: The main form holds the general information for each machine with subforms in a tab control for that machine underneath the basic information. Here you'll see 5 subforms, ranging from Notes to Breakdowns of a machine. The ones I am...

Alright, so I am still a little bit stuck with this today. That link is a great guide that you posted, however I am confused as to where my situation fits into that scheme. When I attempt to write my code, using the "Me." logic prompts controls within the Preventive Maintenance subform, since...

I didn't think so either. I have tried different variations such as: Forms![SF_Repairs].[Date] = Date Forms![SF_Repairs].[Date] = Me.Date (If I wanted to reference specifically the value in my other subform) And others, but I seem to keep getting a missing/invalid reference to either the...

Hey everyone, I have a Form that keeps records of each Machine my company has. It contains a Tab Control with 5 tabs (pages), each containing one subform in them. In one of these pages, I have a Preventive Maintenance subform that contains records with information. One of the fields (Repairs)...