Search results

  1. M

    Best practice - Adding vs Editing

    Is the best way: create one form and then open it differently for adding new vs editing existing records create one form to insert and one form to edit, where the edit form is bound to a query, and the insert form saves data following a button's click event. some other method? I guess I need...
  2. M

    using Count()

    I'm trying to do a tally of election types using count, but am getting the wrong answer. In the database, LocalGovernments have Wards and Ward have Elections. An election can be one of two ElectionTypes ('In Person' or 'Postal'). Every Ward in a LocalGovernment has the same ElectionType. I...
  3. M

    The 'one record in a subform' blues

    I have a subform (datasheet) inside a subform (single form) inside a form, and am only seeing one record in the datasheet subform. I am creating a database of database jobs that need doing (basically a ToDo list). The main tables look like: Databases <-1----m-> Jobs <-1----m-> Tasks In the...
  4. M

    Table split ideas

    Hi all I have a table where the number of fields is causing problems. I want to split the table into 3 or 4 tables with related sections, but am not sure how to maintain the connection to the logical row of data, and how best to do this in Access. The data relates to council budgets, and...
  5. M

    Uneditable textbox

    Solved: Uneditable textbox Hi all I have a form that when opened will either allow new records to be added, or allow existing records to be viewed, depending on the OpenArgs. When existing records are being viewed, the user can click an 'Edit' button to allow that record to be edited. In add...
  6. M

    RecordSet and number of records returned

    Hi all I am trying to code a duplicate remover that allows the user to check that the two records really do refer to the same person before hitting the big red delete button. I have this code: sql = "SELECT Caller.GivenNames, Organisation.OrgName, Caller.Phone " _ & "FROM Caller LEFT...
  7. M

    Write conflict - This record has been changed by another user ...

    [Solved] - Write conflict - This record has been changed by another user ... Hi all I've got a form that shows existing records. The user clicks a button which opens a form allowing the shown record to be edited. When changes have been made, the user clicks save, which saves the data and...
  8. M

    How to save master and detail at same time?

    Hi I have a form that collects (contact logging) data that will be saved to two different tables. Up to now, I have been saving the master info, and then querying the table (using the data I just saved) to retrieve the primary key in order to correctly save the detail, but it strikes me that...
  9. M

    Financial Year Format

    Hi all I have a form that allows input of historical finance data. I want to give the user a field where (s)he can input a financial year (eg 2009/10, 2007/08). Do I do this as a date field, or a string field? I've had a search, and I think this was a similar question...
  10. M

    OnClick event - pass this control to method

    Solved: OnClick event - pass this control to method Hi all how do i tell a method to do something to a clicked control? I have a form with a bunch of labels and a bunch of buttons, and I want to run a method whenever one of these controls is clicked: Private Sub manipulateControl(ByRef ctrl...
  11. M

    using requery

    Hi all How do I do this? I want to have a form that opens with Author info. On the form is a table with books by the author (book title, year, publisher), and when the user selects a book in the table and clicks a 'Show Detail' button, a subform becomes visible with detailed information about...
  12. M

    which event?

    hi all I have a subform with a bunch of textboxes. I've set the subform to datasheet view only, so the textboxes appear like they're in a table (or a multi-column listbox). My question is: what event do i program a response to, when the user clicks the Row selection 'button' at the beginning...
  13. M

    Center data on page

    Hi all, I have a report that prints data about a number of different offices, listing sections and key staff in those offices. Some have more sections than others, but the data for each office fits on one page. I want to know if i can center the information on the page, so that the data for...
  14. M

    sub-query or two queries needed?

    Hi all I have a couple of linked tables and I'm trying to run a query to put data on a form. The tables are: Topic(ID, Subject, Detail, etc); Solution(ID, SolnNum, ShortDescrip) which both have 1-many joins with TopicSolution (ID, TopicID, SolutionID). A Topic can only have none, one or two...
  15. M

    help with count distinct workaround

    Hi all I'm trying to put together a phone call logging system that has (amongst other things) a Call table (ID, SubjectOfCall, AdviceGiven, CallerID) and a Caller table (ID, Name, PhoneNum). I'm trying to form a query that will tell me, for a given subject, the number of calls, and the...
  16. M

    parameter query with IN operator

    hi all I'm trying to create a parameter query where the user supplies a list of years, and the query uses the IN operator with the supplied criteria. eg if the user wants data from last year, 2007 and 2001, they type the following in the parameter dialog: (2001, 2007, 2009) Access tells me...
  17. M

    Data display

    I'm working on a database of candidates for council elections, and I have a query that usually returns between 2 and 5 rows of data, (min = 0 max = 15). The data contains 4 fields (given & surname (strings), votes received (int), and is elected (boolean)). I want to display the query result...
  18. M

    continuous form - rolling back data

    Hi all I have a continuous form and I want to make it so that it does not update the underlying table until I click the Save button at the bottom of the form. That is, if the user makes a bunch of changes and then hits the cancel button, I want the table to be at the state it was before the...
  19. M

    continuous form help

    ok, I've now worked out how get multiple records on one form with a continuous form, but I've now got the problem that when I click a toggle button on the form, all of the toggle buttons for that field change (ie every record's toggle button changes). The toggle button is bound to a Yes/No...
  20. M

    subform help

    hi all i want to make a continuous form but i don't know if i need a subform. I have a form set up with 1 record that I want to repeat for all the records in a query, so it becomes one long page with a line separating each record. There isn't a lot to each record, basically a couple of...
Top Bottom