Search results

  1. A

    Question Access and Runtime on the same machine

    I'm trying to put together a database that is capable of exporting mde files. The database is currently in 2000/03 format, but will most likely be run on 2007 machines, which will produce 2007 mde (or accde) files. The people that need to run the mde files, will most likely have Office 2003...
  2. A

    Formatting messed up when importing forms

    I'm trying to remove user-level security from a database I wrote a while ago. I've created a fresh database and exported everything from the old one, but some of the forms look different. All the fields that were sunken are now flat, and all the tabs have a solid white background instead of...
  3. A

    Linking tables that don't exist

    Is there anyway I can create a linked table to a database that "doesn't exist" (ie. is on a network that I don't currently have access to, but the users will have access to)? At the moment, I'm working around it by having the database check the links on startup, so when the user opens it up they...
  4. A

    Create MDE file from 2000 format MDB using VBA

    Ok, I've tried to summarise my dilemma in the title, but I've thought of a few ways I might achieve it, I'm just not sure how to go about any of them, or which might be the correct one. I'm running Access 2003, which is set to create 2000 format databases by default. What I want to do, is...
  5. A

    Copying records from one database to another

    Sorry, not sure if this should be in the vba section, or the queries section, but I think it's more code-related so I've put it here. I have a database that contains linked tables from multiple access databases. At certain points, code will trigger that is meant to copy a record from one table...
  6. A

    Determine number of records returned by filter

    Ok, I'm pretty sure this is an easy one, but I can't seem to work it out. When using the filter by form & apply filter buttons, is there any way I can determine how many records will be returned? I've tried putting something in the On Apply Filter event, but that runs before the filter is...
  7. A

    Chart in form won't refresh

    Sorry for the vague title, but I really have no idea what to do about this. I have a chart in a subform, in the main form I have an option group and a drop down to select parameters for the chart and a refresh button to make these changes. The button builds a query using the selections and...
Back
Top Bottom