Search results

All that is correct about my code. My code works as is but I will update it as you suggested. This isn't what I am needed help about though. Like I said the result of me canceling a delete is the same whether I do it with VBA or if I click the cancel button with it asks if you are sure you want...

I am simply using the delete key. I then run a BeforeDelComfirm Sub with this code. Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer) If DLookup("[Job_Num]", "[Work_Details_tbl]", "[Job_num] =" & Chr(39) & JobNumber & Chr(39)) = "" Then MsgBox "Order Deleted" Else Cancel...

When I delete records in my database it brings up the are you sure dialog like it does for everyone how ever when I click cancel or no it still deletes my records. It fills all the fields in with #Deleted. Up until now this hasn't been a problem because I haven't been deleting things unless they...

Thank you I appreciate your input. I don't have a set of business rules to satisfy unless I am confused about what you mean. I do have relationships set up for all my tables. It might have dropped them when I converted to mdb. I will take a look at the setting up some transactions and seeing...

Here is the same database again as a .mdb file. The VBA that I removed just has to do with loading images and checking quantities. I thought I should leave the real data in there so I can demonstrate the level of complexity it gets to. However if you would like to see a copy of the full database...

I uploaded a sample of the database so you can get a better idea of what I am working with. I had to remove some of the vba and all the reports to get it down to the right file size but I am mostly curious about my table and query structure. It seems to me that there should be an easier way...

I wrote a database a few months ago that tracks inventory for a manufacturing plant. Some of the features include ordering parts from our in house Fab department as well as tracking these orders and tracking the equipment orders we get from customers. At the moment I have all these features...

Worked great. Thanks for the help.

Public Sub PrintDrawing() ' Set a reference to the print manager object of the active document. ' This will fail if a drawing document is not active. Dim oPrintMgr As DrawingPrintManager oPrintMgr = m_inventorApplication.ActiveDocument.PrintManager...

I wrote a shot app in VB.net that sends a file to a pdf printer. It works just fine however I have now installed it on the end users computer and his complaint is that if he wants to print the file after it is sent to the pdf printer, he has to select his printer from the menu. When my App...

I will look into it. thank you.

Okay that was the conclusion I had come to. Do you know of any other good way to host image files remotely and link them to access?

Yes and no. The images are on an ftp server but I would prefer if they were downloaded to a temp file. Like what happens if you were to go to a FTP site in your web browser. I just need to be able to display the image in my database so the user to look at and print off as part of a report. I...

My access program needs to pull images off a server to be used in my application. These images get updated frequently and there for storing them on the local machine isn't really an option. Currently all the computers using my access program are on the local network so I have been using a local...

I fixed my problem using simple IIF statements. I thought I would post it so if anyone else ever has the same problem they know how to fix it. Also if this is a bad fix please let me know. Ryan

I attached jpgs showing my tables and how the data relates and my current queries. I hope this clears some of the confusion up. The problem I am having is that after I get part totals from qrysubinsub and qrypartinsub, I can't get them to combine together to show me all the parts that are...

I am working on a database that calculates inventory. It has to be able to calculate the inventory of single parts based on sub-assemblies and assemblies. For example, We received (10) partA and (20) PartB. We then Build (2) Sub-AssemblyA which uses (2) partA and (1) PartB per Assembly. The...

I ran across this VBA program (http://www.lebans.com/Magnify.htm) today and after messing around with it for a while I can think of a few uses I could have for it if I could make it re-render the images it is magnifying. Right now it just simply takes the image as it appears on your screen and...

I tried an older version of viewer but it doesn't seem to help any. Has anyone else run into this problem and been able to fix it? Ryan

I am going to try a 32 bit version of inventor view and see if it makes any difference.