Search results

  1. J

    "cannot open any more databases"

    i have a report which has several subreports. Each one of these subreports uses many queries. I have never had any problems printing this report before, however, now when I go to print it i recieve the message "cannot open any more databases" and it prints only part of the report. I am having...
  2. J

    Q&A Database

    This may be the wrong messageboard for this. but you guys have always been helpful in the past, so here it goes. I would like to convert an old Symantec Q&A database to Access. What would be the best way to go about converting from this format. Not sure what version of Q&A the database is in...
  3. J

    Filtered Combobox in Continuous form

    I would like to filter a combobox in a continuous form according to the selection of another combobox in that record (e.g. 'Department' combobox selection determines available options in 'Employees' combobox). I would like to see the 'Employee' value in all records even though that value may...
  4. J

    calculated field in datasheet view

    just a quick question: is it possible to have a calculated field in the datasheet view of a form?
  5. J

    code to set run permissions on query's

    i want to set the 'Run Permission' property for all querys in my database to 'Owner'. There are around 400 querys in this database and i would not like to do it manually. can i do this programatically? ie. For Each query In my Database Run permission property = Owner Next
  6. J

    check if control has property

    I am trying to cycle through all fields in a form and check to see if the value has been modified. I am doing this by checking to see if control.OldValue = control.NewValue. I seem to be running into problems, however, when the property does not seem to exist. Is there any way that I could...
  7. J

    getting rgb values from a color

    i am trying to figure out a way to get the RGB values from a color. (e.g. if the ForeColor of a label is Green (65280), then i would like to find out that this is (0,255,0)). can anybody help me this this or give me an idea?
Back
Top Bottom