Search results

  1. B

    Recordset and Workgroup question.

    Everything in my database seems to be working fine for the moment except the following code. First an explanation of the form this Sub belongs too. Page one of the form has a listbox populated with data from the Helpdesk table. When you click on the an item in the listbox the a record is...
  2. B

    Subform adds unwanted record

    Hello, I have a form called IMO that I use to view and edit information from the table "Helpdesk" On this form there is a worklog command button. When this button is pressed the only code executed is: sbfrmWorklog.Visible = True the subform has the following code written in...
  3. B

    Automatic Requery

    Hello, I am looking for some help with the following problem. I have a listbox on a form that populates via the following code: strSQL = "SELECT [Ticket Number], [User Name], [Phone Number DSN], [Computer Name], [Building Number], [Room Number], [Date Problem Started], [Type of Issue]...
  4. B

    Help with Record Locking

    I have a form that is designed work with data submitted by other users. This form is designed to update or delete data. Almost everything is working properly except I am running into a record locking problem. the code used to open the record set is as follows: Set rst =...
  5. B

    Run Time error 3001

    I started my current project with little to know knowledge of MS Access or writing code with within MS Access so bare with me... I have a split database, the tables are stored on a file server, the "front end" form is stored on each user's computer. I had my database doing exactly what I...
  6. B

    concatenate a return space

    Is it possible to concatenate a return space when adding data to a field in Access? For example I want to use a text box to add data to a memo field in a table. Each time data is added I want to add space between the new data and the next update so the field would look something like this...
  7. B

    Creating a log using text boxes.

    Hello all, Please forgive my inexperience with access as im sure there are much better and easier ways to do what I am attemting... That being said my issue is as follows: I have two main forms in my database, Helpdesk and IMO. Helpdesk is available to all users in my organization via...
Back
Top Bottom