Search results

  1. M

    Changing Forecolor

    Hello, Am trying to change the forcolor of text in a label on a form based on the value from a report. I have added a text box called (Indicator) on the form that shows the same value from the report mentioned (control source: =[Reports]![rptIndicator]![AccessTotalsRevenue]) The following...
  2. M

    Values Repitition

    Hello everyone, I have many tables, these tables are details for each task of a project, (example, translation, directing, typing, etc...). The project has an ID number. Most of the tasks are performed by a signle person, but some have more persons. I am trying to create report to show all...
  3. M

    Use Button on Main form to ALSO control the subform

    Hi Everyone, I have a main form and a subform, I created a button to close the form and popup a msgbox with vbYesNoCancel if i need to save. All is working well, but when changes are made to the subform and close the form from the button, it is not working properly. When I choose not to save...
  4. M

    Requry a Query

    Hi Everyone, I have query that runs from an input form, everything is fine, but when ever i got back to the input form and change the value of combobox, where the query has change the records it gives it wont do this automatically i have to hit refresh button on the query to the new result, it...
  5. M

    Select Case or If Then Statement

    Hello, I dont know if i am correct, but I am writing a Select Case statement or and if then statement, but it does not seem to work if the source type is a table/query type, which is linked to a table? if so, is there a way the select case can work while keeping it in a table/query row source...
  6. M

    Select Case of If Then Statement

    Hello, I dont know if i am correct, but i am writing a Select Case statement or and if then statement, but it does not seem to work if the source type is a table/query type? if so, is there a way the select case can work if the while keeping it in a table/query row source type? many thanks
  7. M

    If & Select Case Codes

    Hello, I have a form which includes the following fields, Dispatch Method (Combobox) AWB (Text Box) Tape Format (Combobox) Dispatch Method has the following choices; DHL, FEDEX, UPS, Sky Net, Satellite & Email. I want "AWB" and "Tape Format" to be disabled when I choose "Email" as...
  8. M

    Repetitive Fields

    Hello Everyone, I have many tables for certain tasks, for a certain job. The tob has an ID number, the title of the program episode title duration etc.. The tasks table are for example, translation, proof reading, typing directing, audio mixing voice over. Now for each program, mostlyone...
  9. M

    Update the Foreign Key

    Hello, I am currently working on a DB, where the main table is linked to many other tables, the main table is linked to the other tables in the foreign keys. The main table has information of a product which is required to be produced for a client, and another table the dispatch has...
Back
Top Bottom