Search results

  1. T

    Data Collection

    Hi - I'm not sure if I've posted this in the right area, or if it's even possible, but I'm trying to find an "easy" way of completing a task, and wondering whether there is a way to do it in Access... I currently have an Access db of about 60K records of existing customer data. As part of a...
  2. T

    Top N Records by Group

    Hi, From researching I've come across quite a few ways of doing this however cannot seem to get any of the methods to work for me when I try putting them into practice in my db. I have a table which holds parts sales data for 6 individual dealers, and I basically want to be able to produce a...
  3. T

    Sub-form Question!

    Afternoon Estuardo! Thanks for your response. I've tried that but it doesn't seem to work? I have a query setup which is the entirety of the two tables [value] and [volume] - Both tables are exactly the same in layout, i.e. an Account Number as the identifier and then about 30 different part...
  4. T

    Sub-form Question!

    Hoping I've put this in the right place!! I've successfully setup a customer form which has multiple sub-forms embedded into it showing results from various tables within my db, all linked to the customer via the master/child link I've setup... This all works perfectly, however I've now been...
  5. T

    Toggling various sub-forms

    Hi Sean - Thanks for responding... The data will all be in one table, and I'll just need the various toggle buttons to alternate which categories from that table to show in a list/report on the page. I hope this makes better sense? Thanks again.
  6. T

    Toggling various sub-forms

    Hi All, I've read various posts relating to toggle buttons but just can't seem to be able to find the answer I'm looking for - either that or I'm just being that stupid! :banghead: So really hoping someone could please help out. I have a customers form which has a tab control within it for...
  7. T

    Question Creating a Database "Front-End"

    OK thanks - Yes seems to be the settings in control panel as to why it wouldn't let me change - apparantly a W7 default to 'hide' known file extentions... I'll give that another go! Fingers crossed :) Thanks
  8. T

    Question Creating a Database "Front-End"

    Hi Shutzy, Thanks for your advice - I've downloaded and tried what you suggested (save as filetype etc.) but the Access 2010 always takes over as the primary system to run the file in - even if I attempt to save as a different filetype? I'm wary as to whether this is the most efficent way of...
  9. T

    Question Creating a Database "Front-End"

    Hi, I've already changed the settings so that the "login form" is the first to load when opening the database, the trouble is all you need to do is close the dialog box to be able to bypass it and go into everything... I would really like a way to hide all of the settings ribbon and tables...
  10. T

    Question Creating a Database "Front-End"

    Hey All, I'm currently trying to build a new database (2010) to hold customer info at work. In my old job, we had a similar database on an older version of Access, but when you initially started Access up you got a login screen, and then a welcome homepage once sucessfully logged in... You...
  11. T

    Hi

    Hi All, New body here in the drisly UK!! I've been using Access for years now, but never really on a building level. In my previous company I used to manage the databases there, "building" and populating the data, and could generally fix issues or create add-ons to already established...
Back
Top Bottom