Search results for query: *

I've read through the FAQ guides here and I'm trying to figure out a solution to what seems like it should be a simple problem. The users are looking at a priority list of jobs stored in a listview. I'm using a listview instead of a listbox because I want to be able to format each row based on...

Looking for something that's similar to a unique constraint. The scenario is that I have a table with part numbers and revisions in it. In order to maintain change history, the old revision of the part number stays in the table when the new revision is released. Now say I wanted to create a...

I have a schema that I'm trying to normalize: Component(component_id, component_number, component_revision,...) Component_lot(component_lot_id, component_lot_number, component_number, component_revision,...) Component_supplier(component_supplier_id, component_supplier_name, component_number)...

Is there anyway I can determine which column a user clicked on when they click a listbox? I'm hoping there's a property that I'm just not aware of. I.e. The user gets a part number and the labor on 4 different steps for that part. They want to see the details on the labor for step 3 so they...

I’m doing some querying on an MRP system, and I have two tables I’m working with in this scenario: Table1(part,component) Table2(component) Table1 is basically the routing table that contains all the components for the different parts, and table2 is a certain set of components that I care...

All - I have an MS Access DB that has grown well past the point where it should be split into front end and back end. The problem is that when I split the database in two, the program runs like a three-toed sloth. Events that take 1-2 seconds when the database is not split take literally 60...

To start, let me say that I'm trying to model this database after an existing documentation system. I wish I could change the system structure, but I'm stuck with trying to model what someone else has made. There are two types of documents that I want to set up relationships between: Finished...

I've done some research on this, and by all accounts this code should work from what I've read. Dim db As Database Dim fld As Field Dim idx As Index Dim tblDef As TableDef Set db = CurrentDb 'create DMR table Set tblDef = db.CreateTableDef("tblDMR*") 'create index Set idx =...

This may not be possible at all, or I may just be overlooking something obvious. Here's my scenario: I have two tables; one table contains all of the employees, and other table tracks their training levels for different jobs. Examples: tblEmployees: ID | Employee | Job Title | 1 |...

This is bizarre... I have a listbox displaying results in a foreign language but only one on of the fields. There are two listboxes on the form and both can show this data, but only one of the boxes transforms the characters on the problem field to a different language. It's difficult to...

All - I'm using the built in "Name" function for VBA to rename some files and directories but running into issues. The directories and files that I'm editing are on my local network, and I'm having some success but I'm not where I want to be yet. When I rename the file: Name...

Hi All - I have a word document that runs a routine when I open it that prompts you for a string and then updates some fields with your input. I would like to be able to input the string in my Access database and then in the background open up the word document, pass it the string, have it...

Hi everyone - This seems basic enough that I thought I would be able to figure it out, but for whatever reason I can't find the correct method that will allow me to use variables in object names when programming in word. Here's what I'm trying to do: My company has a word document with work...

Hi all - thanks for the help in advance I'm trying to find a way to determine the value of the top entry in a listbox. I have a listbox that shows 15 values but contains 60 values, so when a user scrolls down to view some of the lower entries, I need a way to determine the values in the top...

I have a database that I use to keep track of quotations at our workplace. When a new quote is created the database makes a copy of a standard word template and replaces certain strings wtih information unique to the quote (quote number, revision, etc.) The user can also create an excel...