Search results

  1. N

    Short cut key

    Hi All, I have a table with field Trailer Left Date & Time as the "Primary key" which has General date as a format. Is it possible to have a short cut in such a way that I just enter time, but the table takes todays date and the time I provided as a record??? Thanks, Naveen
  2. N

    Duplicates in a table-Help needed

    Hi Everyone, I need help in selection of primary key and designing of a tables. I am having a table called Current trailers with Trailer number as a primary key. I have similar table to current trailers called history table in which the trailers that left the yard are stored. As a trailer...
  3. N

    Macro taking two clicks to run

    Hi, I have a button on a form, when we click the button it runs a macro. In a macro, I had it to open two queries(Append and Delete queries). I had to click twice. to run this macro. Macro runs fine when I try to run it from database.Can anyone suggest me regarding this. Thanks in Advance...
  4. N

    Taking more clicks to run a macro

    Hi, I am new to Access and I have created a macro and assigned it to a button on a form. When I update that form and hit that command button it not running the macro immediately. It is taking atleast 5-6 clicks to run that macro. Can anyone tell me how to correct this error. Thank You, Naveen
  5. N

    Macro not running through a Form

    Hi, On a form I have assigned a macro to a command button using command Button wizard. When I clicked the Button, the macro is not running whereas when I run a macro on a database it runs fine. Can anyone tell me what could be the problem with it. Thanks in advance Naveen
  6. N

    Selection of primary key

    Hi, I have current yards table with Trailer number as the primary key and which cannot have duplicates. When this trailer leaves the yard we send this record to History table. Now if a trailer comes again and leaves History table is not accepting as it is duplicating. So can anyone help in...
  7. N

    Delete Query on a form

    Hi, I have a form to which I update the information and hit a command button. Now this data has to be transfered to another form and get deleted from the original form. To acheive this I used Append and Delete Query(Both working). I have no problems assigning Append Query to a command, but...
  8. N

    To run two queries with a single command button

    Hi, I want to run a append query and a delete query by clicking a command button.Can anyone help me regarding this????? Thanks in Advance Naveen :confused:
  9. N

    Move record Macro

    Can any one help me in creating a Macro in which whole record is moved from one table to another table :confused:
  10. N

    Validation Rule-Help needed

    Hi, I just started working on Access, Can anyone one help me on a validation rule in which Text in one field should exactly match with the text in another field in the same table???? Thank You in Advance
Back
Top Bottom