Search results

OK. Thank you in advance for product suggestions, methods, ideas, etc. Real concrete working info of course would be the best. ---- I'm on a solution development team. We've captured many development documents based on single form templates, so they all look the same. I am wanting to...

Hello! I am doing my best to develop a database that automates the generation of a series of Test Cases using the Mail Merge feature of Microsoft Word to import information from an Access Database. I can get all the fields to fill out correctly from EXCEPT for the fields that are Many to One...

I've searched all over for just a simple answer. Is it possible to have a Listbox wordwrap when there are multiple large entries in that listbox? THANKS.

Allright. I have an Access frontend that is tracking Queues and Statuses of a specific process. When a Queue or Status changes, a timestamp is taken at the end of the old status, and the beginning of the new. I want to be able to track the number of hours something stays in that Status...

Hello! I just created an Access .mdb to an .adp because my deployment method just changed today. I am recreating the RowSource of a Listbox to a Stored Procedure with one input parameter, called @VendorID, based on a field in the main form. The real world example is that I have a form that...

I am creating a database to hold test cases for software my company is developing, and I need to categorize each test case. Each category has a possible subcategory, and then another subcategory based on the previous one, creating a table stucture that looks like this: TESTCASE (M:1) CATEGORY...

I have an Access database connected to a SQL Server backend. All tables are linked. I have a query that I want to run at downtime every evening at 2am, PST. I want to save the results of this query so that I can run a Report the next morning on the results of that query. How do I do this...

OK. I have a Form that allows a Systems Administrator to fill out the results of testing software. We are testing the software on 6 different clients, using 135 different tests, each test which can be a pass, fail, or N/A. It's important for me to find a way to AUTOFILL a subform in the Test...

I'm creating a database to help automate generation and tracking of ticket numbers for a help desk database. I have three tables: * Ticket table (ticket_ID = PK) * Applications table (App_ID = PK) * Vendor table (Vendor_ID = PK) My primary keys are Autonumbers, and, the Vendor...

I have these two tables, among others: * tblEmployee * tblEmployeeType ---- I'm modeling a business process in Access, and I want at various stages of the process to input Employees who are responsible for certain tasks in the process. Here is the question: Is there a way, using Queries or...

I KNOW we've already discussed this, however I'm still lost. I want to print a report directly from a form. I'm using the SAME query for both the form and report. What VB sub clause do I put in my OpenReport to make Access JUST PRINT the current report? I'm also planning on porting this to...

OK. I have a form that will reference a table with many many records. I need a control that allows the user to "Go To" a record number the user specifies. How do I do this? THANKS in advance!

FORM-A has a combo box that references a primary key of TABLE-B and fills in the associated information in the fields below the combo box. I need to add an entry to TABLE-B that is associated with information I just entered into FORM-A. I go to FORM-B, enter in the new record so it fills into...

How do I create a combo box that shows a list from a table, and also allows me to add an entry to that table or select query that it references?