Recent content by DocNice

Yes, you're right. My problem must be elsewhere. Thanks.

I have a recordset that says Recordcount is 7, but when I tell it to MoveLast, it goes to 6. If it's on 6 and I tell it to MoveNext, it goes into EOF and gives errors. The code is too long to post here, but I did a search and saw some comments about problems with nested loops. This makes...

I have a recordset that says Recordcount is 7, but when I tell it to MoveLast, it goes to 6. If it's on 6 and I tell it to MoveNext, it goes into EOF and gives errors. The code is too long to post here, but I did a search and saw some comments about problems with nested loops. This makes...

I imagine there are a few ways to do this, but hopefully someone can help me with a simple one. Background: I need the code to go through a recordset and make a note of all the corresponding records in another table that need to be acted on; however, they can only be acted on once. For...

It can be done, but it's starting to get pretty complicated. Is it pretty hard for you to split that field into two fields? If not, you can modify the string different ways. I'd personally have to search in the Access help files to remember them.

Try this: Dim strLastName, strFirstName strLastName = UCase[Last Name Field] ' String to convert. strFirstName = LCase[First Name Field]

I can't seem to get my form to requery, and honestly am surprised I am hung up on this. I have a continuous form that has fields that need to be hidden and unhidden depending on data in that record. So after they update a record, a field may be hidden or unhidden (technically, just a lookup...

Perhaps there is a naming problem with the field [ID] and the variable "ID"?

I have a subform (continuous form) with a Dlookup field that looks up information based on another field in the record. The problem I have is that when a person inputs the information, code looks up the other information (which is part of the underlying query: and I can't put this field in the...

Hi, I have a repeating form, and I wondered if there was a way to put in a field that would look up something based on info in the previous record. Basically, I want to display info for the user's reference saying that this record refers to where the last record ended +1. I know it's a long...

Hi, I have a repeating form, and I wondered if there was a way to put in a field that would look up something based on info in the previous record. Basically, I want to display info for the user's reference saying that this record refers to where the last record ended +1. I know it's a long...

Hey all, I could swear I've seen a way to read the contents of the next record without actually telling the recordset to movenext. Like a +1, +2 type of thing. But I can't find it now. Can this be done and what is the language? Thanks, Doc

It's a bandaid solution, but that works for me. Thanks!

I have an Access interface to a network SQL database. The form is set to "Dynaset (Inconsistent Updates)" to allow for a complex underlying SQL query. After someone enters data in a field, it is supposed to open another form to allow them to choose additional info to insert into the record...

Alright, I figured a workaround. I created a query which listed my primary key field, SchedulePage, in descending order. Then I ran the Update query on the query instead of the table.