Search results

It's Payment ID with a space and not an underscore. Everything that has an underscore, I put it there, they are all with a space.

I get this error:

Hello I am using Access 2007. Mainform name: Visitors Fields: Visitor ID, Company ID, Last Name, First Name, Gender, Telephone No, Next of Kin, Package (This is a combo box with 2 columns and 5 rows), Status (This is a combo box with 1 column and 2 rows), Reservation Date, Duration of Stay...

Thanks for your response, but I found the solution

Can someone please close this? I found the solution here http://www.access-programmers.co.uk/forums/showthread.php?t=167682 Sorry about this.

I have a table, namely Burnt DVDs (Movies/TV Series). It has 3 fields of data, namely Title, Release Date and Comment(which has the data type, Memo). I also have a form, namely Burnt DVDs (Movies/TV Series) Search Who Loaned DVD that is linked to a select query. The query filters the records...

This is a lot better, thanks. :)

Thanks a lot! This was really helpful.

Thanks a lot for this! It solved my problem! :) PS. Sorry for posting in your thread.

Thanks. Here's what I did... I created a new field and gave it the autonumber type with this format... "PM"# EDIT I found this code and it helped! --> LINK

Hi Alan! I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you. :)

I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you. :)

I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you. :)

I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you. :)

I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you and I hope you can help me as well. :)

I'm also new to the forums, so a new user welcoming another. If you have a problem, here's the place for you. :)

Yes I do. Payment for short PM. I used it because I'll have collector id and vendor id in the same form and they'll all be indistinguishable. I guess I'll have to make them all autonumber, seeing as placing distinguishable acronyms before the numbers is a drag. EDIT Private Sub...

OK. Changing it. Thanks for the assistance.

The reason for me using that format is because I have other IDs in the form and I wanted to differentiate among them. I'm considering your advice, but what if the field is indexed, wouldn't that make it faster?

I'm new to vba coding and I would like some assistance please. I want whenever I'm updating or adding records to my form, the ID automatically take the value of the previous ID and increment it by 1. The field type is text (mixed with number) - PM0000000. I've done some research, what I...