Search results

  1. S

    clearing yes/no field

    I wanna clear yes/no field from form, not its related record, but the field it self. like I ll have a button running macro or query by clicking it the yes no field will be cleared. find the example attached.. how will it be done please.
  2. S

    After converting Macro to Module?

    After converting, shull Macro be deleted or not?
  3. S

    Learning

    How easy Vb is ?
  4. S

    undo record in field

    If quantity requird less than stock qty don't accept record by delete or undo the record . how to do it without deleting the table data ?
  5. S

    Slow Running

    I am using Access 2003 but it is to slow, what can I do?
  6. S

    Analysing field

    I have this data in my table: Restaurants, Inc. (BJRI) Cheesecake Factory in (CAKE) P.F. Chang's China Bistro (PFCB) Panera Bread Company (PNRA) Rubio's Restaurants, Inc. (RUBO) Abercrombie & Fitch Co. (ANF) Aeropostale, Inc. (ARO)...
  7. S

    Copy

    I have tow tables – the same tables – first one is the main one, The second is the remain table, I need to enter data from one Form and adding the data automatically into the both, main one And the remain table. So how to do that?
  8. S

    Work time calculation

    Working Hours mater: I have this workshop, people work through : 1- Normal time *1.00 2- Over time *1.25 3- Week end time *1.50 If we know that the work leave time is 16.00 . How to calculate the over time hours for the case 2 & 3 . In my table I...
  9. S

    please i need help

    Please I need help Please people I need help , I'm doing a Work shop database system what is happing is this : I’m doing some of the work on my computer and some other Work in the office . my home MS OFF is XP the office MS OFF is 2000 , ,,,,, suddenly I’m tarring to do a query depending On...
  10. S

    disabling fields in form

    I’ve form, it is a work order form, and usually it takes more than one day To close the work order .So I am not going to use the data entry in the form Property, because it will hide every thing the time I close the form. I need a function such like on click the work order will be disabled ...
  11. S

    Dropdown menu prob

    As you can see in the database I attached, tow tables, in the operation Form I have got the drop down menu to choose from the Wrkcntr table, What is happening: each time you will choose from the drop down Menu it will repeat it self each time , if you change one all of them will Take the same...
  12. S

    how to send value ??

    Need help, I’ve got two forms x & y behind each of them table which is x & y, Car number in y is a primary key car number is secondary key in x, So in x form I’ll double click on the car number field, that will open the Y form, now, I want to double click on the car number field in the y...
  13. S

    requery

    I have this form with two fields, first one combo box which I'll pick Record from; depending on it the second field which is a query that Will run on enter. For example: Reg time: 10 – 12 (combo box record) Lab time: 10 – 11 (query) But what if I decide to change the...
  14. S

    user level security wizard

    I had discovered that when using the user-level security wizard I do not know the way to put the security system off. Plus, all Of the database systems I got on my computer will be blocked Except for the admin. So what to do I need help? please ...... :( :( :(
  15. S

    unbound sum textbox

    Hi, I am trying to make calculations in an unbound textbox, those Calculated number will be coming from a field formatted as a Standard number and 2 decimals digits … What’s happening is: in the unbound textbox I am getting results Like this: 10.20 + 10.40 = 20.00 but I would...
  16. S

    month data or month range

    I need a data in a date range, the date format are mm/yyyy, I have tried the: between [] and [], but it did not work!!! Query, which I am tiring to do depending on another query which Calculated the same field – which I want to get the date range from – So it will be like this: The first...
  17. S

    payment duration (date issue)

    This is purchase invoice due date issue: I’ve this table: Invoice number.......Number Date.....................Date/time.....MM/YYYY Duration time.........Number I am going to enter the month and the year – for the invoice -. The duration time will be after 1,2,3 and 4 month. So in the...
Back
Top Bottom