Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jalgier
  • Content: Threads
  • Order by date
  1. jalgier

    Rounding and...

    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...
  2. jalgier

    restrict form to new records only

    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...
  3. jalgier

    using ADO to add new record from form AND subform

    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...
  4. jalgier

    clearing an unbound form

    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...
  5. jalgier

    writing unbound form record to table

    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...
  6. jalgier

    open a second database

    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...
  7. jalgier

    Access on the Server

    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...

Part and Inventory Search

Back
Top