Recent content by merlin666

I have a table that gets updated from a query. Some of our date is set to " No Change ". I'd like to be able to copy the last value that isn't equal to " No Change " to the next record until another unique value is found. For example. Date - Event - Next Event - Change 2/1 -...

I am trying to run an update from a form to auto-increment a number. Private Sub CatItemNum_Click() If Me.ItemCat = "3" Then Me.CatNumber = DMax("CatNumber", "CatItemNum") + 1 ElseIf Me.ItemCat = "4" Then Me.CatNumber = DMax("CatNumber", "CatItemNum") + 1 Else Me.CatNumber = Null End If The...

I've figured out how to use incrementing numbers but not how to have a different set of numbers for each category. ItemID|Category|CatNum|ItemDesc| 1 |Mens |100 |Watch| 2 |Mens |101 |Laptop| 3 |Womens |200 |Dress| 4 |Childrems |300 |Train| 5...

I am working on an auction database and have a basic framework(see attached). However I can't seem to get the categories to work right. It was requested that each auction item be able to be assigned to a category and then the item be assigned a number based on that. Ie mens would be in the...

I understand the concept but am a little unclear as to how to accomplish it. Using the send to back doesn't seem to work.

I have a table that has two or three fields that are somewhat dependent on each other. ItemID which is a number(1,2,3...) ItemCat which is text(lookup from another table(Mens(100), Womens(200), etc..) Categorynumber(100,200,300.....) Is there a way to have it so for each ItemCat the ItemID...

I have a database that I'm working on(see attached). I'd like the report to "fill" horizontal lines to the end of the page depending on how much info was entered at the top for desciption and donation. Any help would be appreciated.

Is there a way to copy data from field1 on the previous record to field2 in a new record any time a new record is added. The only condition would be if field1 of the previous record were = to "XVYABC" then field2 would be populated with the last record that had data that wasn't "XVYABC"...

Is there a way to have a table or query essentially copy data from one field into a different field on the next record each time a new record is added. Table1 Record1 | field1 | field 2 Record2 | field1 | "Copy of Record1 Field1" Record3 | field1 | "Copy of Record2 Field1" Also if possible...

Understandable on the time issues. I've simplified this and tried changing the code to see if I can get this working. Table has three fields - txtcurrentmarquee, txtnewmarquee, and letters Query has same three fields. It looks like I get everything working except returning the value to the...

One more question on this. Can I call the code from a query or table, using data that is in 2 fields to populate old and new and return just the myNeedResult letters to a third field so I can add that field to a report? Is there a better way to do this. Our table has evens for a 3 or 4 month...

Tim, Thank you for the access file. I really appreciate the help. Mike

How would I do that. I'm somewhat new to both access and VBA.

Is there a way to take two fields and compare them and list the differences. Ie. Compare field one "This is a good day" to field two "Tomorrow is better" and have a report stating what letters are in both fields, what letters are only in field 1 and which are only in field 2. Field could also...

Please accept my apology as I am somewhat new with access. Where would I put the program in order to run it. Visual Basic editor? Thanks for all the help,