Search results

I developed the attached database to track parts at my work. It has been rewritten with new features a few times but it just keeps getting slower and slower to use. I was hoping someone would take a look at it and tell me if it is just beyond the scope of access or if there is something that...

I am working on a piece of code that takes a bar code as input and modifies the related record. It all seemed to be working okay but I have found that if you scan the same bar code twice it gives you an error about the record not being able to be edited because someone else is editing it. It...

I am trying to reduce the size of a report I have by hiding any empty columns or columns with a "None" value. After searching around for a while I found this http://www.utteraccess.com/forum/Shrink-empty-textboxs-re-t1955986.html&gopid=2045156#entry2045156. I thought it was going to work great...

Have attached a mock-up of what I want to do. I am not sure if it something that is possible. My google searches did not turn anything up so I was hoping someone on here might be able to point me in the right direction. I tried using tooltips to do this but the amount of text is kind of limited...

I have a form with a subform on it. The subform is linked but the field Order_num. The field name is the same on the subform and parent form. When I file out the info on the parent form specifying the Order_num and then go to add the info on the subform it does not populate the Order_num field...

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...

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...

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...

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 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 am looking to incorporate thumbnails similar to what can be seen in windows explore for non bitmap file types such as IDW files or PSD files. I am not even sure what could be used to accomplish this. I am pretty sure explore uses a dll to render the thumbnails it displays. I don't know if...

I am trying to create a new table using a macro however everything i run the function it tells me that the table can't be locked because it is already in use. I added a command to close the form the macro is launched from because the table is used on that form but I still get the same error. I...

I was wondering if anybody knew of a way to to create an automatic OLE attachment base on a specific field. What I was thinking was adding an OnUpdate function to the field I want to use and after it is updated it look for a jpg with the same name to link to the OLE field for that record...

I am working on a database that manages parts for a plant. It is set up with an access front end and a Mysql backend. I have a table called tblParts. This table contains all the information about each part inclueding an field for a blueprint. I originaly had the backend set up in access and then...

I am wondering if there is a way to display a pdf file that is attached to a record from a report. I know access will do this for jpg files but I need it work for pdf files. Any ideas?

I work at a manufacturing plant and I am currently working on getting an inventory system set-up to track parts. I have it all done and functioning except for one part. My plant builds large farm equipment out of several hundred different parts. My current system keeps track of these parts...