Search results

Re: Duplicate current record & Increment a non Primary ID column to CurrMax+1 value Nice Work!

Re: Duplicate current record & Increment a non Primary ID column to CurrMax+1 value as far as duplicating the record and leaving certain fields blank, this can be done with VBA, but I'm not sure how to help much beyond that. I did a google search and it appears that there are some good...

Re: Duplicate current record & Increment a non Primary ID column to CurrMax+1 value To get the ID number to increment by +1 from the highest ID number, just use an AutoNumber field type.

I have a combobox that pulls its list from a query and stores it in one of my tables. There are 4 columns in the query, AuditorId FirstName, LastName Expr1 (firstname+lastname) The combo box originally used column 1 (firstName) as the bound Column. When I change it to Column 0...

mdlueck - Thank you for all this. It looks like good info, I worry that it might be slightly beyond my level of comprehension, but I'll definitely look at it and see what I can figure out. Thanks!

That is what I was using the combo box for. Thank you for the suggestion. The reason I chose combobox is because the list i'm chosing from is over 700 items long and I couldn't figure out how to type into the list box to find the specific record I was looking for. I could only type the...

I am working in access 2010 on a product information database. My main table has a "LastUsed" field in it. This field is updated the night before each time a product is used. Traditionally I've been updating each record one at a time, but this take a decent amount of time and I'd prefer to...

Hey plog, thanks for the suggestion. I was using the query to prevent the Invoices that don't have a corresponding detail lines classified as report type 1, from showing up. types 2, 3, 4, and 5 will all have their own forms since the fields vary between each of them. In other words, my...

This had the desired effect, but now since I use that form as the Record Source for my form I'm unable to create new records. Do you know if there is a way around this?

The query is referencing the detail information to verify the [ReportResultsType]. This is important because headers may be associated with detail entries of more than 1 type. I believe that this is what is causing the problem for me. I need to be able to sort through the report headers one at a...

This is what was returned. Essentially each invoice number is reported for every line item associated with it. Invoice 48595 for example is returned 6 times. I only want each invoice instace returned once. Query1 ReportID ReportInvoiceNumber ReportTestDate ReportSampleDate ReportSampleTime...

This sql statement is returning the results that I want, but it is returning each record multiple times based on how many records there are in the subTable. How can i set this up so it only returns only one instance of each record? SELECT tblReportHeader.ReportID...

I'm confused, While in design mode there is a clear end to the form space. What is the purpose of showing that to you and allowing you to adjust it if there it doesn't allow you to change the page size in form view?

I'm using access 2010 and have Tabbed Documents enabled as well as Display Document tabs. When i open a form in design mode, it appears that I have the option of setting the form size parameters by dragging the page boarder horizontally or vertically to grow or shrink the size of the form...

I have created a table that acts as a header for my data and a second table that acts as line item data. What I need to do now is add a second child table that uses the line item data as its parent table and stores associated line items for each record. Is this possible? advisable? This is...

I think I may have found an answer... it seems to do what I want it to, but I wasn't sure on the join of the new table (tblAuditStaff_1) if that was the best way to do it. Would someone give it a look over and let me know if this seems like the appropriate way to do this? thanks SELECT...

I've built a task list that allows all tasks to be assigned and then tracks completion. main table looks like this: tblDiscrepancy - DiscrepancyID - DiscrepancyDescription - DiscrepancyCorrectiveAction - DiscrepancyAssignedTo - DiscrepancyCompleteDate - DiscrepancyVerifiedBy Both...

Perfect, that worked perfectly, thank you!

I have a database that manages multiple task lists. Each task on the task list is assigned to one of several individuals. I need the query to request the user to input the name of one of the task workers to then populate a list of all open tasks for that worker. A task is considered open...

Thanks, I wasn't familiar with the Unmatched Wizard. I'll look into that. How would I set something up that allows me to select a month each time i run the query to pull that specific month? Thanks again Bruce