Search results

OK - I had a database that was working pretty well on Friday. I opened it up to test something today and all of a sudden my form stopped working. It is a simple form - see attached photo for the form view. When I click on either button I get the error in the attached JPG. Here is the code for...

Hey all. I don't know if this is something realistic or not, but here's what I want to do: I will have a PC and a number of scanners in a production line. I will need at least 15-20 scanners and would like to plan for more if needed. When an operator clicks on a button I would like to have...

I'm sure I'm missing some sort of parentheses or something simple, but here goes. I'm trying to run the code below. The basic idea is that I need to insert a record into a table and then return the Key field so that I can use it to populate another table. This was working just fine for a while...

OK all, I think this should be relatively easy, but I'm getting myself confused. I have a table with: A dDataID (sequential auto-number) B dDateTimeEntered (date/time field) C dFactoryOrder (text) D dSpecificationID (number) E dStartWeek (text) F dIncreasingDecreasing (text, values are limited...

From some discussion in another thread (http://www.access-programmers.co.uk/forums/showthread.php?t=266376) it was suggested that I post a question here regarding table design. Attached is a copy of my DB. I'll mention right now that this is half-completed (if that). The short explanation of...

OK, I'm having a lot of trouble with this today. Hopefully this is a simple fix. I have a form (SPC_Data_Entry_Display_Form) based on a table (Data_Storage_Tbl). Each of these records has info about when and where a measurement was taken. I want to record the measurements in a separate table...

I'm cross-posting in this forum since I haven't heard anything in the VBA forum yet: ___________________________________________ Hey there. I recently upgraded a DB from 2003 to 2013 and ran into the following problem. I have a button that opens a file dialog box and allows the user to...

Hey there. I recently upgraded a DB from 2003 to 2013 and ran into the following problem. I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and...

Hey all. I'm back again. I have a main form and subform set up where the main form shows a work order and the subform allows the operator to enter various materials required. I'd like to set up a button to print up a purchase order for all of the items entered, then set the "order date" for...

I'm not sure if this is the correct place to put this, but... I'm going to be creating a database where one of the functions is to provide access to a certain file associated with each record. I'm using Access 2003, so I think I want to link to the files rather than store them directly. So...

OK, this one is bugging the heck out of me. This worked fine until two days ago, and now it just stopped and I can't get it to work. Basically, I'm trying to do a couple of functions with a button. I want to: Populate a couple of fields based on data that the user entered Save the record Print...

Hey all. New to the forums. I've done some basic stuff in Access before (mostly data mining an queries), but I'm relatively new to forms, reports, and VB so please bear with me. My problem is this: I have a form that I want to print. The form has some data up top, then a subform that...