Search results

  1. C

    Delete from a joined query

    Hi... I have an Access query, which gives me the "orphans", between two tables. They look like this tblSurveys tblJobs * * Grade -> JobGrade Paytype -> JobPayType Survey -> JobSurvey other... -> other (including jobcode) Linked as indicated...
  2. C

    Vertical Lines that grow

    Hi... I've searched the forums and found one or two vba answers to these questions. But in the days of those posts Access 2003 hasn't been in use widely, and hopefully they've addressed that (easy) problem by now. I want if I have a textbox on my report that has the "can grow" property set...
  3. C

    Query is too complex... On report, but query runs fine

    Hi... I have a query that when I run it normally (just click on it) then it runs fine. (It is a union query, getting it's data from 8 other queries (who has their dependancies) But when I want to run a report from it, Access gives me an error saying "query is too complex". I am flattered, but...
  4. C

    4 way form...

    Hi... I have a database, which seems very simple at first, but now when I want to create a UI that's easy and simple, it's not working properly. Background: There is going to be used at a games convention. There can be players, and Game Masters (GM's). Each player and GM is assigned to a team...
  5. C

    List Import specification files?

    Am I right if I assume that each of the Import Specification files that I've defined are inside the actual .mdb file? Now I'd like to, through the use of VBA, display the list of the current Import Specification files, and let the user choose which is the applicaple (or none) to the file he...
  6. C

    Simple: Create a new record, update old form

    Hi... I searched quick, didn't find anythign, but you guys are so responsive... :D Question: Part 1. On TimeSheet form, I want to click to "create new job", and the Jobs Form opens, at a new record. Currently it opens at record 1. Part 2. I foresee that when I return from the modal job...
  7. C

    Forms instead of <Variable>: [Prompt] in queries/reports

    Ok, so now this is where it's getting more complicated... (though I guess this is where you guys usually start) When you have a query, and you type in your inputbox thingy like so: PeriodEnd: [Enter period end date dd/mm/yyyy: ] And you can have multiple, then it will prompt you for several...
  8. C

    I need my code to wait... (modal?)

    Hi I am importing a database, but I first need a couple of parameters from the user. Now I write this mostly in Access VBA, since I come from programming background. What I want to know is how can I let my code wait for the modal form to close before continueing? Thanks -Canderel Sub...
Back
Top Bottom