Search results

The many-to-many table is what is causing the problem? On the form, they are selecting a reel that they are going to cut wire from. So they select X reel with Y footage and when they print the label, it needs to deduct the length from that reel. The overall process is: - The user select the...

I am trying to fix a query meant to update reel lengths on my main table after the user clicks the print label button. This particular process deals with a sub-form within a sub-form and is giving me a headache. The first sub-form has parent/child links to the main form and the second sub-form...

Mostly due to the nature of the process. They might select a reel only to later find the length was off and had to select another one. That is the main reason I separated printing from the act of selecting a reel of wire. After brainstorming over the weekend, I think I may have found a fix to...

I believe this thread is relevant to the problem I am experiencing: https://www.access-programmers.co.uk/forums/threads/continuous-form-current-vs-selected-record-on-cmd-click.277219/ Now that you have mentioned it, it makes sense that what I am seeing as maybe duplication is actually the...

Here are the queries involved (in the order they run). The first two just log the cut in tblCutLog: Write the cut to the cut log table: INSERT INTO tblCutLog ( CutReelID, StartingLength, CutLength, TicketID ) SELECT tblSingleCut.WireReelID, tblWireRoom.CurrentLength, [CutLength]*[CutNum] AS...

Attached is a snip of my tables and structure for reference if that helps Majp. I separated all the different types like this due to how I was initially asked to keep track of everything and I found it easier to build this way. I know it likely isnt the most correct way to do it but dont know...

I am not sure if this would belong in the VBA, Query or Forms sub-forum so if I got it wrong sorry! I have run into a problem in my wire cutting program where footage is being deducted incorrectly. Below is a snip of the sub-form. The sub-form is a continuous form to display all cuts for this...

The data does need cleaned up as I am currently just doing a data dump and uploaded that file to the database. I need to go through and normalize it for both size and performance.

Progress! My test was able reach the server, but was denied. I have to go through the permissions more I guess. Changing the name to the host computers IP did seem to do the trick though. Edit: Fixed the permission and they were able to connect, but they only seen system tables. Now I am at a...

Ill give that a try.

I used a guide that walked me through configuring the server to permit remote connections. I added those in an made a rule for the firewall to allow it through.

I have created the various login's within SQL Server itself and have created a DSN file stored in a shared folder on a server but when I try to link the front end on another computer, I get this error: I have created the login's on the server using windows auth. and have set the database to the...

That is what I ended up doing Arnel. The additional SQL statement in the WHERE clause is what threw my off for a minute. Also doesn't help I am bouncing between many languages this morning (DAX, M, VBA and SQL).

I used the wizard to create a find duplicate query: SELECT dbo_tblTicketDetails.[SOLineID], dbo_tblTicketDetails.[ID], dbo_tblTicketDetails.[Account #], dbo_tblTicketDetails.[Customer #], dbo_tblTicketDetails.[Customer Name], dbo_tblTicketDetails.[Account Name], dbo_tblTicketDetails.[Sales...

IT does not allow anyone to touch our primary system. We are allowed to write queries in a custom interface to extract data, but that is all we can do. Everything else regarding that software/hardware is off limits.

I am going to give it a go and see how it turns out. I am going to keep the aspects their own individual database (one for sales, one for PO's etc). I did also get in contact with our IT department and learned that our main systems database is currently sitting at just under 60 gigs but...

My boss considered not allowing a Power BI license for better reporting and it was like $5 a month :ROFLMAO:

I would LOVE to get my hands on Azure and learn with it, but that would be a hard no due to cost and restrictions from IT. The company uses Azure at the corporate level but not at the store level unfortunately. I know of MySQL, but have never looked into it. I will do some research on it.

I bank sales, purchase order and vendor billing. The vendor billing is tiny and honestly could easily remain in Access if I wanted it to. My sales is currently at 1.4G after just under 3 years and still needs 2 and a half years of archived data added so it is already going to exceed the limits...

To make sure I follow, so within a single SQL Server instance, I could have 3 different databases all of which could each be 10G for a total of 30G for that single server instance? And it is more of a theoretical problem then practical right now but if it had been 10G overall, that would have...