Recent content by NaveenNandigam

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

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...

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...

Hi FoFa, The form updates the information about a trailer and as we click the command button, macro opens two queries(Append and Delete) and closes the form. Now it running if I click the command button twice. Moreover, Macro runs fine when I tried it directly from a database. Hope you...

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

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

Didnt use my head!! Dont worry I got it now ;)

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...

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...

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:

Record move Macro Thank You, My tables are setup in such a way that record should be moved from current table to History table once an action is completed. So can you help me how to incorporate this one.

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

Dont worry I found it, I just had to put name of the field in parentheses i.e. [Name of the field] :D :cool:

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