Search results

  1. P

    Expanding subform

    I have searched for ages and can't find quite what I am looking for. I want a subform, in table format, that expands depending on how many records there are. I will try to explain. The parent form brings up the inventory record for a particular piece of equipment e.g. a desk lamp which has all...
  2. P

    Do I need multiple tables?

    I take care of the portable appliance testing for several charitable organisations, as well as my own equipment. I want to move from paper Word document records, and thought it would fairly simple! I've designed some fairly complicated databases in the past (over 10 years ago!), but I seem to be...
  3. P

    Problem with MySQL varbinary fields

    I am trying to connect to a remote MySQL database. This is a database that is linked to an eCommerce solution on my website, and as such cannot be changed. When I link via ODBC (Oracle v5.03.04.00 ANSI or Unicode) and look at the tables, all the varbinary fields that should contain English text...
  4. P

    Columns to rows

    Not sure if this is the best way to phrase the title, but I couldn't think of any other way. I have 2 tables; 1st table is automatically recorded data from a scientific instrument that has columns for date, record number and then around 50 measured parameters. Each new day starts the record...
  5. P

    Merge and add values from multiple tables

    Hi, I thought this would be really easy, but I am struggling to find a solution. I have several part lists in seperate spreadsheets which I want to import into access as one table. Each spreadsheet has the same columns, but some parts appear in only one spreadsheet, some in several sheets. I...
  6. P

    Using worksheet name in reference to another workbook

    I have 2 seperate workbooks, both with many worksheets. I need to get some data from one of the workbooks and copy it to the other, and I need exactly the same cell range from each of the many worksheets (the worksheets have the same name in each workbook). I have the following formula which...
  7. P

    Nested subform

    I have a main form (Form 1), with 2 combo boxes and a subform. The record in the subform is dependent on the 2 combo boxes. This works fine. I have added a subform to the subform, the record displayed should be selected by a combo on the first subform. This doesn't work. When the first subform...
  8. P

    Recordset changes not being saved

    I am running some code based on a query to update a field in a table:- Dim db As DAO.Database Dim rst As DAO.Recordset Dim FileExistsbol As Boolean Dim stFileName As String Set db = CurrentDb Set rst = db.OpenRecordset("qryTestMediaFiles") rst.MoveFirst Do...
  9. P

    Requery/Randomize not working

    I want to return all the records in a table in a random order. I have a query with Expr1:Rnd([RecordID]) sorted ascending as one of the fields. I have a form with this query as the data source. This works fine, each time I open the form, I get a different record order. I now want to use...
  10. P

    Detect when record has finished loading

    I am using DoCmd.GoToRecord to return a single record from around 300,000. Depending on where the record is the time taken to retrieve the record varies. If the code is allowed to continue, I get errors as the data is not ready. At the moment I use a timed delay to wait for the record to load...
  11. P

    Media Player ActiveX Control

    Hi, I have a form with an ActiveX Control for Media Player 10. The player works ok, but if I try to close the form using the PlayStateChange Event, Access crashes out to the 'Send Report To Microsoft' window. This is the code:- Private Sub WindowsMediaPlayer0_PlayStateChange(ByVal Newstate As...
  12. P

    File Browsing Code Modification

    Hi, I have used ghudson's example for file browsing and it works great, thanks. However, the window always opens with My Computer as it's starting folder. Is there any way to make it start in another folder? I have searched on here and on the web, but all I can find is a very complicated C++...
  13. P

    Should Dcount return 0 for no records?

    It seems strange to me, but I am finding that Dcount returns a 'Invalid use of null' error when there are zero records. Surely it should return 0. I can make this work by using an if and trapping the error, but it isn't very tidy.
  14. P

    Dcount, Grrrrrr......

    Why is Dcount so damned fussy? I am trying to display a record count on a sub-form, using criteria from a text box on the parent form. This is what I have: counter = DCount([ID], "qryReturnUserRecords", "[LessonNo] = Forms!frmGetInputData!txtLesson") When I run it, I get the following error...
  15. P

    Help with record saving

    I think I am at the stage now where I can't see the wood for the trees! I have a one table db with the following fields ID(Autonumber)(PK), RollNumber,LessonNo,DataField1,DataField2,DataField3.....etc. I have a unique index on RollNumber and LessonNo, the idea being that each RollNumber can...
  16. P

    Change colour of the empty area of subform

    Is it possible to change the colour of the dark grey area that shows when a subform doesn't fill the box that has been set up for it?
  17. P

    Averages problem

    I have a query that calculates percentages as follows SELECT dbo_tblStudents.RollNumber, dbo_tblStudents.YearGroup, dbo_tblStudents.Absence1, dbo_tblStudents.NoPoss1, ([NoPoss1]-[Absence1])/[NoPoss1]*100 AS [Absence1%] FROM dbo_tblStudents; I have called this query PercentAttend This works...
  18. P

    Passwords

    Hi, I need to get into an old database that was written by a previous employee and locked up tight, and no-one can remember the password. I know the password for a very restricted user, but there are not enough rights on this user to do anything useful. I can get into the back-end, but the info...
  19. P

    Like and Not Like in same criteria

    Hi, I have a form that I use to provide the criteria for a query. There are 2 check boxes that are used to exclude 2 particular categories from the query. This is what I have in the criteria field of the query: Not Like IIf([Forms]![frmSubjects]![checkIncludeSubject1]=No,"Subject1","") And Not...
  20. P

    relinking ODBC tables

    Hi, I have a A2000 frontend, SQL2000 backend database, and I have used the code from Microsoft Knowledge Base to Relink ODBC tables when the database opens. This logs the user into the SQL server tables as a data browser user, the username and password stored in a table as per the MS article. I...
Top Bottom