Search results for query: *

Unless you are using SQL server, you'll need to run an update query to update the NextYear field after each new date record is added. If using SQL server, you can set a trigger on the table to do the same thing. -Poop

I agree with vb6novice, but I would make a habit of checking for empty strings, too. Like this... IS NULL OR "" Good Luck, Poop

If none of the other geniouses in here come up with a good answer, I would try to remove reinstall Access. -Poop

Instead of using the font on the Access report, which Snapshot may not recognize, can you attach an image of the logo in its place? -Poop

Use the DateAdd Function. Something like this... NewDateField = DateAdd("y", 1, OldDateField) Good Luck, Poop

I recently overcame a similar issue by modifying the sql string property of the querydef in code - something like this... Dim strSQL As String Dim intRecords As Integer intRecords = InputBox("How Many Records Do You Want?", "Answer The Question") strSQL =...

Try something like this. StartDate and EndDate are whatever date you want to choose... SELECT * FROM MyTable WHERE DateField >= #StartDate# AND DateField <= #EndDate# Good Luck, Poop

I'm not sure if the iSeries is similar to MS SQL Server, so if not, please disregard. If possible, try to set a trigger on the table so when new records are added, the trigger will reiview them and decide to keep them or delete them. For what it's worth, Poop

If there is an ID on the table (a date would work, too) try to build a query on a query. First query (q1) would look like: SELECT Max(MyTable.Field1) AS NewRecord FROM MyTable; Second query (q2) would look like: SELECT MyTable.* FROM q1 INNER JOIN MyTable ON q1.NewRecord = MyTable.Field1...

I've been experiencing the same issue when distributing apps to other PCs. I bet you're missing mscomct2.ocx or mscomctl.ocx. Make sure these are installed on each of the computers you are distributing your app to. You can be certain which dll/ocx may be missing by opening the code window...

Try formatting the date field you are searching for and the date criteria in the where clause. I also have the same annoying problem at one of my jobs (dates in text format). One thing I've found very helpful is to format the dates with the year first, then month, then day. This makes sorting...