Recent content by UchihaSake

I've got it working!!! Thank you SOOOOOOO much for the help guys! I appreaciate it a LOT!!! :)

Well here's the SQL code: INSERT INTO [Waiting List] ( [Enquiry Date], [Enq No], [Vessel Name], [Length(m)], [Breadth(m)], Owner, ETA, [Agent Name], [Tel no/ e-mail], Remarks, [Type of Vessel], [Response Sent Date] ) SELECT [Enquiry Table].[Enquiry Date], [Enquiry Table].[Enq No], [Enquiry...

My form is open but it still says "enter perimeter values" Thanks, UchihaSake

I want to move them in order to organise the records. For example if i send a waiting list e-mail then the record should be moved form the Enquiry table to the Waiting List.

Hmm... It keeps saying "enter perimeter values". Is it possible to set it as the record i am currently viewing by clicking a button located on the form? Thanks for the help, UchihaSake

Well I am trying to make a system for requesting docking. Basically the ship sends an enquiry to the shipyard requesting docking space. So, first an e-mail confirming receipt is sent, afterwards in accordance to the scedule either an email saying the vessel is on the waiting-list or an email...

Thanks for the swift reply John! But is it possible to cut and paste one record at a time? For example i have 3 records on table A. In the form i want to click a button that will transport it to Table B and delete the record from table A. The Delete and Append seem to add everything in my table...

Is it possible to cut a record from a table/form and paste it on to another table/form using Visual Basic?? I couldn't find it after a few hours of googling:( so i tried playing around with the code (which failed horribly:mad:) Any help will be greatly appreciated. Thanks, UchihaSake