Search results

Hi all! I can create a button that opens a new form with the related records from the first form, but I would also like to be able to add a new related record. I can add a record, but it is not picking up the ID. frmProjectIDProject has button that opens up second form where the IDProject is...

Ok, I want to click a button to add a new record as well as see the related records. I can make a button to add a new record or see the related records, but not both at the same time. I used stLinkCriteria to see the related records and doCmd, go to record, acNewRecord. Any suggestions...

Here's what I'm trying to do: I have a table that contains a list of tasks. If the checkbox =yes, then I'd like to copy those id's to a junction table. I can get 1 record to copy, but not all. I was using a macro with Set Value. ( I also tried an append query, but it didn't work as expected...

I'm working on a laptop that is not currently connected to a printer, although one is installed. I'm working on a new db and this morning I have tried to create a report both manually and using a wizard, and I get the "unable to create report" message box. I can open other reports from other...

Here is my dilemma: I need to track if testing has been done on about 15,000 compounds. This needs to be done on a quarterly or annual basis depending on the item. Here is a simplified table structure (with longer field names for ease of understanding!) tblItem idItem annualOrQuarterlyTest...

I'm working on a db to track testing that needs to be done on a quarterly basis for about 15,000 line items. Ultimately, I'd like to run a query that would tell me which items where the testing is due or overdue. I was thinking of a junction table, called tbl Results set up as follows...

Ok, I feel silly. I did search on inventory, and one of the responses suggested to search inventory and then search within the results for "price changes". How do I search within search results? It's probably right infront of me, but I can't find it! Thanks, Mary

Does this sound like a corruption problem? I added a new field to a table, and saved the table. When the table is reopened, the new field is not there! I thought perhaps I forgot to save the field, so I tried adding the field again. When saving, the error said, "cannot save; duplicate field...

Does this sound like a corruption problem? I added a new field to a table, and saved the table. When the table is reopened, the new field is not there! I thought perhaps I forgot to save the field, so I tried adding the field again. When saving, the error said, "cannot save duplicate field...

I'm using Access 2000 along with Oulook 2003. Since we changed email servers, the send report no longer works. The addresses no longer appear to be valid. I can manually put all the names in every time an email is sent, but that is defeating the purpose! I even tried changing the addresses to...

I managed to corrupt a database. I think I did this by accidentally creating a module that had no info in it and was never complied. The day before, I had made several table additions and had run compact and repair twice at the end of the day and all seemed well until the next time the...

I'm trying to add filds to a table, and when I try to save I get the error message: cannot define fields more than once. The problem is, there are no duplicate field names. I've run compact and repair (several times) with no change. Any ideas? Thanks, Mary

I seem to be having more issues with corruption in the last 2 weeks Access 2000). This has been happeneing over several different db's. My laptop is about 3 years old. Could problems with the pc be part of the cause? Thanks,

I have searched the forum, but have not found any matches. I'm using an unbound combo box with the row source set by a query. That is working fine. I'd like to use another field from that row to automatically open the correct form. Bound column: idFormula Column1:formula# Column2:idPasteType...