Search results

I have a report containing a series of line graphs showing the number of service calls (for maintenance on equipment) performed each month. The service calls are categorized based on the reason for the service call. Im attempting to give a further breakdown of the progression of each category...

Im sure this is something simple but i cant seem to get it working and my deadline is fast approaching. I have a simple form that contains some combo boxes used for filtering data and a listbox to display the results of the query. The query SQL is executed with the forms OnCurrent event, which...

So here is something I built years ago that I've continuously refined and built on but now i need to build on significantly more to make it work the way it needs to. Here it goes..... Background: I have one main database with multiple specific forms that somewhat correlate to specific...

Let me preface this by saying i am new to the ADO library and all its methods and properties. However, we have moved our backend to a MySQL server and from what i currently understand the ADO library is better to use with ODBC connections than the DAO because it doesn't use the MS Jet...

I have a table within my DB that contains quality verification limits for specifi parts for a manufacturing facility. There are individual fields for upper and lower size limits for inspections A through Z plus a few other standard checks (~60 fields total). This fields are used to populate 3...

So the day was upon us where our database system(s) needed to upgrade our back end to something that could handle all our data. The decision was made to consolidate our largest and most used databases into one front end and one SQL server for the data. Were early on in the consolidation but my...

I've searched quite a bit but i guess i'm not using the right terms so i'll post here. if there's an existing post that solves this please share. I have a label and textbox control on an "Entry_Maintenance" form that i am wanting to toggle the visibility on and off depending on the action taken...

So i've been fighting this for a while now and dont understand why it's not functioning. I have a multi-user database that links via ODBC to multiple backend tables from various systems. In this database i've created a simple communications area to allow for employees to document issues...

So I have a single pop up form with 4 cascading combo boxes. I've written the following code to auto populate if the combobox only returns a single list value, which makes it a little simpler for the user. (this is on in the after update event for each combobox) Private Sub...

Background: I have a form that is used by DB administrators only that allows them to edit Tooling and part data, the tooling data is auto populated based on a global variable when the form is opened. Because one tool can produce multiple parts, in this same form I have a combobox where the...

I'm attempting to execute a function every time the active form changes. i can get the name of the active form using Screen.ActiveForm property but I'm looking to automatically execute the same function each time it changes. I'm hoping to do this without adding a line of code on every form's...

I have a subform on an existing form that cycles through all maintenance records for a specific piece of equipment. the table stores the employee ID for the individual who performed the work and the subform then displays the employee number in a bound textbox. I have a ODBC linked table which...

I am trying to give the users of my database a method to edit an existing record in the database. there is a projects list that is shown on a main form in a listbox, from this list box i want to be able to double click a line and have it open the pop up form that is used to enter the data, but...

So i'm thinking there has got to be a better way of doing this. Here's the background info... I have a multi user database that is used to track information for industrial tooling (maintenance records, tooling spec's, usage history etc.). Through this database i have one main form that has a...

I currently have a multi-user database that is used to track maintenance and data records for industrial tooling. The users of this database are not computer savvy individuals so all their actions are conducted through customized forms. In this database I have a table specific for "tooling...

ok so I've built a database that is used by everyone at my company and I've got one section of code that has been bugging me off an on for months now. A quick explanation of the issue i'm trying to solve here.... I have a form based off a query where the user enters a value in a textbox and...

So im new to the forum and still fairly green on my VBA, just about everything i know has been self taught (im sure yall know how that goes). what i am struggling with is a code module that I'm building to work with a database to track manufacturing tooling. i have put together a number of...

newbie here working on some new database projects. really looking forward to learning from this site!