Search results

I think that the Shell command is definitely the right idea. I have a batch file (shown below) that opens the file I need, but I want to run that straight from the shell command without needing the batch file. ssh user@hostname python /home1/username/Projects/importantScript.py ARG & pause The...

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

The reason that I have both DepartmentProficiencies and ProficienciesCompleted is that all of the ProficienciesCompleted for an employee within a given department have one date associated with them. There are maybe 10-15 different proficiencies they pass or fail, but all of those 10-15 happen on...

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

Regardless of criticisms and great advice on what the database I'm working on should look like, my initial question still does stand. Is there a way to alphabetize column names in a table? Just as a refresher, the purpose of alphabetizing the columns is for structure and organization during...

My education in MS Access has been entirely through internet tutorials and getting help on this website. I generally learn software very quickly, so I've taught myself the functionality of Access for the most part, and have learned the basic normalization theory from pages like this...

As a 22 year old intern, I've tried convincing the 50 year old engineers that they should normalize the database. Convincing the primary user of this "database" that he should use a primary key and autonumber took about 10 minutes by itself. Convincing them that they shouldn't store paired...

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

jdraw, So far as I know, documentation is simply kept in versions of independent files (they make a change, and save it as a new version). There is no current common database for the information I'm working with. The "documentation" is simply found in independent reports about each job. This...

I really like your "Stump the model" idea. I usually debug my own applications that way on my own, but I'm sure the group dynamic will make that much more effective. Specific Question: Is there a common solution for tracking changes in a relational database? If so, where could I find...

"This issue" is the circular relationship that seems to be inherently related to the timestamp feature. This feature isn't required for the database to function at the most basic level. The main benefit of this will be the ability to track down which engineers have added changes to the...

Is there an alternate way I could implement the timestamp feature within the database that would avoid this issue altogether?

Sorry that that data didn't help. Basically, this is modeling a casting process. Each part has it's own unique process of die/mold construction, heating, and metal pouring, and 20 other numbers, file names, or variables that the casting equipment needs to run (all of that information can go...

I've attached the updated database with (dummy) sample data. I agree that that loop in the relations shouldn't be there. However, I don't know how to get rid of it. I simply want to create a record of which user has made edits to the part files (kind of like the comments for a "Commit" button if...

Here is an updated image of what I have at the moment, hopefully it will be more clear. I've changed some names and values to clarify the relationships. I also made all of the PK's into autonumbers. I have not yet combined the "redacted" tables (now named Materials, Shell, Casting, and...

Those "redacted" table names are simply the names of the processes the parts go through during manufacturing. In the picture I uploaded, they are empty only because I had not filled in the column names yet. The reason I had separated them was that they were each going to hold details about that...

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

Fixed it for good this time (I think :O). Public Function getNumericText(ByVal field_name As String) As String getNumericText = Me(field_name) End Function Public Function getStringText(ByVal field_name As String) As String getStringText = "'" & Replace(Me(field_name), "'", "''") &...

The code I posted immediately before your response does actually run. I did realize, I have one more request for your expertise. How would I go about formatting my query for a Yes/No field. Also, the date formatting I made based off of your original post is not working well: Public Function...

The code works now. I switched from using CurrentDb.execute() to DoCmd.RunSQL(), and the query successfully runs. Thanks for all of the help. For anyone else who might have had a similar problem, here's a sample of the code that shows everything you need. Private Sub...