Search results

Hi all, Please could you perhaps point me in a direction to create a report similar to a Gantt chart I am not sure how to approach this I have a list of personnel They need to go on a trip for period x, return, and go on leave for a period Not all the personnel have the same rotation and...

Hi all, I have a saved PDF which I link to a form I het a message that there is a problem with adobe, If it is running, please exit and try again When I go to form design and back to form view. the PDF shows correct I am not sure how to correct this problem

Hi all, Please could you assist? I have to calculate the difference between 2 dates excluding weekends but not sure how

Hi all, Please could you assist? in a query If condition 1 is >=1 and condition 2 is >= 1 Display text Else do nothing I tried the below as a test but I get a expression invalid syntax Below only shows one condition as a test

Hi all, Please could you assist? I need to resize the second concatenation to a smaller text size (Reference 1) only

Hi all, Hope you are well I tried to concatenate with + if there are no data but getting errors Limit 1 and Unit 1 will always have data Limit 2 and Unit 2 might not always have data If Limit 2 has no data, I don't want to show the "/" Please could you assist?

Hi all, Please could you advise in any annunciation in the below code Replace could be the problem here I am getting a visual basic module containing a syntax error, compile error

Hi all, Hope all is well Please could you advise on converting below code for 32 and 64 bit computers

Hi all, Please could you assist I want to update a table from another table If the record does not exist, it must be updated If the the record exists and the date updated in the same as todays date in the table being updated (IW73 - Project Leader - History), the record should not be updated

Hi all, I am getting an object invalid or no longer set on the below code I am no sure why as this has been working fine for months Please could you lead me in the right direction to trouble shoot The query seems to be working correctly

Hi all, I want to use an Iff statement in a query If "Dummy" = false, then I only want to see all the record with dummy as false else, if there are no dummy = false in the records set, just show me dummy = True Basically I first want to filter dummy = false (10 records), if no, the I want to...

Hi all, I have a form where I select the Supplier In the product dropdown box, the product for this preferred supplier is listed on the top of the drop down box When the product dropdown list is selected and the supplier selected is the preferred supplier, I would like to highlight all the...

Hi all, I am joining 2 fields with a special character in between when no data, I dont want to see the special character I use the below code but gives an error any suggestions, sure I am missing something small? When there is no data, the form displays correctly When data is entered i get...

Hi All, Please could you assist? I need to create a query to multiply records in a new table After I have ordered a product that requires an expiry date and a batch number, i need to receive the product If 2 was ordered, I need to receive 1 and 1 to be able to add the batch number and the...

Hi all, Is it possible to make a union query from 2 other cross tab queries?

Hi all, Please could you advise on how to stop below code if no data

Hi all, On close current form, I an trying to do and action if another form is open It is not doing anything with below code and when I use the below code, I get a type mismatch error Please could you assist

Hi all, Has anyone encountered a Adobe Acrobat error 0:521 before? I have a form that displays the actual PDF of a record When I scroll through the records I can se the PDF Sometimes I get this error, when I select a different record and go back to the record that displayed the error, the PDF...

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

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