Recent content by jalgier

Excellent. The logic works. Thank you both for your help.

Greetings, Two quick questions...on a form I have, I need to round both up and down on certain values (regardless of what the decimal value is). For instance, I might need 3.8 to round DOWN to 3 or 4.01 to round UP to 5. Second question, how do I select the value to the left of the decimal...

Sure, Basically what I am checking for is data in three of the fields on my form. I created a function that I call throughout the code (OnClick of 'Add New' and 'Exit' buttons for example). The function looks something like this... Dim intVar as Integer 'global variable Function...

OK, I changed Data Entry to 'Yes' and we are getting closer. While I can no longer scroll through previous records, I can still scroll to the next potential record. This unfortunately still bypasses my code validation for my "required" fields. I have three fields which need to be...

Thank you for the response, but unfortunately it didn't have the effect I am looking for. When I open the form, it opens to a new record, but I can still scroll through all the other records using the wheel on my mouse. I just want the user see the new record and be forced to use the buttons I...

Greetings, I have a bound form (which houses a subform) and I want to restrict it to only entering new records. I have set Record Selector and Navigation to 'no' on the form's properties. The form is set to open on a new record. Everything would be perfect except that on my mouse is one of...

Thanks, that worked...but here is the other problem I am having. The subform I have is set to datasheet view, but when a new record is started, the subform does not create any other records. Basically, you can only enter one record from the subform instead of multiple records. What do I need...

Greetings, I have an unbound form in which there is an subform. I used ADO to sucessfully add a new record to a table, but I'm not sure how to get the subform's record(s) to write to its table. My code is as follows... Private Sub cmdSubmit_Click() Dim rst As ADODB.Recordset Set rst = New...

Excellent. I think this will give me the direction I was looking for. Thanks...

Thanks for the help...

Greetings, I would like to clear all fields on an unbound form I am creating. The form is used to enter a record (via a submit button with ADO code behind it). I would like to add a 'Clear' form button to allow the user to clear all values in the fields. I have tried the following to no...

Greetings, My brain is a little frozen this morning. I have an unbound form that I need to have the records written to a table. I have a 'Submit' button that will perform the action (OnClick). Can someone please give me some direction in writing the code to submit a record to a table from an...

Thanks...I have considered using Word, but I find Access easier to manipulate. Just out of curiosity, why would you not use Access to create a help doc? Also, what is Robo-Help? Is it free?

Greetings, I am creating a help document for a database, and due to the size (heavy graphics, about 15MB), I would like to create it in a seperate, empty database. My idea is to have a button on the current db, which when clicked, opens the help db (opening on a "main" help form...no...

Greetings, I have been having problems (about once a week) with my Access application. The database is running on an NT 4.0 server with about 4 people accessing it via a shortcut on their desktop. The app is about 15MG, and like I said, I have about a problem a week where I have to kick...