Search results

  1. R

    SQL Date Nightmare connecting via JET

    Greetings, I'm using flash mx and MDM zinc which i assume connects using the JET rather than ADO database engine. For the life of me cannot get a simple update to work due to the dates involved, lost count how many hours have gone by trying!!! Within access I can easily switch quotes and...
  2. R

    Database Design simple FAQ

    Greetings, I'm designing a simple FAQ system. The primary aims are as follows :- * Allow a choice of category to display Question and Answers * Allow a sequence to be provided to display Q&A's * Allow user to rate the advice * Record the number of times the Q&A viewed * Record the initial...
  3. R

    Combo Box to both SEARCH for records and ADD NEW values to list

    Greetings, Using the button wizzard I am able to create a combo box that searchs for records and display data. However I cannot add NEW values to the list, I cannot change the properties of the box to allow this. Is it possible to use a SINGLE combo box to allow a search facility and an ADD...
  4. R

    Calculated fields on subforms - writing records

    Im sure this is a common problem, I had a nasty shock when I discovered that calcualted fields (from a query) in my subforms are NOT stored with the database though the control source is a table field they are not bound to a table. What are the most popular ways to solve this? Easier the better :)
  5. R

    Subform - Accessing last record.

    Greetings, I have a main form. Upon filling in a combo box it then displays a subform (based on a query that uses values in the combo box on where clause) THe subform has the paramater Data Entry = 'No' as I want users to see all existing records and all additions/deletions and edits. However...
  6. R

    Subform based on a query issues

    Greetings, Has anyone come across a problem where if you run a query via query design it retrieves results though if you run it through forms it retrieves 0 rows? I have a subform based on a query, when in the design mode of the form to ensure im using the correct query its runs without errors...
  7. R

    Normalisation & Reservations/double bookings

    I am writing a booking simulation for a sports hall. A customer makes a phone reservation for a date & timeslot (Book in 30minutes segments) in a facility (South Sports Hall, Swimming pool, Tennis Courts) and an area which determines which sport can be played. A coach can be booked for a...
Back
Top Bottom