Search results

I have a python script "runAll" that takes two arguments: processID (the primary key of one table as a string) and a filename (a full file name path as a string). Is it possible to run a python method with arguments from inside a VBA script (activated by a button press)? If so, could you please...

I'm (re)normalizing a database that I designed with one mistake last summer, and has had many mistakes implemented since I last worked on it. I've normalized the back end of the database, but I need to update and revise the front end to properly access and display the reorganized information to...

My employer wants me to update and revise a form with almost a hundred controls. All of the information is stored in a single table. Is there a way that I can (easily) sort the order of columns in the table to alphabetize them? I know how to sort and filter records, is there a way to sort the...

I was just given the project of creating a database to store and access information that the various engineers involved in design and manufacturing can use to create updated instructions and load information into their modeling software efficiently. I have *some* experience with database...

I'm working on a form with almost a hundred various fields (it's what my employer needs). He wants to be able to create new records with much of the same information as the old ones by clicking on a button that will copy the information to a new record, then clear certain specific fields (or...

I need to find a way to print the currently selected record (by clicking a button in the form) as a form. I know printing is almost always done in records, but they use the forms by hand before entering them into the computer database. One tough part of this is that this printing function needs...

Hello. I'm receiving a "Error 3464" data type mismatch error from the code below. DoCmd.OpenForm "AllEmployees", , , "[OPERATOR_ID] =" & (Me![SearchResults]) OPERATOR_ID is a text primary key (from the network, not my creation), and SearchResults should be returning a string as well. I don't...

Hello. I'm trying to make a report that a untrained user can use to review the relevant data from the database I'm creating. All of the work I've done so far has been directly in the tables (as I'm still in the design phase and am not experienced in forms or reports). Here's a quick outline of...

I'm working on the user-input end of a database used to track training proficiencies and how up to date they are. In the form I'm working on at the moment (of which I attached a picture), the user selects a department from the combo box (which filters the first subform of employees), then...

Hello. I am working on a form with two subforms. Based off of a combo box selection in the form, the first subform pulls up a list of names. What I want, is for the selected name in the first subform to control what the second subform pulls up (a list of training competencies that each person...

Hello. I'm working on creating a database (upgrading from an old manual excel table system to an Access system to improve user-friendliness and organization) that will help track, update, and review employees' training certifications are up to date. Each table for the different areas of the...

Hey, I'm Peter, I'm a Junior at Rose-Hulman Institute of Technology. I've taken plenty of programming courses, but I've never really used Access before, so I'm taking it on as a fun summer challenge :P (or I need to for my internship haha). Yup, that's me. See yall around, Peter