Search results

The sample is from my duplicates query I now need to identify one record of the duplicates to keep and delete the balance

Hi all, Please could you assist I have a table with plenty of duplicates which I need to remove and leave 1 record I tried copying to a new table with no duplicates set but wont work I have 5 criteria's to keep in mind when removing records 1. Category - Airframe and Engine 2 Type - could be...

In my code after I made the alterations to the new form I only had the below code to Extract the exchange rate When I looked at the sample arnelgp provided, I noticed that I did not requery the main form after I have updated the required date to enable the code to run for extracting the...

Thank you so much arnelgp Works perfect

Hi Pat, I did some debugging, yes there was no output As mentioned before, the original code works well I had to make an amendment to another form as I am importing this time and not raising a new PO All the other date required for the code to run has been updated before I run this exchange...

Hi Yes I was acting on post 4, had no effect

I was thinking the same thing, I was trying different situations with the parent/child forms but had no success So yes I 100% agree with you and by trying to solve this, I have a few confusing moments If I run all my queries from the subform and then just click the command on the main form, it...

I did the debugging as suggested No I did not get an output as required Although, the I do the process as before I do get an output The change I made was to have the option to create a purchase order or to pull in a requisition if one was created By creating a new PO, works perfect when...

I think I need to ask arnelgp to have a look as this one, code supplied by arnelgp The code works well in my other forms, I hade to make some amendments to this form as the setup has changed a bit When I have a pre entered purchase requisition, I want to be able to select the transaction from...

I am getting a run time error 94, invalid use of null PurchaseOrder_Order is the main form PurchaseOrderOrderSubForm is the sub form Did not think it was necessary to define the form which should close as it will close the form in focus, not so? The code to extract the exchange rate: Below...

Hi all, I have a subform where I select the transaction to be imported into the main form After import, I need to run the below command This unfortunately does not work as for some reason it is giving me an error down the function coding of the exchange rate lookup If I create a button on...

Thank you everyone for the input I managed to get the required result My transactions table has one Qty field I added a stock location field All stock received and Invoiced comes from Location 1 unless sold from another location When transferred from / To, I do a 2 line transaction, debit and...

I am just not sure how to do this via an update without have multiple queries for each instance Main to hub Main to airport main to Laura Or even airport to Laura ext. this would then be a multiple of about 25 queries which I dont want so what I am thinking of is when from = Main office and...

Hi all, I am struggling to get this one going and was hoping to get some assistance I have a table where all qty's of products are recorded for stock procured and stock sold I want to be able to transfer manufactured stock between different locations So what I need to do is have a form where...

Thank you Did not know It would automatically create a form I first created the form then dragged the query But dragging the query onto the main form worked well

Yes I am using 2016

Hi all, Any reason why the cross tab query on a form would display as below? I have to click click on the + first to display the query

Hi all, Is it possible to have a crosstab query in a form? When the crosstab query gets added coulombs as the data changes or added, such as months, how will this be automatically be added in the form as the form are set in the controls created

Yes, it is the same DB, I Debug and compile often

Currently I dont receive any runtime errors I was also thinking of just closing and opening the form but I wanted to do it the correct way Products are updated or amended in the main Products form only There ae no subforms on the products form