Recent content by jsnfrs

McSwifty, Just to add to the reg entries you posted. They worked for me and I'm glad helpful users like you are still contributing your knowledge to the forum: Just a reminder to person using the entries; remember to change the MS Access reference to suit your computer's file paths and...

This is the code I am using: Private Sub Form_Current() Dim intMaxNumRecs as Integer intMaxNumRecs = 5 'Max Number of Records to Allow If Me.NewRecord Then With Me.RecordsetClone If .RecordCount > 0 Then .MoveLast: .MoveFirst...

Thanks alot missinglinq, it worked. Kindly assist me with limiting the record entry to no more than 5 for the database as well, I am apparently getting something wrong with this code as well, it worked once and just stopped after. Regards

Yes, the actual field name has a space. When I remove the space I am returned with another error "method or data member not found" or something similar.

This is what the message looks like

Another thing, I am creating an application for use by a few clients of the firm I work at, at the moment I testing to see how the finished product will behave and look like to the clients: I made the file into an accde then packaged it with the extension in access that allows you to creating...

Not a problem man, The first sub is the code I got from you guys and tried to get it working but ended up with the error and the second sub is another area I would like help with as well, I am trying to limit the entry of records to 3 entries in this table "tbl_assetsregister" as well but that...

Hey Guys, I am trying to implement the Dmax plus function as well, but when I place it in the beforeupdate event I am being getting a "variable not defined error", Kindly assist. Regards

Hey John, thanks for the response. I currently have code in the forms on current event that limits record entries, so I tried nesting the two codes as follows but I am getting an error that tells me "variable not defined" Private Sub Form_Current() If Me.NewRecord = True...

Hey Guys, I am Jason, a new member of the forum. I have a small problem. As it relates to Dmax functions. I am doing an invoicing database and would like to know how I can leverage the use of the Dmax function to automatically generate invoice numbers when a user opens the invoice form to...