Search results for query: *

Hi, What is the easiest way to create a user-friendly command button that deletes all records in a specified table? Any help would be appreciated. Thanks in advance, Jeremy

Richard, How do I set the value from that table into the macro/code? How do I reference that filed in the table when running the macro/code? Jeremy

Hi, I am creating a database that has a total of 6 tables. I plan to distribute this database to a few people via CD-Rom, and am having some trouble with a backup feature I am trying to build. Because I am not very proficient with VBA code writing, I generally create a macro and use the...

Hi, What is the difference between a .mde database and a .mdb database. Sorry for the ignorance. Jeremy

I have bebe nworking on a database for quite a while, and always maintain a back-up. Problem is, recently prior to saving the database backup, my application stopped responding, and now I get the following message. The Visual Basic for Applications project in the database is corrupt. Can...

Thanks for the reply. This is how I am calling the function. ***CODE START*** Private Sub Form_Load() DoCmd.Maximize CenterForm Me.Name End Sub ***CODE END***

AJN2004, Thanks for the reply. I have already created a command button that calls the following function on click. What is does is searches the table for the highest number and adds one. ***START CODE*** Public Function NewCustID() As Long On Error GoTo NextID_Err Dim lngNextID As Long...

Whoaa, Don't go. I'm a little late, and am very interested in your code! Still there? Jeremy

FancyPrairie and ptuck, I have been sitting in on your posts, and ran into a samll problem. I hope you don't mind me bumping it. When I call the function from the form's on open, I get the following error: Compile Error: Expected procedure or variable, not module This may be an easy fix...

I presume this is a easy fix, but not for me! I am trying call a procdure that I have in a module when I open a form. How do I finish the code? **********Start Code********** Private Sub Form_Open(Cancel As Integer) Call ReSizeForm ' Where do I go from here? End Sub ***********End...

Many thanks to both Richard and GLS for the help. I got everything working as planned. Note the stars! -Jeremy

Hi, I'm using the following code to attach a password to a command button; however, when the person enters the password, it is not hide with *********, it actually displays what the person types. How can I adjust my code below to hide what they are typing. *****************CODE...

Hi GLS, Thanks for the reply. I have tried that and ran into two problems. The first problem is, when I combine the year field and the autonumber field in a form, the new record control number filed drops the zeros before the actual number. I need those zeros to stay. For example...

I am trying to customize a record control autonumber in this format: YYYYRCN00000, where YYYY = year, RCN = remains the same in every record, and 00000 = autoincrement. I am not very confident in writing code without easy instructions. Any assistance would be greatly appriciated. An example...

How can I save the data entered into an unbound filed in a form to a field in that form's table?

How do I create a record control number that I can start over at 00001 every January 1st? Example number would be: 200400001 for the first record entered in 2004. In 2005 the number would be 200500001, 200500002, 200500003, and so on? Please explain for a rookie! Thanks in advance.